Moritz Trollmann

Importing CSV with special characters in UTF8

Blog Post created by Moritz Trollmann on Oct 26, 2016

Some of you share the pain of having to import contacts into Marketo that contain special characters.

The fix to get these inserted correctly into Marketo & your CRM system is to save the CSV with UTF8 formatting.

 

Unfortunately Excel does not allow direct saving of CSV files with UTF8 so the work around I used so far was to save the excel file as a csv, open it in Notepad and saving it again with UTF8 formatting.

 

Doing this a couple of times is time consuming so I searched the internet and found this Add on for Excel which allows you to directly save csv files with UTF8 formatting.

 

https://jaimonmathew.wordpress.com/2011/08/23/excel_addin_to_work_with_unicode_csv/

 

Installing it will add another Tag to your excel instance called “Unicode csv” that contains 2 new Save buttons.

 

BR,

Moritz

Outcomes