Convert Excel (XLSX) to CSV

How to convert XLSX to CSV

Drop a workbook above. SheetJS opens it in your browser and lists every worksheet with its size in rows and columns, and shows the first rows of the selected sheet. Click a sheet, check the preview and press Download to save it as CSV. If the workbook has several sheets, All sheets as a ZIP of CSVs saves one CSV per sheet, named after the workbook and the sheet.

What the CSV contains

CSV holds values only, one sheet per file. Each cell is written the way Excel displays it, so dates, currency and percentages keep their formatting as text, and formulas are replaced by their last calculated result. Fonts, colours, column widths, merged cells, charts and comments are dropped. Merged cells keep their value in the first cell only. Blank rows are left out.

Formats it opens

Modern .xlsx and .xlsm workbooks from Excel 2007 and later, old .xls files from Excel 97 to 2003, binary .xlsb files and OpenDocument .ods spreadsheets from LibreOffice and OpenOffice all work. Password-protected workbooks can't be opened. Remove the password in Excel first.

Why convert Excel to CSV?

Almost every database, CRM, email tool, analytics script and online store import screen accepts CSV, and many of them don't accept Excel files. CSV is also easy to read in code, diff in version control and open in any text editor.

Before you start

Input: XLSX, XLS, XLSM, XLSB, and ODS. Output: CSV. The settings appear before anything runs, so you can check them first. Your original file is never changed.

A valid file can still hold the wrong data. Before you import the result, check the row count, field names, text encoding, dates, IDs and a few unusual rows.

Keep the original until you have opened and checked the result. The work happens in this browser tab, so the size you can handle depends on your device's memory, your browser and the file itself.

How to convert Excel (XLSX) to CSV

1. Drop an .xlsx, .xls or .ods file into the box above.
2. Pick the worksheet you want and check the preview.
3. Download that sheet as CSV.
4. Or download every sheet at once as a ZIP of CSV files.