Have you suffered from foreign language letters issues? | Community
Skip to main content
Ronen-Was-SRpro
New Participant
July 7, 2018
Solved

Have you suffered from foreign language letters issues?

  • July 7, 2018
  • 1 reply
  • 1400 views

In some cases, I've seen foreign language letters that became question marks when imported lists from Excel.

Have you seen that as well?

My best solution was to use Google Spreadsheet, but I think it's too tedious, any other ideas how to solve this?

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 SanfordWhiteman

You want to save as the format Excel calls "Unicode Text."

This format is specifically tab-delimited UTF-16 LE with BOM (Little Endian encoding with explicit Byte Order Mark). You don't need to know exactly what that means, but suffice it to say that while it's not “The One True Unicode," it's the format that is the most tightly supported by Marketo.

(Do you have a bot following you around liking and helpful-ing your posts 8 or 9 times? This is looking pretty crazy.)

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
July 7, 2018

You want to save as the format Excel calls "Unicode Text."

This format is specifically tab-delimited UTF-16 LE with BOM (Little Endian encoding with explicit Byte Order Mark). You don't need to know exactly what that means, but suffice it to say that while it's not “The One True Unicode," it's the format that is the most tightly supported by Marketo.

(Do you have a bot following you around liking and helpful-ing your posts 8 or 9 times? This is looking pretty crazy.)