Skip to content
toolsdocks

Convert between CSV, Excel and JSON

Convert spreadsheet and JSON files between CSV, TSV, XLSX and JSON in your browser, with sheet, delimiter and JSON shape options.

Runs on your device
Loading tool…

How to use

  1. Open a file.
  2. Choose the output format and options (sheet, delimiter, JSON as array of objects or arrays).
  3. Convert and download.

Worked example

id,name,qty with 000123,Ann,42 converted to XLSX and then to JSON with typed values gives {"id":"000123","name":"Ann","qty":42}: the ID keeps its zeros as text and 42 becomes a number. [{"name":"Ann","address":{"city":"Oslo"}}] flattens to the CSV columns name,address.city and rebuilds the same JSON.

Supported formats and limits

InputCSV, TSV, XLSX, XLS, ODS, JSON
OutputCSV, TSV, XLSX, JSON
LimitsUp to 100 MB.
EngineSheetJS Community Edition + Papa Parse; dot-path flattening for nested JSON

Limitations

  • Formulas are exported as their last calculated values; formatting and charts are not converted.
  • XLS and ODS can be read but not written; output is CSV, TSV, XLSX or JSON.
  • Arrays in JSON become numbered columns (tags.0, tags.1).

Questions

Will IDs such as 000123 keep their leading zeros?

Yes. Only values written as plain canonical numbers (such as 42 or -1.5) become numeric cells or JSON numbers; 000123 stays text. You can also write every XLSX cell as text, or turn off typed JSON values.

Which conversions are supported?

Input: CSV, TSV, delimited text, XLSX, XLSM, XLS, ODS, JSON and JSON Lines. Output: CSV, TSV, XLSX and JSON as an array of objects, an array of arrays or JSON Lines.

What happens to workbooks with several sheets?

The first sheet is converted unless you choose another. With all sheets selected, XLSX output keeps them as sheets in one workbook, and CSV or JSON output gives one file per sheet.

What is lost in conversion?

Formulas become their last calculated values, and formatting, charts and comments are dropped. Spreadsheet dates are written as text such as 2026-03-04.

Guides

Privacy

Runs on your device. Files and text are processed in this browser tab and are not uploaded.

See the privacy policy for how toolsdocks handles data.