Excel to CSV Converter

Parse .xlsx and .xls Excel spreadsheets to CSV format with sheet selection. All processing happens in your browser.

Excel to CSV Converter tool

Loading...

Example

Input: An .xlsx with a row of three cells: Widget, large | 3 | He said "yes"

Result: CSV line: "Widget, large",3,"He said ""yes""" - one line per row, for the sheet you select

Cells containing the delimiter, quotes or line breaks are wrapped in double quotes and inner quotes are doubled, as the CSV format requires.

Spreadsheet Formats You Can Convert

ExtensionFormatNote
.xlsxExcel 2007 and laterMost common format
.xlsmExcel with macrosMacros are not exported
.xlsbExcel binary workbookRead the same way
.xlsExcel 97-2003Legacy format
.odsOpenDocument spreadsheetLibreOffice and others

Files up to 20 MB. Output is comma, semicolon or tab separated.

  1. Upload an .xlsx or .xls Excel file by clicking the drop zone or dragging it in.
  2. If the workbook contains multiple sheets, select which sheet to convert from the dropdown.
  3. Preview the parsed sheet data in the table view to verify the content.
  4. Choose the output delimiter (comma, semicolon, or tab) - the CSV output updates instantly.
  5. Copy the CSV output to your clipboard, or click the download button to save it as a .csv file (.tsv for tab-delimited).

Turning an Excel Sheet Into Clean CSV

This tool reads an Excel workbook and turns one sheet into CSV text you can copy or download. It opens .xlsx, .xls, .xlsm, .xlsb and .ods files up to 20 MB, and the first sheet converts as soon as the file loads.

CSV is the format almost every database, script and data tool can import. The catch is that CSV holds only one table of plain values. Formatting, charts, formulas and extra sheets all disappear. So pick the sheet you need from the dropdown, which lists each sheet with its row and column count. The preview shows the first 20 rows, so you can check the data before you save it.

Each cell is written the way Excel displays it. A formula like =SUM(A1:A5) becomes its last calculated result, such as 100. A date formatted as 1/15/24 comes out as 1/15/24, and a price shown as $1,200.00 keeps its symbol and comma. If you want raw values, change the cell format in Excel before converting. When a cell contains the delimiter, a quote or a line break, it is wrapped in double quotes so the columns stay aligned.

You can switch between comma, semicolon and tab output, and the text updates at once. Tab output downloads as a .tsv file. The file is saved as UTF-8 text. Everything runs in your browser with the SheetJS library, so the workbook is never uploaded. To send the data on to an app, the CSV to JSON converter is the next step. To rebuild a workbook later, use the CSV to Excel Converter.

Sources

Frequently Asked Questions

Upload the workbook and choose the sheet from the Sheet dropdown. Each option shows the sheet name with its row and column count. The CSV and the preview update as soon as you switch, so you can convert several sheets one after another by changing the selection and downloading each.
Each formula is replaced by its last calculated value, because CSV has no way to store formulas. A cell containing =A1*2 that showed 84 in Excel will contain 84 in the CSV. If the file was never recalculated after a change, the stored value may be out of date, so open and save it in Excel first.
Dates are written using each cell's display format, so a cell shown as 1/15/24 comes out as 1/15/24. Databases and code read ISO dates such as 2024-01-15 more reliably. To get that, apply the custom format yyyy-mm-dd to the date columns in Excel before converting.
Use a comma unless the program that will read the file expects something else. Excel in many European regions uses semicolons, because the comma is the decimal separator there. Tab is a safe choice when your data contains lots of commas. Tab output downloads as a .tsv file.
The value of a merged range is written in its top-left cell, and the other cells of the range are left empty. This keeps every row the same width, so columns stay aligned in the CSV. If you need the value repeated in each cell, unmerge and fill the cells in Excel first.

Related Tools

CSV to Excel Converter

Convert CSV files to downloadable .xlsx Excel spreadsheets instantly in your browser. No upload to any server required.

File Converters

CSV to JSON Converter

Convert CSV data to a JSON array of objects with header mapping and automatic comma, semicolon, or tab detection.

Developer Tools

JSON to CSV Converter

Convert a JSON array of objects to CSV with automatic column headers, and convert CSV back to JSON in the same tool.

Developer Tools

Word to Text Extractor

Extract plain text content from .docx Word documents directly in your browser using mammoth.js. No server upload needed.

File Converters

ZIP Creator

Combine multiple files into a downloadable ZIP archive entirely in your browser using JSZip. No server upload needed.

File Converters

JSON Formatter and Validator

Format, validate, beautify, and minify JSON data with a collapsible tree view and line-and-column error detection.

Developer Tools