Re: Special Characters when downloading data from marketo

Nicholas_Manojl
Level 9

Re: Special Characters when downloading data from marketo

It needs to be tab delimited for these versions of Excel. Interesting that the newer version of Excel that Tofa is using is correctly importing the character encoding.

Nicholas_Manojl
Level 9

Re: Special Characters when downloading data from marketo

You need to download the file as a Tab Delimited txt:

pastedImage_0.png

Then, your computer will probably open the file in a text editor. Copy this text and paste it into your favourite spreadsheet program, or open the txt file directly using Excel etc..

Anonymous
Not applicable

Re: Special Characters when downloading data from marketo

Hi Tofa, as Nicolas said you can use Tab delimited format. Specially you can use file type as UTF-8 file formatting while saving (do save as with UTF-8) which maintains the special characters. This will be useful for both import and export.

Anonymous
Not applicable

Re: Special Characters when downloading data from marketo

To create an automatic report, I don't have the option to download as a UTF-8 file.

When the report is delivered, it needs to be readable, meaning my MDs shouldn't have to upload/download, resave into different file types...especially when I'm dealing across different languages.