List Upload with European letters

Question

Hello,

I am trying to do a list upload into Marketo.  We are currently using Marketo throughout our company in 9 different countries.  Whenever I upload a list that is in Swedish, Norweigan, German, or any country that has different characters or accents, the characters don’t come through and I have to manually go into ever record to update them.  Is there a way to upload a list where these characters can come through?

Dan_Stevens_ · Accepted Answer

This is actually very simple. Just save the Excel file as a Unicode Text file (instead of CSV). During the import process, just make sure you select "tab delimitted" as the file format (in fact, you should ALWAYS select the appropriate file format regardless of the format). Works perfectly every time.

Casey_Grimes2 · Answer

Hi Michael,The key to preserving special characters when doing list uploads is to make sure that your list is saved with UTF-8 formatting. Excel, by default, formats entries as Windows-1252, which results in the special characters you mention getting mangled.Unfortunately, Excel doesn't offer an out-of-the-box option for writing UTF-8 CSVs, so you need a plugin like this, use software like OpenOffice/LibreOffice to make your lists, or do a Notepad workaround as described here.

Sign up

Login with SSO

Login to the community

Login with SSO