Convert comma separated CSV into an XLSX workbook. Keep values as literal text, including leading zeros in codes and identifiers.
How to use
Paste CSV or import a text file, select Convert, and download the XLSX file. Keep rows the same width. The table supports 1,000 rows and 100 columns.
Example
A row containing 00123,London keeps 00123 as text in the workbook rather than turning it into 123.
FAQ
Are formulas calculated?
No. Cells are written as literal strings. Format numeric columns in Excel yourself if you need calculations.
Related tools
A practical task
Decide which columns should remain identifiers after export. A postal code such as 00125 is not a quantity. Literal string cells protect its spelling, but a later manual conversion to numeric values in Excel can still remove the leading zeros.
Another useful question
Why do numbers look like text in Excel?
This conversion writes literal strings intentionally. Change the type only for columns that you will calculate, and verify how blanks and decimal punctuation are interpreted.
Details for interpreting the result
| Detail | Explanation |
|---|---|
| Quoted CSV fields | In comma separated CSV, a field containing a comma, quote, or line break needs quotes around it. A quote inside that field is doubled. Splitting every comma by hand loses those field boundaries. |
| Column headers | Headers provide names for columns; they are not extra data values. Keep their order aligned with each row. When building objects, duplicate header names create ambiguity about which value belongs to a key. |
| Strings and values | The JSON string "12" differs from the number 12, and "false" differs from false. Type changes affect comparisons and imports. Keep identifiers as strings when their leading zeros or exact digits matter. |
| Empty and missing data | An empty string, a missing property, and null express different states in structured data. A flat table can merge some of those distinctions. Confirm how missing cells should be handled before converting records. |
| CSV and spreadsheets | CSV stores text and delimiters, not cell formatting. A spreadsheet can interpret a value beginning with a formula marker when opening it. Review imported files rather than assuming quoted cells cannot be interpreted. |
| Numeric precision | JavaScript numbers cannot represent every large integer exactly. Long account numbers, order identifiers, and arbitrary precision decimals should remain strings or use a suitable numeric library in the receiving application. |
| Workbooks and sheets | An XLSX workbook can contain several worksheets, formulas, formatting, and hidden context. A CSV export represents one flat table. Select the intended sheet and retain the workbook when that extra context matters. |