XLSX to CSV

How this reads your output

The workbook is parsed in the page and each sheet written out as its own CSV, since a CSV holds exactly one table. Quoting is applied only where a value needs it, so simple files stay readable. Before the download, what will not survive the conversion is stated: formulas become the values they last produced, merged cells become one value and some blanks, and formatting goes entirely. Those losses are inherent to the format rather than a limitation of this tool, and knowing which apply to your file is the difference between a clean conversion and one that looks corrupt for reasons nobody can find.

What the results mean

One file per sheet

Not a choice — a CSV is a single table by definition, so a three-sheet workbook is three files.

Formulas lost

CSV stores results. The calculation is gone, and the value is whatever the workbook last computed.

Merged cells

The value goes in the first cell and the rest are blank. Worth fixing in the original before converting if the merge carried meaning.

Quoting

Applied only to values containing a delimiter, a quote or a line break — which keeps simple files simple.

Common problems and fixes

The header row is wrong in the CSV

The workbook probably has a title above the table, so the first row is not the header. Delete the rows above the table in the original and convert again.

Dates came out as numbers

Spreadsheets store dates as numbers and display them as dates. Format the column as text in the original before converting if the displayed form is what you need.

I need the formulas, not the values

CSV cannot hold them. Keep the original workbook — the conversion is one-way by design.

Frequently asked questions

More in Data

• XLSX ViewerOpen a spreadsheet without a spreadsheet program — and without uploading it.
• CSV ViewerView a CSV as a table — and find the rows that do not line up.