Re: List Upload with European letters

Anonymous · ‎02-20-2015

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_ · ‎02-21-2015

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.

View solution in original post

Casey_Grimes · ‎02-20-2015

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.

Josh_Hill13 · ‎02-20-2015

Are you saving the CSV as UTF 8 format? Try a couple of test leads and import them that way.

Dan_Stevens_ · ‎02-21-2015

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.

Abaran · ‎05-25-2016

Hi Dan

Unfortunately this is not working for me . I also tried the method describe on SFDC support page. Same issues

Axel

Dan_Stevens_ · ‎05-25-2016

Have a look at this recent idea: . Is it possible you're experiencing these same issues?

Colin_Mann · ‎05-25-2016

Thanks Dan, I've had the same issue and thought there was probably a simple solution.

Anonymous · ‎02-23-2015

Thank you all for the help and guidance. This worked perfectly. Saving it in UTF 8 Format (UTF 16 for my mac) and uploading it with the tab delimited file format works great. Thanks again!

Anonymous · ‎12-09-2015

Yes I confirm ! I've saved in UTF 16 and use the tab delimited file format. Thanx a lot !