How to use this tool
- Upload a CSV or paste its contents. Choose automatic delimiter detection, or select comma, semicolon, tab or pipe explicitly.
- Confirm whether the first row contains headers, then preview the data. If columns look merged or shifted, change the delimiter and preview again.
- Choose each column’s format. Keep SKUs, phone numbers and postal codes as Text to retain leading zeros. Export the Excel workbook.
Example: keep a SKU as text and an amount as a number
A CSV does not record column types. In this example, choose Text for SKU and Number for Amount: Excel should retain 00123 while allowing arithmetic on 42.50. Choosing Number for the SKU would intentionally remove its leading zeros.
| CSV value | Selected format | Workbook result |
|---|---|---|
| 00123 | Text | 00123 |
| 42.50 | Number | 42.5, stored as a number |
| 2026-10-20 | Date | An Excel date |
| 25% | Percent | 0.25, displayed as a percentage |
What to check before you export
- Up to 20 MB, 10,000 data rows and 200 columns. Preview shows only the first 50 rows.
- CSV input must be UTF-8. Save a fresh UTF-8 copy if accented characters appear incorrectly.
- Currency formatting uses two decimal places and does not convert exchange rates. Formula-like input is stored as text rather than executed.
Frequently asked questions
Can I convert a semicolon-separated CSV?
Yes. Select Semicolon before previewing. Explicit delimiter selection is useful when a file uses regional export settings.
Why did my leading zeros disappear?
Numbers do not preserve leading zeros. Select Text for identifiers before exporting, and check the preview against the source file.
Does changing .csv to .xlsx convert the file?
No. Renaming a file changes its name, not its internal structure. This converter writes a real XLSX workbook that Excel can open.