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.