Importing Unicode Data into Marketo

[#1]

Due to the way Excel handles CSV files with unicode data, you may need to follow these steps for importing the file into Marketo as UTF-8 data:

1. Set up your Excel spreadsheet properly for your import (for example, removing unnecessary columns)
2. Select all the data in the spreadsheet. Copy it to the clipboard (control-c in Windows, command-c in OS X)
3. Paste the data into a text editor -- Notepad in Windows, TextEdit in OS XSave the file. In the "Save As" dialog, pick the UTF-8 option in the Encoding section at the bottom of the dialog
   • In TextEdit, set the file to text only using Format -> Make Plain Text before pasting
4. Save the file. In the "Save As" dialog, pick the UTF-8 option in the Encoding section at the bottom of the dialog
5. Import the file into Marketo as a "Tab-separated values" file

Your unicode characters should import correctly.