SOLVED

Exported list creates a single column of all values (in select European countries)

Go to solution
Dan_Stevens_
Level 10 - Champion Alumni

Exported list creates a single column of all values (in select European countries)

Some of our marketers in Europe (e.g., Spain, Italy) are experiencing issues when exporting lists/views from Marketo as CSV files.  When opening the file in Excel, there is a single column of all of the fields/values (all contained in column 'A'), instead of individual columns for each field/value:

pastedImage_0.png

Have any of you experienced this?  And if so, how did you resolve?  When the file is sent to me, it opens fine, and as expected (except for the special characters not displaying properly - this can be fixed by exporting out as a tab-delimited file.

Grégoire Michel

1 ACCEPTED SOLUTION

Accepted Solutions
Grégoire_Miche2
Level 10

Re: Exported list creates a single column of all values (in select European countries)

Hi Dan,

Sorry for not answering faster.

This is because MS Excel, in latin countries, uses by default semicolons as value separators instead of commas. The opposite happens when you save an excel file in CSV format : you get a "semicolon" separated file. Somehow, for Microsoft, the "C" in CSV means "semicolon". Someone there has to have some serious language problems

The easy fix is to decode the data in Excel, using "Data" -> "convert" menu.

For a more permanent fix, you can change "locales" in your windows (this is done in the config panel), but be aware that this might have some consequences on other software that do it right.

Excel 2016 has the capability to better manage this when exporting, you now have a "true CSV" option when exporting.

-Greg

View solution in original post

3 REPLIES 3
Grégoire_Miche2
Level 10

Re: Exported list creates a single column of all values (in select European countries)

Hi Dan,

Sorry for not answering faster.

This is because MS Excel, in latin countries, uses by default semicolons as value separators instead of commas. The opposite happens when you save an excel file in CSV format : you get a "semicolon" separated file. Somehow, for Microsoft, the "C" in CSV means "semicolon". Someone there has to have some serious language problems

The easy fix is to decode the data in Excel, using "Data" -> "convert" menu.

For a more permanent fix, you can change "locales" in your windows (this is done in the config panel), but be aware that this might have some consequences on other software that do it right.

Excel 2016 has the capability to better manage this when exporting, you now have a "true CSV" option when exporting.

-Greg

Dan_Stevens_
Level 10 - Champion Alumni

Re: Exported list creates a single column of all values (in select European countries)

Thanks Greg - this is exactly the information we were looking for!

Grégoire_Miche2
Level 10

Re: Exported list creates a single column of all values (in select European countries)

You are welcome

-Greg