Data Load Address Field into Salesforce

Ever had to data load into the address field in Salesforce, but find the address always goes onto the same line? In this quick post, I am going to show you how to ensure the address data is tabbed onto separate lines. For our example, we are going to data load to the billing address field on the Account object.

In a Few Simple Steps….

Prepare CSV for data load

**Insert Column based on your data. I am referencing my example.

but before you import add a column in between D & E as we need to consolidate columns B, C, and D.

Add the following formula to column E and adjust the range appropriately. For my example column B to D.

=TEXTJOIN(CHAR(10), TRUE, B2:D2)

Under Home TAB, select Wrap Text to see the results as above.

Great work the file is now ready to load into Salesforce, save as a CSV.

Open Data Loader and map our newly created Field Full Address to Billing Street.

To note, you can use other data loading tools for this such as dataloader.io

Confirm and save mapping, you have now successfully carried out a Data Load to the Address Field into Salesforce, and here is the result.

Find out more

We’ve been in the Sales and Marketing Strategy game for longer than we care to remember, but we pride ourselves on the combined exposure our team has had to different B2B markets globally, and the strategic services we offer your business as a result.

If you are looking for Salesforce / Pardot Support with an existing Org or want to know if Salesforce or Pardot is right for you, get in touch with us for a free consultation or simply a chat. We regularly work alongside Start-ups and Enterprises alike, so we’re certain we will find you a path to growth, whatever your plans.

We are open Monday-Friday 9-6pm and have open channels for communication either on our LinkedIn, Twitter or you can simply give us a call on 020 8106 8500.

Salesforce Consulting Partner