Issues with Unicode uploads

[Josh_Hill13]

Interesting thread. I had an odd thing yesterday that was likely related to Excel 2011 Mac where I saved as CSV, but Marketo claimed it had an "Unclosed quotation" which I had not noticed before. I looked at the text file and it had somehow created a mess on the header. When I opened in Excel again, the first two rows were misaligned.

Then I saved as Windows CSV with no further problems.

I know there are better Mac text editors that'd help here. Hope this is fixed soon.

[SanfordWhiteman]

But no non-Latin-1 characters in there, yes?  Windows CSV uses Windows-1252 so you can store

     þþþ

but not

     āāā

(to use an example of crossing the character boundary from #255 to #257)

[SanfordWhiteman]

Blogged at http://blog.teknkl.com/fixing-the-current-excel-marketo-list-import-bug-unicode-characters/​

Spread the word!

[Gary_Verster2]

Thanks, Sandford. As per Dan's reply, thanks for working on this and coming up with an interim solution.

That said, I won't be retraining my marketers on how to upload using this process just yet... explaining that they need to enable macro's and then showing them how to run the fix is probably a step too far for more than a few of them, especially if it's an interim fix. But it will definitely help me to fill the gap myself more painlessly in the meantime!

Thanks, chap!

[Dan_Stevens_]

On Monday (3/27), engineering pushed a patch into production to address this.  I did hear back from my team and they confirmed that the Unicode import is now working as expected.