Free tool · Developer Excel to CSV: convert XLSX sheets to CSV in your browser
Drop an .xlsx file, pick a sheet and get clean CSV for a database import, a script or another tool. Dates come out as 2026-11-18 instead of 46344, long ID numbers keep every digit, and you choose the delimiter and whether Excel should see a UTF-8 BOM. The workbook is unpacked by your browser and never uploaded.
- Files stay on your device
- Dates written as dates
- Any sheet, or all in a ZIP
Convert Excel to CSV
Choose an .xlsx file. The CSV appears below; change the sheet or the options at any time.
No file yet. Choose or drop an .xlsx file, or try the sample workbook.
Raw keeps 1234.5 and 0.256; as shown gives 1,234.50 and 25.6%.
Preview
How Excel cells are written
Each row was converted with the same code the tool runs. Excel stores a date as a day count (46344) and a percentage as a fraction; the converter reads the cell format to write them the way you expect.
| Cell | Excel shows | CSV (raw) | CSV (as shown) | JSON |
|---|---|---|---|---|
| Number, 2 decimals | 1,234.50 | 1234.5 | 1,234.50 | 1234.5 |
| Percentage | 25.6% | 0.256 | 25.6% | 0.256 |
| Date | 18/11/2026 | 2026-11-18 | 2026-11-18 | "2026-11-18" |
| Date and time | 18/11/2026 09:30 | 2026-11-18 09:30:00 | 2026-11-18 09:30:00 | "2026-11-18 09:30:00" |
| ID stored as text | 110105199003071239 | 110105199003071239 | 110105199003071239 | "110105199003071239" |
| TRUE / FALSE | TRUE | TRUE | TRUE | true |
| Error | #DIV/0! | #DIV/0! | #DIV/0! | "#DIV/0!" |
| =0.1+0.2 | 0.3 | 0.3 | 0.3 | 0.3 |
Formulas are not recalculated: the converter uses the result Excel saved with the file. Files saved by some tools without results show those cells empty, and the tool tells you.
Version v1.0Updated Update history
What a CSV keeps and what it drops
CSV is plain text: one line per row, values separated by a delimiter. That makes it readable by almost anything, and it also means some workbook features cannot come along.
Values
Text, numbers, dates, TRUE / FALSE and error codes come across. Numbers are written without thousands separators so other programs read them as numbers; switch to “As shown in Excel” if you need the formatted look.
Dates
Excel stores dates as a count of days since 1900 (or 1904 in some old Mac files). The tool reads each cell’s format and writes ISO 8601, which databases, Python and JavaScript parse without guessing the day-month order.
One sheet per file
A CSV holds one table. Pick the sheet to convert, or download all sheets in a ZIP. Hidden sheets are listed and marked.
Left behind
Formulas (their results are kept), formatting, colours, comments, charts, pictures, filters and data validation. Merged cells are split; by default each cell repeats the value.
Opening the CSV in Excel again? Turn on the UTF-8 BOM, or Excel may show accented letters and Chinese as garbled text.
Convert Excel to CSV in four steps
The defaults suit a database import or a script.
-
1
Choose the .xlsx
Drop it on the box or click to pick it. Old .xls files need to be saved as .xlsx first.
-
2
Pick the sheet
The first visible sheet is selected. Every sheet, including hidden ones, is in the list.
-
3
Set the output
CSV, TSV or JSON; delimiter; quotes; raw or displayed numbers; a BOM if the file goes back into Excel.
-
4
Download or copy
Download the file, all sheets as a ZIP, or copy the text into another tool.
How the converter reads an .xlsx file
An .xlsx file is a ZIP archive of XML files (the Office Open XML format, ECMA-376). The tool unpacks it with the browser’s built-in decompression and reads only the parts it needs.
- xl/workbook.xml lists the sheets, their order, whether they are hidden, and whether the file uses the 1900 or 1904 date system
- xl/sharedStrings.xml holds every piece of text once; cells point to it by number
- xl/styles.xml says which number format each cell uses, which is how a date is told apart from a plain number
- Each xl/worksheets/sheetN.xml holds the cells: value, type and the result of any formula
- CSV output follows RFC 4180: fields with the delimiter, quotes or line breaks are quoted, lines end with CRLF
| Part | What it holds | Used for |
|---|---|---|
| xl/workbook.xml | Sheet names and order | The sheet list |
| xl/sharedStrings.xml | All text, stored once | Text cells |
| xl/styles.xml | Number formats | Dates, percentages |
| xl/worksheets/*.xml | Rows and cells | The values you get |
| mergeCells in each sheet | Merged ranges | Filling merged cells |
A sales sheet becomes CSV
A sheet with an order number, a customer, an amount formatted as currency, a payment date and a tracking number stored as text.
| Column | Excel shows | Stored in the file | CSV gets |
|---|---|---|---|
| order_id | 1001 | 1001 | 1001 |
| customer | Chloé Martin | Text “Chloé Martin” | Chloé Martin |
| amount | €310.50 | 310.5 with a currency format | 310.5 (or €310.50 as shown) |
| paid_at | 03/11/2026 16:05 | 46329.67013888889 | 2026-11-03 16:05:00 |
| tracking_no | 00731004527 | Text “00731004527” | 00731004527 |
The line becomes 1003,Chloé Martin,310.5,2026-11-03 16:05:00,00731004527. With a BOM, Excel opens it with the accent intact.
Where Excel to CSV goes wrong
Most problems show up when the CSV is opened again, not during the conversion.
Garbled accents or Chinese
Excel assumes a CSV without a BOM uses the local code page. Add the UTF-8 BOM, or import it through Data › From Text/CSV and pick UTF-8.
Lost leading zeros
The CSV still has 00731; Excel drops the zeros when it opens the file. Import the column as text, or convert the CSV back with CSV to Excel, which keeps them.
Day and month swapped
03/11/2026 means different dates in the US and Europe. ISO dates (2026-11-03) avoid the guess; keep them that way in the CSV.
Wrong delimiter
Excel in many European locales expects semicolons, because the comma is the decimal mark. Pick “Semicolon” for those users.
Your event data, out as CSV or JSON Lines
Events reach TapCub from the web script, the platform SDKs and the server API, each with its own properties. When you need the raw rows in a spreadsheet, data export hands them back.
Data export
On Pro, events, sessions, people, interactions or consent records for a date range can be exported as CSV or through the API.
Learn moreSDKs and server API
Web, app, mini-program and server events share one schema, so the columns you get are the same across platforms.
Learn moreData-quality checks
Unexpected event names, missing properties and wrong types are flagged on arrival, before they reach an export.
Learn moreExcel to CSV questions
Still have a question?
Chat with the team behind TapCub — we usually reply within a few hours on business days.
How do I convert an Excel file to CSV?
Drop the .xlsx file on the converter, pick the sheet and click Download .csv. To do it in Excel itself, use File › Save As and choose “CSV UTF-8 (Comma delimited)”; that saves only the active sheet.
How do I convert all sheets at once?
Click “All sheets (ZIP)”. You get one CSV per sheet, named after the sheet, in a single ZIP file. For JSON, tick “All sheets in one JSON”.
Why does the CSV show strange characters when I open it in Excel?
Excel reads a CSV without a byte order mark in the computer’s local encoding. Turn on “Add a UTF-8 BOM” before downloading and accents, emoji and Chinese display correctly.
Can I convert an .xls file?
Not directly. .xls is the older binary format. Open it in Excel, Numbers, WPS or LibreOffice, save it as .xlsx and convert that.
Are my spreadsheets uploaded?
No. The file is unpacked and converted by your browser. You can check in the developer tools’ Network tab, or switch off the internet after the page has loaded.
What happens to formulas?
The CSV gets the result Excel saved with the file, not the formula. If a file was saved without results, those cells are empty and the tool tells you how many.
Why are my dates numbers like 46344?
That is how Excel stores dates: days since 1 January 1900. This converter reads the cell format and writes 2026-11-18 instead; Excel’s own CSV export writes them the way they are displayed.
Update history
New features, fixes and data refreshes for this tool, newest first.
-
· v1.0
LaunchedFirst release.
Missing something or found an error? Tell us — requests that come up often go into the next update. All tool updates
Collect events you can export cleanly
Connect your site or app, send events with consistent properties, and export the raw rows whenever a spreadsheet needs them.