A Comma Separated Value format (CSV) is a delimited data format that has fields/columns separated by a comma character and records/rows are separated by new lines. The CSV file format is very simple and supported by almost all spreadsheets and database management systems. If the file is opened in Note Pad, each piece of data will have double quotes around it. For example, "first name", 'last name".
To save a file in the CSV format
- Open the file in Excel.
- Click the 'Save As' option in the file menu.
- Change the 'Save as Type' drop down option to 'CSV.'
- Click 'Save.'
- Click 'OK.'
- Click 'Yes.'
- Then close the file.
NOTE: When creating a CSV file in Excel on a Mac, use the option to Save As "CSV (Windows), otherwise the format will not be correctly recognized by CSV Import.