Solved: Exporting my list to Excel, want it in Alpha order... - Constant Contact Community

CentralCoastCLCA · ‎02-25-2023

Exporting my list to Excel, want it in Alpha order. How? It's in alpha order on my screen?...

I want to print it our so that it can be proofed and updated by members of our organization, but want that to be in alpha order. I did it once, but now can't...help?

William_A · ‎02-25-2023

Hello @CentralCoastCLCA ,

As long as it's a CSV file, you should be able to pick a particular column and sort it as you see fit using a spreadsheet program like Excel, Numbers, Google Sheets, etc. When sorting a single column, the program should prompt you to have its corresponding columns reordered to ensure the rows' info remains linked.

If you need further guidance on your spreadsheet program's sorting functionality, we'd advise checking its in-app Help resources, or its developer's support site.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support

View solution in original post

William_A · ‎02-25-2023

Hello @CentralCoastCLCA ,

As long as it's a CSV file, you should be able to pick a particular column and sort it as you see fit using a spreadsheet program like Excel, Numbers, Google Sheets, etc. When sorting a single column, the program should prompt you to have its corresponding columns reordered to ensure the rows' info remains linked.

If you need further guidance on your spreadsheet program's sorting functionality, we'd advise checking its in-app Help resources, or its developer's support site.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support

Exporting my list to Excel, want it in Alpha order. How? It's in alpha order on my screen?...

Why Picking the Right Fonts for Your Emails Matters

The Unintentional Humor of Spam Emails

How to Create Images of Multi-Page PDFs

Just Getting Started?

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.