CSV is a simple file format for data records. In a spreadsheet program, save your contact list as a CSV file.
To create a CSV file in Excel
- Open appropriate spreadsheet
- Ensure all email addresses are entered in one column with the column header named "Email"
- Note: This is necessary for ACTIVE Works® to recognize the data. Other contact information, such as name, address and phone number will not be imported
- Click File and choose Save as
- Select CSV (Comma delimited) from Save as type list
- Click Save
- Note: If your workbook contains multiple sheets, only the active sheet will be converted. Click OK to convert only the active sheet
- Click Yes to omit spreadsheet features not compatible with the CSV format