Saving an Excel file as a .CSV file

How do I save my Excel file of email addresses as a .CSV file?

Article: 000001868 Product: All

Saving an Excel file as a .CSV file

You may want to save or resave your Excel file of contacts as a .CSV file to reduce the chances of errors occurring during import.

CSV files generally cause fewer errors than Excel files with .XLS extensions-- especially if you have copied and pasted any information into the spreadsheet or if the file contains a macro.

To save an Excel file as a .CSV file:

  1. Open Excel and open the file containing your contact list. 
  2. On the Excel toolbar, select File > Save As. A dialog box pops up.
  3. Type a new name for the file in the File Name text field.
  4. In the "Save as Type" drop-down menu, scroll down to locate and select CSV (comma delimited).
  5. Click Save.
    • If you see a message that the file type doesn't support multiple worksheets, click OK.
    • If you see a message that the file may contain features that may not be compatible with the file type, click Yes to continue.
  6. Close the file and exit from Excel.

Note: You can also import your email list as an Excel file (.XLS) if the list is on one worksheet. If the list spans more than one worksheet in that file, only the first sheet is read and processed.

Rate This Answer

Provide Feedback on this Answer
Please share your feedback below to make this answer more helpful. Note: If you need immediate assistance, please visit our Help & Support page to contact us – we’re here to help.