Trying to import a file that’s not in English? The list looks perfect when you open it up with Excel.
But when you import it into Marketo, you might see that the non-English characters aren’t picked up correctly.
This is because the file is not saved properly for Marketo to recognize all the non-Latin characters. The good news is, there are a few simple steps you can follow to fix it.
Select Save As… from the File menu in Excel.
Choose UTF-16 Unicode Text (.txt) as the Format option. This will encode the file the way Marketo can display them.
Marketo also supports UTF-8, Shift-JIS, or EUC-JP.
Excel will save the new file as a Text File with a .txt extension. But it also converts all the commas in the file into tabs. We need to change it back.
You can open the Text File using Notepad if you are using Windows or TextEdit if you are using a Mac.
Select a tab from the document and copy it.
Select Find and Replace… from the Edit menu.
The equivalent action for Windows users is: Edit > Replace…
Paste the tab you copied in step 4 into the first (to be replaced) box, and type in a comma in the second (replace with) box. And click All.
And voila, all the commas are back and we are ready to roll.
Import the new file into Marketo, and the information should be displayed correctly this time.
Any date/time fields being imported are treated as Central Time. If you have date/time fields in a different time zone, you can use an Excel formula to transform it to Central Time (America/Chicago).
We know this is weird, but it works. Happy Importing!