To create new records in Salesforce you will only need a spreadsheet with your data.

In this post we’ll use an example of loading Leads as this is probably the most common scenario in any CRM. Here’s the spreadsheet that we need to load:

To load the above Leads you’ll need to do the following:

  1. Log in to Salesforce.
  2. Select cells in your sheet so that your selection spans across all rows that you want to insert (it doesn’t matter if the selection spans across one or multiple columns), e.g.:
  3. On the Add-ons menu, click G-Connector for Salesforce -> Update/Insert/Upsert Selected Rows.
  4. The following dialog box will show up:

    From the drop-downs up top select Insert and Lead, as you will be creating records in the Lead object.
  5. G-Connector will try to map your columns for you, but you need to verify if the mappings are correct before proceeding. Mappings are shown in the bottom table (see dialog box above) where spreadsheet column names show up in the Column in Spreadsheet column, and fields these spreadsheet columns are mapped to – in the Field Name in Salesforce column.
    The top table will list all available fields from the selected object. You can map your spreadsheet columns to fields in Salesforce by dragging fields from the top table and dropping them on the column names in the bottom table.
  6. Give your template a name and click on Save Template to store your settings as a template for future use (optional)
  7. Now click Push Selected Rows and your Leads will be loaded into Salesforce.
  8. After the Insert operation has been completed, you’ll see the operation results on the very right from your data, one column over after the last data column: