Need a hand? We've got you covered.

Knowledge Base Home aero-right Contact Lists Importing / Exporting aero-right How do I create a CSV file?

How do I create a CSV file?

Contact Lists Importing / Exporting Updated on March 21, 2019

To create a CSV file, you must use a text editor or a spreadsheet program, or export your contacts from an external program. Depending on how your email contact list is stored, you may be able to export a CSV file instead of having to create one from scratch. Most email clients such as Microsoft Outlook have an option to export to CSV format.

Using Notepad:

1) Format your header row according to the order in which you will input information about your contacts.

2) Following the order of your header row, input the data for your contacts, one entry per line. Any blank field must still be separated by a comma. For example: [fname],[lname],[email] John, Doe ,

3) Save the file using a .csv file extension. Ex. ‘contacts.csv’

The previous instructions apply to any text file editor, not just Notepad.

NOTE: The header row is not required. If you choose not to include this header row, you will be prompted to choose the headings during the upload process.

Using Excel:

1) Format your header row. The header row should be the top row of the spreadsheet.

2) Following the same order as your header row, input the data for your contacts. Each contact should be on a separate row, and each field in a separate field to avoid unexpected contact information.

3) Save the file using a .csv extension. (.xls is also acceptable) Mac Users: You must save your file with the file type CSV (Windows). If you do not, your file will be formatted incorrectly and will not upload properly.

Did this answer your questions?
You already voted!

Can't find what you're looking for?

Submit a Ticket

view ticket history