Creating New Records in Salesforce
To create new records in Salesforce you will only need a spreadsheet with your data.
In this example we’ll load Contacts as this is probably the most common scenario in any CRM. Here’s the spreadsheet that we need to load:
To load the above contacts to the following:
- Log in to Salesforce by clicking the Log in button (you can also use Web Login).
- Select values in Excel so that your selection spans across all rows, e.g.:
- Click Insert in the XL-Connector ribbon.
- Click OK in the information dialog box.
- In the mapping dialog, select the object you’re loading records into in the next dialog box, in this case the object is Contact.
- Then map your Excel columns to fields in Salesforce by dragging fields from the top table and dropping them on the columns in the bottom table. In our example the mappings will look as follows:
- Now click OK and your contacts will be loaded into Salesforce under the corresponding accounts. You’ll note that XL-Connector provides the ID numbers for the newly created records or error messages explaining why not, to the right of your original spreadsheet rows, one column over.