SOLVED

Question mark characters on list import

Go to solution
Anonymous
Not applicable

Question mark characters on list import

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?
Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Josh_Hill13
Level 10 - Champion Alumni

Re: Question mark characters on list import

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.

View solution in original post

2 REPLIES 2
Josh_Hill13
Level 10 - Champion Alumni

Re: Question mark characters on list import

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.
Anonymous
Not applicable

Re: Question mark characters on list import

Thanks Josh.

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