Skip to main content
All CollectionsData Import
Create a CSV file using Excel
Create a CSV file using Excel

Describes how an Excel spreadsheet can be saved as a CSV files

Updated over a week ago

CSV stands for Comma Separated Values file. It is a plain text file created in a specific format that makes it easy for computers to work with. It is also relatively easy to look through as a human, but not as simple as using a spreadsheet. When converting Excel files to CSV, each column in Excel is written as text in the file, and separated between other columns using a comma symbol. If the cell value contains a comma, then the text in the CSV file will start with a double-quote and end with a double-quote.
โ€‹

Open your spreadsheet in Excel.

Select the correct worksheet, as you may have multiple worksheets within your spreadsheet. You can only save one worksheet at a time.

To save your current worksheet in CSV format, click File at the top left of your Excel spreadsheet, then Save As.

In the drop-down menu towards the top of the page, select CSV (comma delimited) and Save.

Did this answer your question?