Excel to CSV converter (and CSV to Excel)
Turn any sheet of an Excel workbook into a clean CSV, or a CSV into an .xlsx file. Pick the sheet, the delimiter and how numbers and dates are written, preview the result, and download. The file never leaves your browser.
Click to upload or drag and drop
Drop your CSV, Excel, or JSON file
Max 10MB
Excel .xlsx, .xlsm, .xls or .xlsb, or OpenDocument .ods, up to 10MB. Macros are never run.
Runs 100% in your browser — this page makes no network request with your data.
- 1
Drop an .xlsx, .xlsm, .xls, .xlsb or .ods workbook. Every sheet with data is listed with its size.
- 2
Choose the delimiter (comma, semicolon or tab), whether numbers keep Excel's formatting, and whether dates are written as ISO 8601. Preview the CSV.
- 3
Download one CSV per sheet. Going the other way? Switch to CSV → Excel, drop a CSV and download an .xlsx.
To convert an Excel file to CSV, drop the workbook into the converter above, choose the sheet and the delimiter, and download. Each sheet becomes its own CSV, because a CSV file holds exactly one table. Conversion runs in your browser, so the workbook is never uploaded, and the same tool converts a CSV back into an .xlsx file.
The decision worth a moment is what the CSV should contain: Excel’s formatted display ($1,234.50, 1/15/24, 12.5%) or the plain values underneath (1234.5, 2024-01-15, 0.125). The right answer depends on where the CSV is going, and the options above let you pick.
How to convert Excel to CSV in Excel, Google Sheets and LibreOffice
If the spreadsheet program is already open, its own export works. The catch is the same everywhere: a CSV holds one sheet, so a workbook with five sheets needs five exports.
| Method | How | Watch out for |
|---|---|---|
| Microsoft Excel | File → Save As (or Save a Copy) → CSV UTF-8 (Comma delimited) | Saves only the active sheet. The older "CSV (Comma delimited)" type uses the system code page, which can garble non-English characters |
| Google Sheets | File → Download → Comma-separated values (.csv) | Downloads only the sheet you are on, and the file must be imported into Sheets first |
| LibreOffice Calc | File → Save As → Text CSV, then choose the character set and field delimiter | Saves the active sheet; the options dialog decides the encoding |
| This converter | Drop the file, pick options, download one CSV per sheet | Files up to 10MB; runs in your browser, nothing uploaded |
| Command line | soffice --headless --convert-to csv file.xlsx | LibreOffice’s converter; exports the first sheet by default |
Comma, semicolon or tab: choosing a delimiter
Comma is the default and what most databases, CRMs, import wizards and scripts expect. Pick it unless you know otherwise.
Semicolon is for spreadsheets in regions where the comma is the decimal separator, such as much of continental Europe. There, Excel’s list separator is a semicolon, so a semicolon-separated file opens in neat columns while a comma-separated one can land in a single column.
Tab-separated values (TSV) sidestep the question entirely, because tabs almost never appear inside data. TSV pastes cleanly into spreadsheets and is common in data pipelines.
Whichever you pick, fields that contain the delimiter, a double quote or a line break are wrapped in double quotes automatically, so the file stays valid.
Formatted values, plain numbers and ISO dates
Excel stores a number and a display format separately. The converter can write either one.
| Cell in Excel | As shown in Excel | Plain values / ISO 8601 dates |
|---|---|---|
| 1234.5 with a currency format | $1,234.50 | 1234.5 |
| 0.125 with a percent format | 12.5% | 0.125 |
| A date (January 15, 2024) shown as m/d/yy | 1/15/24 | 2024-01-15 |
| A date with a time | 1/14/24 18:00 | 2024-01-14 18:00:00 |
| The result of =0.1+0.2 | 0.3 | 0.3 |
Which to choose
Formatted values read well for people but trip up imports: "$1,234.50" is text to most databases, and "1/15/24" means January 15 in the US and something else, or nothing, elsewhere. Plain values and ISO 8601 dates (YYYY-MM-DD) import cleanly almost everywhere. Date cells are recognized by their Excel number format, so the ISO option rewrites real dates and leaves other numbers alone. Plain values are written to 15 significant digits, the precision Excel itself keeps, so floating-point noise like 0.30000000000000004 never appears.
Accented characters and the UTF-8 BOM option
A CSV file has no place to declare its text encoding, so every program has to guess. The converter always writes UTF-8, which modern systems read correctly. Excel for Windows, however, may assume an older code page when you double-click a CSV, turning "Zoë" into "Zoë".
A byte order mark (BOM), three invisible bytes at the very start of the file, tells Excel the file is UTF-8. Turn the option on when people will open the CSV in Excel. Leave it off for databases and scripts: some of them read the mark as part of the first column’s name.
Converting CSV to Excel without losing leading zeros
Opening a CSV directly in Excel converts anything that looks like a number. Zip code 01730 becomes 1730, a 16-digit ID is rounded because Excel keeps only 15 significant digits, and some codes turn into dates.
The CSV → Excel mode avoids that. Plain numbers become real Excel numbers you can sum and chart; values with leading zeros, numbers longer than 15 digits, and anything with symbols, separators or letters are written as text, so they arrive exactly as they were. Dates stay as written. If you would rather convert nothing, tick "Keep every value as text". The .xlsx gets one sheet named after the file, with column widths set from the data.
Frequently Asked Questions
Everything you need to know about using AnalyzeData.
A CSV file holds a single table, so each sheet becomes its own CSV. The converter lists every sheet that has data and gives each one its own download button.
The CSV gets each cell's stored value; for a formula, that is the result Excel last calculated, not the formula. Fonts, colors, column widths, merged-cell layout, charts and macros are not part of the CSV format, so they are left behind.
Yes. Values with leading zeros (zip codes, SKUs), numbers longer than 15 digits, and anything containing symbols or separators are written as text, so Excel cannot strip or round them. Other plain numbers become real Excel numbers you can sum. You can also keep every value as text.
Each sheet gets its own download button in the list, so converting a whole workbook is one click per sheet. Every file uses the same delimiter, number and date settings.
Files up to 10MB, the same as the other single-file tools here, because the whole workbook is read into your browser’s memory. For larger workbooks, use Excel’s or LibreOffice’s own CSV export, or the LibreOffice command line.
Yes. It reads .xlsx, .xlsm, .xls, .xlsb and OpenDocument .ods files. Macros in .xlsm files are never run; only the stored cell values are read.
Yes. Hidden sheets appear in the sheet list, and hidden rows and columns are included in the CSV, because they are part of the data. Delete them in Excel first if you do not want them exported.
Excel stores a merged range’s value in its top-left cell, so that is where the value appears in the CSV; the other cells of the merge come out empty.
More free data tools
Each one runs entirely in your browser, with no upload and no signup.
- CSV viewerOpen CSV files online as a sortable table
- Excel viewerOpen .xlsx and .xls files without Office
- Large CSV viewerOpen CSV files too big for Excel
- CSV to chartBar, line or pie chart from a CSV
- CSV splitterSplit a large CSV into smaller files
- Merge CSV filesCombine several CSVs into one
- CSV editorFix values without Excel reformatting
- Word frequency counterTop terms and counts in any text
- Sentiment analysisScore reviews and survey answers
When a table isn't enough
The workspace runs verified AI analysis on the same file and turns the results into a report you can send.
Analyze this data instead