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 xyz@company.com
Company company name ABC
etc..

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

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