How do I export contacts?

SOLVED
Go to solution
MelindaM
Participant

How do I export contacts?

The "export contacts" button is not clickable. I cannot export my contacts to excel. It worked just a few days ago.

1 ACCEPTED SOLUTION

UPDATED: June 2018

 

 

-----

Hi @J.R.L4

 

I'm happy to show you how you can export your contacts! Follow these steps below!

 

  • Log into your Account
  • Click on the Contacts Tab
  • Choose the list you'd like to Export on the left by clicking on it
  • Now on the right you will see your list of contacts
  • Check the box at the top of the list to select all or go through the list & select the contacts individually that you want to export
  • Once you check a box, you will see the Toolbar displayed at the top 
  • Select the Export option

    export contacts.png

  • On the overlay, select the information you wish to Export and click Export Contacts
  • On the top of your screen you'll see a green box and the option to either Download CSV or Download Excel

    download csv or excel.png

  • Click the one you want and it will open on your desktop
  • If this message disappears before you can download your file, you can also access this file by clicking "Activity" in the top left hand corner of your contacts page.

 

Hope that helps! Let us know if you have any questions!

View solution in original post

37 REPLIES 37
Hannah_M
Moderator

Hi Melinda,

I'm sorry to hear this is giving you trouble. Are you selecting all or just some of your contacts before clicking export? You will need to have at least one contact checked off before the export button becomes active.

6-28-2013 2-11-52 PM.jpg

If you are already doing this, please let me know the browser you are working in and if the export button looks active or not.

 

Thanks for your help,

Hannah M.
Community and Social Media Support

If you find my post helpful, and it answers your question, please mark it as an Accepted Solution

Are you on Twitter? Follow me here!
SusanS158
Participant

Hello, it is not very clear where and how to export a contact list. 

Hi Susan,

Thank you for posting. I'm sorry for the confusion here. To export a contact list, you want to make sure to click on the list first to show the contacts within this list. Then you want to select all contacts within the list by choosing the box at the very top of the list. Then you will see an option to Export.

Export_List.png

 

Once you click to Export, you can then find the link to download the file within the Activity link.

 

Activity_Link_and_Download_File.png

 

I hope this helps!

Eric G.
Community Support

what happens if you have a lot of unsubscribed emails in each list? it seems like I get all active and inactive emails from each list to export.

Hello @KimberlyS457 ,

 

When a contact unsubscribes they are fully removed from all active contact lists, which means they shouldn't be in your lists regardless of whether they had previous membership or not.

 

If you don't believe this is the case, and that contacts who've definitely unsubscribed are still in your lists, could you please reply to the automated @ mention email with your username, as well as some examples of affected lists and unsubscribed contacts showing as part of those lists?


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.
KathyP5
Participant

How do I print the list?

Hi Kathy,

At this time the easiest way to print your contact list is to export it to excel first. You can export individual contacts by selecting some of the contacts in a list or you can select all and export. 

 

export2.jpg

 

Once exported, save the file on your computer and then print it from within the excel screens. 

 

Thanks,

Hannah M.
Community and Social Media Support

If you find my post helpful, and it answers your question, please mark it as an Accepted Solution

Are you on Twitter? Follow me here!

Thanks your information was very helpful

KathleenW94
Regular Participant

Can someone tell me how I am suppose to print a Email list, that would be great thanks

Hello Kathleen,

 

Please see the above post from Hannah_M. The best way to print your list is to export it first and then print that.

 

Thanks!

KathleenW94
Regular Participant

Thanks so much

You're welcome. We have a Feedback board for our Contacts product where you can vote on ideas for more features and even submit your own. You can pass the feature along for printing a list right here!

Constant Contact is misleading everyone.

 

While you can download a list to an Excel format, the data fields are corrupted. The data does not appear in the correct columns so the spreadsheet is useless.

 

Worse yet, the lists all appear in the same Excel data field so it is impossible to sort by list.

 

Constant Contact has been aware this problem for months. Notice that their replies simply fail to mention this major glitch. They apparently don't give a rat's butt.

 

Suggest that all customers start listing Constant Contacts failures to provide proper service as part of their email distributions. At least potential new customers won't be surprised as we were some months ago.

ArmandoE
Occasional Participant

How do I export my contact to a xls file?

Hi Armondo,

Thanks for posting. Currently the only way to export a list of contacts is to a CSV file but you can open this file on your computer and re-save it as a CSV in just a couple of steps. 

 

First export the list and use the download link to open the file. Depending on your computer & browser type you will have the option to open or save the file. Once opened you can go to File >Save As and choose the file type you would like. 

 

Hope this helps

Hannah M.
Community and Social Media Support

If you find my post helpful, and it answers your question, please mark it as an Accepted Solution

Are you on Twitter? Follow me here!
DennisM59
Occasional Participant

Why have you made it so hard to export contacts to a CSV file?

Hi Dennis. I'm sorry you're finding the new contacts harder than the old system. To your specific point about exporting your contacts, it's actually fairly simple to do in the new interface.

 

  1. On My Contacts, click the list you want to export on the left. If you want to export all of your active contacts, click Active on the left.
  2. At the top of the list, there is a check box. This box selects all of the contacts on the list. Check the box.
  3. An Export button now appears at the top of the list. Click it.
  4. It will pop up asking if you want to export the contacts. Click the Export button there.
  5. Then, it will export the contacts into a .CSV file that you can download from the Activity screen.

 

If you have any questions about this process, please let us know.

Jeff Gilson
Community & Social Media Support

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!
Lou_Sander
Established Member

IMHO, the reason they have made things so hard is that deep down inside they hate us. Or maybe their developers are just clueless. 

NCVLI
Participant

I don't see the export button for contacts and the page has changed. How can I export contacts?

Hi Lisa,

 

You can still export your contacts. The process is a little different with the new contacts interface though. You'll see an option to export when you have selected the contacts that need to be exported. For more detailed instructions click here.

 

Hope that helps you!

 

Thanks,

Alex Morse
Customer Support Specialist

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"