FAQ: How do I save my spreadsheet as a Comma Separated File (.CSV)?

For Excel:

  • Make certain you are on the first Sheet
  • Click File (or the Office Button) → Save As.
  • Change Save as type: to “CSV (Comma delimited) (*.csv)”.
  • Enter “Customers” or "Products" etc. as a file name and save the file.

For Google Sheets

  • Make certain you are on the first Sheet
  • Click File → Download As
  • Select "Comma-Separated values (*.csv, current sheet)
  • Enter “Customers.csv” or "Products.csv" etc as a file name and save the file.
Please note: Line breaks in data fields will break imports. Open up your CSV file with a text editor and validate that each entry is on a single line.

Feedback and Knowledge Base