Importing data from a spreadsheet (CSV) file

The spreadsheet (CSV) file data source allows you import your customer/people and organization data from a CSV file to your Autopilot account’s customer data platform (CDP).

CSV file prerequisites

This process assumes that you have a valid CSV format file whose first row of columns match* field names defined in your Autopilot account’s CDP. Each "column" represents a set of vertical values down each line of the CSV file, delimited by the same number of commas from the start of each line.

Your CSV file does not need to contain every field defined in your CDP. Only a subset of fields is required, which meets the following criteria:

  • The minimum fields required are: First name, Last name, and Email address.

  • The format of your date data must match the format set in your General settings.

If you are working with a spreadsheet file, then use your spreadsheet application to export each of the spreadsheet file’s relevant pages into individual CSV files, and upload each one of these CSV files separately to Autopilot.

* The field names defined in the header row of your CSV file do not need to match those defined in your CDP. Autopilot will automatically attempt to match these as part of the data import process. However, it is assumed that each column of data in your CSV file is valid for each field defined in the first row.

Upload your spreadsheet (CSV) file

If you initially followed the Configuring a new data source procedure, use this procedure to complete integrating your CSV file’s data into your Autopilot account’s CDP.

  1. Assuming you have clicked through Popular / CRM  Spreadsheet import  Get started (from the New data source page), on the Upload spreadsheet page, drag and drop your CSV file into the dashed rectangular area of this page.
    Alternatively, click the or browse for the file on your computer link in the center of the page to browse for your CSV file to upload to Autopilot.

  2. Click Next to open the Map the columns to a field page.
    On this page, Autopilot attempts to match the columns defined in the header of your CSV file to field names defined in your CDP. If matches are found, then Autopilot automatically applies the appropriate field defined in your CDP to the field name defined in your CSV file’s header, indicated in the Spreadsheet columns section of the page.

  3. If any of these field name matches are incorrect, then drag the appropriate field defined in your Autopilot account from the CDP fields section of the page over the field name defined in your CSV file’s head in the Spreadsheet columns section.
    The existing mismatched CDP field is replaced with your new choice, and the old CDP field moves back to the CDP fields section.

    If the list of CDP fields is too long, you can search and filter this list. At this point, you can also add a new CDP field, if any of the existing CDP fields are not suitable.
  4. Click Next.

  5. On the Tag page, click Add tag to begin adding a new tag (by typing its text and clicking Create to create the new tag) or selecting one from the existing list of tags.
    Similar to searching existing CDP fields in the previous step, if the list of existing tags is extensive, you can filter this list itself by typing one or more consecutive letters into the Type to search box.

    Tags are useful for filtering and grouping people and organizations (each being a record) within your CDP. For example, you can utilize tags to help move your CDP records from one playbook to another, control which CDP records enter a playbook, group CDP records created or updated from different CSV file imports, and so on. Note that an existing tag consisting of the name of your CSV file, as well as the date and time of import is automatically applied to all people and organizations data imported into your Autopilot account through this CSV file.
  6. Click Next.

  7. On the Select a merge option for duplicates, choose the appropriate merge option to determine how Autopilot behaves when integrating any existing people or organization data in your CSV file into Autopilot.
    By default, Autopilot uses the following data values as unique identifiers for:

    • a person - their email address, followed by their phone number (as a fallback), and

    • an organization - its name.

    Autopilot merges lines in your CSV file, each representing a person or organization whose unique identifier values match those of existing people and organizations defined in your CDP. Note that these unique identifier fields can be customized.

  8. Click Done to commence the import.

  9. Once the import process starts and your CSV data is initially uploaded, then synced, and completed when Import complete is shown, click Done again (or X at the top) to return to the Data sources page.

    If your CSV file is large and the syncing process takes a while, you can click Done again (or X at the top) from when the syncing process beings to return to the Data sources page. Syncing will complete in the background and Autopilot notifies you of when the import is completed.

Searching existing CDP fields

If the list of CDP fields is extensive, you can filter this list itself by typing one or more consecutive letters into the Search box, and any of these fields whose names do not match these letters are dynamically excluded from the list as you type.

You can then select and/or clear the remaining CDP fields on this list.

Clearing the Search box, or clicking X restores all CDP fields to the list.

Adding a new CDP field

If your Autopilot account’s existing CDP fields are not suitable for one or more columns of data in the CSV file you are importing, you can create a new CDP field to map to your CSV file column.

To do so:

  1. Click Add a new field.

  2. In the New custom field dialog, specify the Field name and Field type for your new CDP field.

  3. Click OK and the new CDP field appears at the top of the CDP fields section list.
    You can now drag this field across to the appropriate CSV file column in the Spreadsheet columns section of the page.