Best practices for Data Import

Although is quite flexible at understanding your import data, there are certain formatting details you need to be careful with when preparing your import files. Sometimes a seemingly insignificant hiccup can lead to the entire file becoming unreadable to a machine. By following these simple best practices you can safely avoid running into that situation:

  • Use a spreadsheet program such as Microsoft Excel to create your CSV file.
  • Save the CSV file in UTF-8 format.
  • Make sure you don't have any duplicated or empty headers.
  • The first row of your file should contain the column headers, such as First Name, Last Name or Profit. 
  • The import process is easier when the file structure resembles the object structure in Salesforce. The column headers are automatically mapped to Salesforce fields, and you do not need to manually map them.
  • Make sure all your date fields are formatted correctly.
  • Keep your files at a maximum size of 50MB.
  • When dealing with files that are larger than 200 rows, pick the Bulk API option in the final window of the create task wizard. This will give you an optimum performance for large files.
  • If any errors do still occur, you can always check the results files that are generated when tasks are run, they can be a big help in understanding what went wrong. You can see and download these files on the tasks list page, next to each task.