Importing Unicode Data into Marketo

Document created by 9588451ecc601f1a2620c0a3338f73ddec06dbf4 on Dec 30, 2014Last modified by 9588451ecc601f1a2620c0a3338f73ddec06dbf4 on Jan 16, 2015
Version 3Show Document
  • View in full screen mode

Due to the way Excel handles CSV files with unicode data, you 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.

Attachments

    Outcomes