Excel to CSV Converter

What Happens When You Convert XLSX to CSV

When you upload an XLSX file to this page, the tool does not open Microsoft Excel, run macros, or recalculate formulas. Instead, it reads the underlying XML inside the zipped workbook structure. Every cell in the first worksheet is examined for its last-saved visible value. If a cell contained a formula like =SUM(A1:A10), the tool does not evaluate the formula; it extracts the value that was stored when the workbook was last saved. If the formula was never calculated (e.g., the workbook was saved in manual calculation mode) the stored value may be stale or absent.

The tool then flattens that grid of values into a text table. You choose a delimiter – comma, semicolon, or tab. Each cell’s text is written into the output, with values that contain the delimiter or a line break automatically quoted according to RFC 4180. The resulting CSV file is presented in a preview panel and offered for download. The conversion runs entirely in your browser – no data is sent to any server.

Three summary metrics are displayed after conversion: the number of rows in the output table, the number of columns, and the file size of the generated CSV. These help you quickly confirm that the output matches your expectations before you import it elsewhere.

What Is Lost in the Conversion

XLSX is a rich document format capable of carrying multiple worksheets, cell types, formulas, conditional formatting, merged cells, colours, fonts, data validation, and even embedded objects. CSV is a plain-text delimited format with no concept of style, types, or structure beyond rows and columns. Every conversion from XLSX to CSV is lossy. The following items are always removed:

Nested or hierarchical data – for example, a single cell containing a comma-separated list, or rows that represent multiple levels of a tree – cannot be automatically restructured. The tool does not attempt to flatten or normalise such data. You must prepare the Excel file so that each piece of atomic data occupies its own column, with no hierarchical grouping beyond the row-column grid.

How Delimiters and Quoting Handle Edge Cases

The choice of delimiter matters because CSV has no standard way to represent structured data within a cell. This tool offers three delimiters:

• Comma (,) – the most common CSV format, used by many databases and data-science tools.
• Semicolon (;) – common in European locales where the decimal separator is a comma.
• Tab (\t) – useful when the data itself contains commas and semicolons.

Automatic quoting

If a cell value contains the chosen delimiter, a double quote, or a line break, the entire value is wrapped in double-quotes. Any double-quotes inside the value are escaped by doubling them. This follows RFC 4180. For example, a cell containing Smith, John with a comma delimiter becomes "Smith, John". A cell containing a line break (e.g., a multi-line address) will have that line break preserved inside quoted text, which many CSV parsers handle correctly.

What can still go wrong

• Leading zeros – As noted, numeric cells lose leading zeros. If the Excel cell was explicitly formatted as text, the zeros are retained. But many users unknowingly type numbers like 00123 into general-number cells, then are surprised that the CSV shows 123. There is no way for the tool to distinguish a numeric 00123 from a numeric 123 – the stored value is 123 in both cases.
• Very large numbers – Numbers longer than 15 digits (e.g., some credit card numbers or UUIDs) may already be truncated in the file: Excel stores only about 15 significant digits for a numeric cell, and the tool reads that stored value. To preserve full digits, store them as text in Excel before conversion.
• Embedded line breaks without quoting – If a cell contains a line break but the CSV parser on the receiving end does not support quoted line breaks, the resulting file may be interpreted as multiple rows. The tool quotes them, but the downstream import may still fail. In such cases, consider replacing line breaks with a placeholder (like a space or pipe) in the Excel file before conversion.

Preparing Your Excel File for a Lossless CSV Export

To avoid surprises, make these checks before uploading the XLSX file:

1. Consolidate multiple worksheets – Since only the first worksheet is used, you must either merge all relevant data into that sheet or convert each sheet separately. A common approach is to copy all needed columns into a single sheet, aligning them row by row. If you have many sheets, convert them one by one and then concatenate the CSV files outside the tool.

2. Remove formulas and keep only values – In Excel, select the entire first sheet, copy, and paste as values (Paste Special > Values). This ensures that the stored visible values match what you expect. The tool is already reading values, so this step is not strictly necessary, but it makes the file self-documenting.

3. Force text cells for leading zeros – For columns that must retain leading zeros (e.g., ZIP codes, product codes), format the entire column as Text in Excel before typing the values. Alternatively, precede each value with an apostrophe ('00123). The tool will then see the cell as text and preserve the zeros.

4. Flatten nested data – If a cell contains multiple related pieces of information (e.g., a list of tags, a concatenated address), decide whether to split them into separate columns or to represent them as a single text string. The tool will not guess your structure.

5. Handle dates – Date cells are written as ISO text (for example 2023-03-15T00:00:00.000Z), whatever date format Excel displays. If you need a specific date format, convert the column to text in Excel using a formula like =TEXT(A1,"YYYY-MM-DD") and then paste as values before uploading.

Error Messages and Their Causes

The tool displays specific error messages when the conversion cannot proceed. Understanding these helps you correct the problem quickly.

Frequently Asked Questions

Why are only the first worksheet converted?
The tool is designed for quick, simple conversions where you typically want a single table. Supporting multiple worksheets would require additional logic (e.g., merging into one output or offering a dropdown) and most users only need one sheet. If you have data on multiple sheets, convert each sheet individually and then combine the CSV files in a text editor or spreadsheet.

Why did my leading zeros disappear?
If the cell in Excel was stored as a number (the default), the tool reads the numeric value. The number 00123 is stored as 123 internally. To preserve leading zeros, format the column as Text in Excel before typing the values, or add an apostrophe before the number (e.g., '00123).

Can I control the encoding of the CSV?
The tool outputs UTF-8 without a byte order mark (BOM). This is the standard encoding for modern applications. If you need a different encoding (e.g., Windows-1252) you will need to convert the file afterwards. Most CSV importers can handle UTF-8.

What if my data contains commas and line breaks?
The tool automatically quotes cells that contain the chosen delimiter or line breaks. For example, a cell containing Hello, world becomes "Hello, world". Line breaks inside a cell are preserved inside quotes. However, not all downstream tools handle quoted line breaks correctly – test with a small sample first.

Is my data safe?
Yes. The conversion runs entirely in your browser using JavaScript. No file data is uploaded to any server. You can disconnect from the internet after the page loads and the conversion will still work. This is a key advantage for sensitive spreadsheets.

How do I convert an older .xls file?
This tool only supports the modern .xlsx format. If you have a .xls file (Excel 97–2003), open it in a recent version of Excel, LibreOffice, or Google Sheets and save it as .xlsx. Then upload the new file.