How to use the Excel to CSV tool
- Add your spreadsheetDrop an XLSX, XLSM or ODS file onto the box, or click to choose it.
- Pick the sheetChoose which sheet to convert and check the preview of its rows and columns.
- Choose the formatSelect the separator (comma, semicolon, tab or pipe), the encoding and the line endings.
- DownloadDownload the CSV, copy it, or get every sheet as separate CSV files in one ZIP.
Features
- Values, not formulasEach cell’s last calculated value is written, exactly as you see it in Excel.
- Dates stay readableCells formatted as dates become ISO dates such as 2026-03-31, which every program understands.
- Excel-friendly encodingUTF-8 with BOM makes Excel open accented letters, ₹, € and non-Latin scripts correctly.
- Any separatorSemicolon for European Excel versions, tab for TSV, or pipe for databases.
- Proper quotingCells containing separators, quotes or line breaks are quoted, so the CSV imports cleanly.
When you need a CSV instead of an Excel file
CSV (comma-separated values) is the simplest way to move table data between programs. Almost every system can import it, while XLSX files need a spreadsheet library.
- Importing products, contacts or prices into Shopify, WooCommerce, Tally, Zoho or a CRM
- Loading data into a database, Python, R or Google BigQuery
- Uploading bulk lists to email marketing tools and ad platforms
- Sharing data with someone who doesn’t have Excel
Which separator and encoding should I choose?
| Destination | Settings |
|---|---|
| Most websites, databases and code | Comma, UTF-8, LF |
| Opening again in Excel (English) | Comma, UTF-8 with BOM, CRLF |
| Excel in Germany, France, Spain and others | Semicolon, UTF-8 with BOM |
| Data containing many commas | Tab (saved as .tsv) |
Old binary .xls files (Excel 97–2003) can’t be read here. Open them in Excel and save as .xlsx first.
What is lost when you save as CSV
A CSV file is plain text: values separated by commas, one row per line. That simplicity is why almost every program can read it, and it also means anything that is not a value is left behind.
- Formulas are replaced by their results. The CSV holds 150, not
=A1+B1. - Formatting such as colours, bold text, column widths and merged cells is not stored.
- Several sheets cannot fit in one CSV. Each sheet becomes its own file.
- Charts, images and comments are dropped.
So keep the original workbook. Treat the CSV as an export for another system, not as a replacement.
Fixing common import errors
- Strange characters instead of ₹, é or हिंदी. Export as UTF-8. If the file will be opened in Excel by double-click, choose UTF-8 with BOM.
- All the data appears in one column. The program expects a different separator. Many European systems use a semicolon because the comma is their decimal sign.
- Leading zeros vanish from phone numbers or PIN codes when the CSV is opened in Excel. The zeros are in the file. Import it through Data → From Text and set the column to Text.
- Dates are read wrongly by the receiving system. Format the column as YYYY-MM-DD in Excel before converting. That form is understood everywhere.
Related tools
Going the other way? Use CSV to Excel. To share a sheet as a document, try Excel to PDF.