When trying to import data trapped in a spreadsheet, you may be asked for the file in CSV format. But what is CSV and how do you convert Excel to CSV? Naturally, we’ve got the answers to both.
What is CSV?
CSV stands for comma separated values. It’s one of the most simple data formats there is.
It will literally create a file where all the data in each cell of the spreadsheet is separated by a comma.
So, for example, if I had a very simple spreadsheet such as below that was keeping scores in a game:
The CSV file, when opened in a text editor, would look like this:
How to convert Excel to CSV
By far the easiest way to convert an Excel spreadsheet to a CSV file is within Excel itself.
- Open the sheet you wish to convert
- Choose File, then Save As
- In the drop-down menu beneath the filename, choose CSV (Comma delimited)
There are some other variants on the CSV format listed in Excel’s dropdown menu, but the one with (Comma delimited) after its name should give the most reliable results.
You should now be able to open the CSV file in any spreadsheet application or text editor.
Bear in mind, however, that CSV files only retain the values – the items displayed in the cells. They do not retain any formulae or other information. It’s purely designed for the transfer of values from one application to another.
How to convert Excel to CSV in Google Sheets
If you don’t have Excel on your computer but still need to convert a file to CSV, fear not.
- Open Google Sheets in a web browser
- Upload the Excel spreadsheet into Google Sheets by clicking the folder icon on the right of the screen and selecting Upload
- Once you’ve opened the file in Google Sheets, click File, Download As, and select Comma Separated Values, as shown below
A CSV file will be downloaded to your computer.
Now read this: How do I reveal hidden columns in Excel?