Free tools

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. 1

    Drop an .xlsx, .xlsm, .xls, .xlsb or .ods workbook. Every sheet with data is listed with its size.

  2. 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. 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.

Ways to convert an Excel workbook to CSV
MethodHowWatch out for
Microsoft ExcelFile → 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 SheetsFile → Download → Comma-separated values (.csv)Downloads only the sheet you are on, and the file must be imported into Sheets first
LibreOffice CalcFile → Save As → Text CSV, then choose the character set and field delimiterSaves the active sheet; the options dialog decides the encoding
This converterDrop the file, pick options, download one CSV per sheetFiles up to 10MB; runs in your browser, nothing uploaded
Command linesoffice --headless --convert-to csv file.xlsxLibreOffice’s converter; exports the first sheet by default
In Python, pandas.read_excel(path, sheet_name=None) loads every sheet into a dictionary of tables, and each one can be written out with to_csv. It needs the openpyxl package for .xlsx files.

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.

The same cells written both ways
Cell in ExcelAs shown in ExcelPlain values / ISO 8601 dates
1234.5 with a currency format$1,234.501234.5
0.125 with a percent format12.5%0.125
A date (January 15, 2024) shown as m/d/yy1/15/242024-01-15
A date with a time1/14/24 18:002024-01-14 18:00:00
The result of =0.1+0.20.30.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.

An Excel sheet holds at most 1,048,576 rows. If a CSV is longer, the converter says so instead of silently cutting it; open it in the large CSV viewer to search it and download the part you need.

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.

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