Save an Excel spreadsheet as a CSV file

Convert an Excel spreadsheet into a Comma Separated Value file to import large lists or reduce the chance of import errors when uploading contacts

If have more than 40,000 contacts, or you're running into errors while trying to import your contact list into Constant Contact, it can help to check the formatting and then save your Excel spreadsheet (XLS, XLSX) as a Comma Separated Value file (CSV) instead. CSV files are just like Excel spreadsheets, except they strip out the excess formatting that causes some import errors.

Did you know? When importing into Constant Contact, CSV files can accommodate up to a million rows of contacts or up to 100 MB of data if your account is enabled. Excel spreadsheets and TXT files can accommodate up to 40,000 rows of contacts, or up to 2MB of data.

1. In your Excel spreadsheet, click File.
   
   
    
2. Click Save As.
3. Click Browse to choose where you want to save your file.
   
   
    
4. Select "CSV" from the "Save as type" drop-down menu.
5. Click Save.
   
   
    

When you open your CSV file, it will look just like the Excel spreadsheet, except any excess formatting will be removed. Now that you've saved your Excel file as a CSV, import your contact list into Constant Contact. For help with older versions of Excel, please see Microsoft Office Support.


 

Save time: If your list is large, we can help you import it. Please contact premiersupport@constantcontact.com and provide the following information: Your account username. A phone number where we can reach you if we have questions. The contact spreadsheets that you want to import. The names of the lists you want to add the contacts to. We will contact you within 48 hours, during our regular business hours, after receiving your request.

Any links we provide from non-Constant Contact sites or information about non-Constant Contact products or services are provided as a courtesy and should not be construed as an endorsement by Constant Contact.

Questions?