Download Leads List in different lanugages | Community
Skip to main content
J
Julz_James
Level 8
March 6, 2015
Solved

Download Leads List in different lanugages

  • March 6, 2015
  • 2 replies
  • 1228 views
Hi there,

I've got a set of data in my Marketo which is from France, so there are names with different characters etc in there.  Most of these show up fine in Marketo (in the smart list I've created), however when I export these leads and open in Excel the special characters have all done awry.

Can anyone help?

Thanks

Juli
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
The joys of excel.... Csv files in excel are notoriously fussy in MS Excel. I haven't really got to the bottom of what setting excel expects and why csv don't jst default to UTF-8 which would mean all character would display just fine. If you want to keep opening in MS excel then Save the file and before opening it you need to right click and open with notepad. Note pad will then give you the option to save as utf8. Then open a blank excel sheet and go to File -> open, find your txt file then a little wizard will pop up, select delimited in step 1, step 2 select comma (semi-colon if that's what you see in the preview).

Alternatively download open office and use there spreadsheet program to open it and it will give you the option to select utf8 and will displa the charachter without effort.

2 replies

A
Anonymous
Accepted solution
March 6, 2015
The joys of excel.... Csv files in excel are notoriously fussy in MS Excel. I haven't really got to the bottom of what setting excel expects and why csv don't jst default to UTF-8 which would mean all character would display just fine. If you want to keep opening in MS excel then Save the file and before opening it you need to right click and open with notepad. Note pad will then give you the option to save as utf8. Then open a blank excel sheet and go to File -> open, find your txt file then a little wizard will pop up, select delimited in step 1, step 2 select comma (semi-colon if that's what you see in the preview).

Alternatively download open office and use there spreadsheet program to open it and it will give you the option to select utf8 and will displa the charachter without effort.
J
Julz_JamesAuthor
Level 8
March 6, 2015
Wow!  Thanks for the response...glad its not just me having the problems then!  I'll give that a go and see what what happens.   Good old Excel!

Thanks

Juli
Terms & ConditionsAccessibility statement

Loading footer...