Excel to CSV Converter
Turn any sheet into clean CSV — every sheet at once, title rows and merged cells fixed.
Sheets and format
Semicolon suits Excel in many European languages.
Number formats applied: 1,250.50 · 12.5% · 28-Sep-26
With a time: 2026-09-28 14:30:00.
CRLF is what RFC 4180 and Excel use.
Clean-up: title rows, last row, merged cells, empty rows
Titles and notes above the header.
Leave empty for all rows; set it to stop before totals.
Down: a category merged over rows. Across: a header merged over columns.
Preview
About the Excel to CSV Converter
Convert a sheet of an Excel workbook (XLSX, XLSM, XLSB or XLS), an OpenDocument spreadsheet or an Apple Numbers file to CSV — or tick several sheets and get one CSV per sheet in a ZIP. Choose comma, semicolon, tab or pipe, values exactly as Excel displays them or the raw stored values, how dates are written, line endings, and a UTF-8 byte-order mark so the file opens correctly in Excel.
Real exports are rarely clean, so the converter can also skip title rows above the header (it detects where the header is), stop before a total row, copy merged cells into every row they cover, drop empty rows and columns, and leave out hidden rows. A preview shows exactly what will be written. Everything happens on your device.
How to use it
- Choose a workbook or drop it on the box. It is read on your device, never uploaded.
- Tick the sheets to convert. One sheet downloads as a CSV file; several download as a ZIP with one CSV per sheet.
- Pick the delimiter, As displayed or Raw values, the date format and line endings. Keep UTF-8 BOM on if the CSV will be opened in Excel.
- If a sheet starts with a title or notes, use Skip rows at the top (or Skip to the header). Each sheet keeps its own rows to skip and last row: pick the sheet in the preview list to set them, or use Do the same in every sheet. Fill merged cells down if a category is merged over several rows.
- Check the preview, then Download or Copy the CSV.
Examples
A cell showing 1,250.50 (number format #,##0.00) and a date showing 01-Jan-26
As displayed: "1,250.50",01-Jan-26 Raw (ISO dates): 1250.5,2026-01-01
Formatted numbers that contain the delimiter are quoted, as RFC 4180 requires.
Row 1 "Monthly sales report", row 4 the header, "North" merged over two rows
Region,Month,Sales North,Jan,1250.5 North,Feb,980
Skip rows at the top: 3, Fill merged cells: down. Without the fill, the second row would start with an empty cell.
Common uses
- Importing spreadsheet data into a database, CRM, accounting or e-commerce system that only accepts CSV.
- Exporting every sheet of a workbook at once instead of saving each one from Excel.
- Making semicolon-separated CSV for European versions of Excel, or TSV for pasting into other tools.
- Cleaning up bank, GST or payroll exports that have title rows, merged cells and blank lines.
Displayed or raw values?
- As displayed writes what you see in Excel: the number format is applied (
1,250.50,12.5%,₹1,499.00,28-Sep-26) — what Excel’s own “Save as CSV” does. - Raw writes the stored values: numbers with full precision and no thousands separators (
1250.5,0.125), and dates in the format you choose: ISO 86012026-09-28 14:30:00(which databases and Excel read back as dates), day-first28/09/2026, month-first09/28/2026, Excel’s serial number, or as displayed.
Formulas are exported with the results saved in the file; nothing is recalculated.
How the CSV is written
Fields are separated by the chosen delimiter and records end with CRLF (as RFC 4180 specifies) or LF. A field is quoted when it contains the delimiter, a double quote, a line break or leading/trailing spaces, and quotes inside it are doubled. Every row has the same number of fields.
Protect against formulas puts an apostrophe before text that starts with =, +, - or @, so a spreadsheet does not run it as a formula (CSV injection); numbers are never changed.
Fixing messy exports
- Skip rows at the top leaves out titles and notes above the header; the converter suggests the row count when it finds the header. Each sheet has its own setting, so rows are only removed where you asked.
- Last row stops before totals or footnotes (also per sheet).
- Fill merged cells copies a merged cell’s value down its column (categories), across its row (headers spanning columns) or into the whole area.
- Drop empty rows / columns, Leave out hidden rows and columns, Trim spaces.
Limitations
- Workbooks encrypted with a password to open cannot be read. Files up to 50 MB; very large sheets are limited to the first 3 million cells.
- Formulas are not recalculated: the values last saved in the file are exported.
- Number formats are applied the way Excel’s format codes describe; Excel’s built-in Short Date follows your browser’s language. Choose Raw values for locale-independent output.
- Charts, images and cell styling are not part of a CSV and are not exported.
Privacy
Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.
Frequently asked questions
How do I convert all sheets of a workbook to CSV?
Tick every sheet (or use Select all). The download is a ZIP that contains one CSV file per sheet, named after the sheets.
Why do accents or ₹ look wrong when I open the CSV in Excel?
Excel guesses the encoding of a CSV file. Keep UTF-8 BOM ticked: the invisible marker at the start tells Excel the file is UTF-8, so “Müller”, “प्रिया” and ₹ display correctly. Most other programs ignore it.
My Excel uses semicolons. Which delimiter should I choose?
Excel in many European locales expects a semicolon, because the comma is the decimal separator there. Choose Semicolon; choose Tab for TSV.
Why are some numbers in quotes?
With As displayed, a value such as 1,250.50 contains the comma delimiter, so it must be quoted to stay in one field. Choose Raw values to write plain 1250.5.
Is my workbook uploaded?
No. The file is read and converted by your browser, in a background thread of this page. Nothing is sent to a server.