Error Importing Lists in Pardot – How to fix it

Sometimes we would like to import a list of prospects to Pardot who have attended one of our events. We have collected and sorted the list with the most important data. Pardot will ask us to save the Excel list in .csv format using UTF-8 character encoding to preserve special characters, would it be the prospect’s name, company name, or additional custom fields.

Here is an example how it looks like when you import a file saved in .csv with UTF-8 character encoding:

Note that the correct format in Pardot should be:
Email [email protected]
Company company name ABC

In order to correct the errors, open the .CSV file that you have saved:

In Column C, enter the following formula: =A1&”,”&B1

  • Copy column C, and paste it again in column C to remove the formula, but keep the values.
  • Delete column A email, and column B company
  • Save your document
  • Import it again in Pardot

By Marija Milanova

Passionate marketing automation expert with understanding of business objectives and translating the objectives into automated processes in various Marketing Automation platforms.