Prepare your CSV import file

Table of Contents:

After you export data from your current system(s), you should take time to clean it up before importing it into Infusionsoft. Data must be in a .CSV format; it’s the only acceptable file type. Here are a few recommendations that will help your import go more smoothly.

Remove any irrelevant data

Remove duplicate columns and columns that store information you won't need in Infusionsoft to segment, communicate, or produce reports.

Delete empty rows and columns

Blank rows and columns will corrupt the import.

Make the column headers clear and concise

If there are any confusing or unclear headers in your data, this can cause data to be imported to the wrong areas.

Ensure the column headers accurately describe the column of data

If the headers are wrong, the data will be imported into the wrong areas.

Correctly format all dates

MM-DD-YYYY, MM/DD/YYYY, YYYY-MM-DD, and YYYY/MM/DD are all acceptable date formats.

Place multiple phone numbers into separate columns

Multiple phone numbers within a single phone field will cause data to be imported improperly.

Phone extensions must be in a separate column

Text or an extension within a phone field will cause an improper import.

Addresses must be separated into different columns

A single field for a full address will cause data to be imported improperly.

Fully spell out country names

Abbreviations for countries will cause data to be imported improperly.

Separate multiple tags with a comma (if you want to import a column of data as a tag.)

Any column imported as a tag, without comma separation, will cause erroneous tag names.

Make sure you are not importing contacts who have opted out of your email marketing!

You will run into SPAM issues if you import people who have opted-out!

Do not try to import contact IDs as that will break the import!

Was this article helpful?
Thank you for your feedback!