The main showstoppers when creating new records in Salesforce are mandatory fields of the object (table) you’re creating records in, and validation rules that can prevent you from creating your records. But these are usually pretty easy to figure out since Salesforce gives you clear error messages in case something goes wrong. Note, if you have a lot of triggers in your system, you may need to go hunting in other objects to find the validation rule that’s preventing your record creation. The other thing to watch out for is data values that don’t conform to existing picklist values in SFDC: these and other constraints are set in each of the fields’ definition page in SFDC’s setup area.

To create new records in Salesforce you will only need a spreadsheet with your data. Note that rows that are completely blank or columns without field names in the header (first) row will cause problems…so, make sure you don’t have those!

In this example we’ll use an example of loading 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:

  1. Log in to Salesforce by clicking the Log in button (you can also use Web Login).
  2. Select values in Excel so that your selection spans across all rows, e.g.:
  3. Click Insert in the XL-Connector ribbon.
  4. Click OK in the information dialog box.
  5. Select the object you’re loading records into in the next dialog box, in this case the object is Contact:
  6. Click OK, then carefully read the warning that is shown before the mapping dialog, and click OK in it.
  7. In the mapping dialog box 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:
  8. 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.

Video: