CSV to Excel Converter (XLSX)
Turn a CSV or TSV file into a real Excel .xlsx workbook, with numbers stored as numbers and text kept as text, in your browser.
Results
What this tool does
Opening a CSV directly in Excel goes wrong more often than it should: a semicolon file lands in one column, 3,5 is read as text or as a date, codes like 007 lose their leading zeros, and long numbers such as 16-digit card or ID numbers lose their last digits, because Excel keeps only 15. This converter reads the CSV by the RFC 4180 rules, quoted fields and line breaks included, and writes a proper .xlsx in which only values that are plainly numbers become numbers; everything else, including codes with leading zeros and numbers longer than 15 digits, is stored as text exactly as written. Choose the separator (a tab is written \t) and whether your decimals use a point or a comma. The workbook has a single sheet and no formatting.
Formula
each CSV line → one sheet row ; values shaped like numbers go in as numbers, the rest as text
Variables
| Symbol | Meaning | Unit |
|---|---|---|
text | CSV | — |
delimiter | Separator | — |
decimal | Decimal mark in the file | — |
OUT | Rows × columns | — |
NU | Cells stored as numbers | — |
TX | Cells stored as text | — |
EM | Empty cells | — |
Worked example
- CSVproduct,price,stock Pen,1.20,150 Notebook,3.50,42 Stapler,7.95,0
- Separator,
- Decimal mark in the file.
- Rows × columns4 x 3
- Cells stored as numbers6
- Cells stored as text6
- Empty cells0
Limitations
- The calculation runs entirely in your browser. The values you type are never sent to a server.