We all started somewhere! Share your experience on the Get Advice: Let's Get Started Sweepstakes thread and be entered to win a $100 credit on your Constant Contact account.

getting a copy of a mail list

Occasional Participant

getting a copy of a mail list

How do I copy a mail list in the same format and order as it shows in Constant Contact? When I try to copy, it downloads it in excel in a totally different format. Here's how I want the list to look when I copy it:




Hello @JudithB22 ,


Are you wanting to copy the list within Constant Contact? Or are you wanting to export it?


If you're choosing to export the list, I'd recommend downloading it as a CSV (comma-separated value or comma-delineated value). This file type can still be opened in Excel and similar programs, and it allows you to sort your information by a specific column (such as first name or email), and have all the other cells stay attached to their respective contact info in the re-sorted column. 

By default when you export a list from us, we'll have First Name, Last Name, and Email Address already selected. If you're needing to have the First and Last Name columns fused together in your downloaded file, you may need to manually edit one of the name columns to also include the other, since our system has to keep the values separate for various functions within emails. Or make a new column of their names together in single cells.

William D
Community & Social Media Support

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.