SOLVED

Difference between "Comma Separated Values" and "Comma-Separated Values (Windows Excel 2007)" when exporting leads

Go to solution
Pavel_Plachky
Level 5

Difference between "Comma Separated Values" and "Comma-Separated Values (Windows Excel 2007)" when exporting leads

When exporting list of leads, there are several format options on the Export dialog box as follows:

pastedImage_0.png

Does anybody know what is the difference between the different formats? I am mainly interested in the way special characters (and character sets) are handled in each format. The documentation at Export Leads to Excel from a List or Smart List - Marketo Docs - Product Docs  is not covering the topic at all.

1 ACCEPTED SOLUTION

Accepted Solutions
SydneyMulligan
Level 10 - Champion Alumni

Re: Difference between "Comma Separated Values" and "Comma-Separated Values (Windows Excel 2007)" when exporting leads

I believe the Excel 2007 uses UTF-8 encoding, which may be better for special characters.

View solution in original post

1 REPLY 1
SydneyMulligan
Level 10 - Champion Alumni

Re: Difference between "Comma Separated Values" and "Comma-Separated Values (Windows Excel 2007)" when exporting leads

I believe the Excel 2007 uses UTF-8 encoding, which may be better for special characters.