A spreadsheet can hold formatting, formulas and several sheets. A CSV file is plain text: rows, with columns separated by commas. Both are useful, and you often need to move between them.
When to use CSV
- Importing data into a website, a database or an accounting tool.
- Sharing a simple list that any program can open.
- Storing data in a format that will still open in many years.
When to use Excel
- Calculating totals, using formulas and charts.
- Working with several sheets or keeping formatting.
Convert CSV to Excel
Upload the file to CSV to Excel. Every row becomes a row in the spreadsheet, and you download an .xlsx file.
Convert Excel to CSV
Upload an .xlsx file to Excel to CSV. Only the first sheet is saved, so copy any other sheets into separate files first.
Check the result
- Dates and leading zeros can change when a file is converted, so check them.
- Text that contains commas must stay inside quotes in a CSV file.
- Formulas become their values in a CSV file.