Question mark characters on list import | Community
Skip to main content
A
Anonymous
March 20, 2015
Solved

Question mark characters on list import

  • March 20, 2015
  • 2 replies
  • 1326 views
Hi

I have a list in Excel and some of the details have Acute, Grave, and Diaeresis characters.

In Excel they display OK, in CSV they display OK (using notepad to view), but once the list is imported into Marketo, these characters are replaced with black diamonds containing question marks.  The CSV is saved as UTF-8.

Any ideas?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Josh_Hill13
My understanding is this is caused by how Windows saves UTF8.

If you are using Windows, you may have to Save in CSV, then open that in Notepad, then copy and paste that back into CSV file.

Or maybe re-save the file as UTF 8 in Notepad.

2 replies

Josh_Hill13
Josh_Hill13Accepted solution
Level 10
March 20, 2015
My understanding is this is caused by how Windows saves UTF8.

If you are using Windows, you may have to Save in CSV, then open that in Notepad, then copy and paste that back into CSV file.

Or maybe re-save the file as UTF 8 in Notepad.
A
Anonymous
March 20, 2015
Thanks Josh.

I opened the CSV in notepad and re-saved as UTF-8 and it imported perfectly.
Terms & ConditionsAccessibility statement

Loading footer...