Convert an Excel file to CSV
Choose an .xlsx or .xls workbook and download it as CSV. Every sheet is converted, not just the first. A one-sheet workbook gives one CSV, and a multi-sheet workbook gives a ZIP with one CSV per sheet, named after each sheet. Use it to import data into another app, a database or a script that only reads CSV. The workbook is read in your browser and never uploaded.
What carries over
| In Excel | In the CSV |
|---|---|
| Cell values | Kept |
| Formula results | Kept (as values) |
| Formulas, formatting, colours | Dropped |
| Charts, images, comments | Dropped |
| Merged cells | Value sits in the first cell |
Tips
- Dates can come through as text in the format the workbook stored them. Check one column before you import.
- Unzip the multi-sheet download with ZIP files if your computer can’t open it.
- Need JSON instead? Paste the CSV into CSV to JSON.
Limits
Password-protected workbooks can’t be opened. Very large workbooks use a lot of browser memory.
Related tasks
Clean up a column of values with Remove duplicate lines.