Importing Unicode Data into Marketo

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.