Order of columns in export spreadsheet that is not matching the view

Forum|Forum|12 years ago
July 17, 2013
6 replies
1816 views

Hi,

I'm exporting a series of smart lists, all with the exact same customized view. 9/10 the order of columns matchs and 1/10 it doesn't. I re-export spreadsheet and this is fine. Have you also noticed that? This drives me crazy!

Cécile

Marketo

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

There isn't a preferences setting that controls the default. I'm surpprised that regular CSV rearranges your column order. You may want to open a case with tech support.

A

Anonymous

The only thing that I've noticed is that the SFDC ID and SFDC Campaign columns are always the last columns in the exported list regardless of where they appear in the view.

Cecile_MaindronAuthor

Level 10

I have noticed that my columns are listed by alphabetical order, instead of the order on my screen. Could it be related to a setting in my account?

Cécile @ Talend

A

Anonymous

I just exported visible columns in CSV format and they exported in the same order they were displayed (except a formula field and the Marketo SFDC ID field were at the end). If you export "All Columns", then the fields are exported in alphabetical order.

Cecile_MaindronAuthor

Level 10

I have re-tried again and I think I have found solution : I need to export under .csv (windows 2007). Is there a way to select this by default (instead of regular .csv)?

A

Anonymous

Accepted solution

There isn't a preferences setting that controls the default. I'm surpprised that regular CSV rearranges your column order. You may want to open a case with tech support.

Cecile_MaindronAuthor

Level 10

will do!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded