Excel to JSON screenshot

Excel to JSON

Convert CSV or Excel spreadsheet data into JSON records.

Privacy First
0 Runs
Updated 2026-11-08
Runs on the tool server
No account needed
The input is not stored
Row and column counts reported

Convert CSV or Excel spreadsheet data into JSON records. Enter your numbers and get an instant result.

Paste CSV text or a Base64 workbook, choose the format and orientation, and the page returns the same table as JSON with its row and column counts.

This page executes on the tool server: the content, the csv-or-xlsx format and the records, list or dict orientation are sent for that one request, the parse runs there, and nothing is stored. An unsupported format is refused with the reason rather than parsed as the wrong kind.

The three orientations describe the same table three ways: records is the standard array of row objects, list is an array of arrays, and dict groups rows by column.

What the conversion covers

CSV text is read as-is; a workbook travels as Base64 under the xlsx format and is decoded before parsing. The orientation switch reshapes the output without touching the table: the same rows and columns come back in all three.

The response carries the converted JSON together with its row and column counts, so a truncated paste is visible as a count that does not match the source.

  • CSV text or Base64 xlsx input
  • Records, list or dict orientation
  • Row and column counts beside the JSON

What is sent and what is kept

The request carries the table content and the two options, and the response carries the JSON. Neither is written to disk or logged; a second conversion is a second request with no memory of the first.

An empty input is refused with the reason, and a format outside csv and xlsx is refused before any parsing, so a mislabelled paste never returns a misread table.

How to use the table and options

Paste the CSV text, or a workbook encoded as Base64 for the xlsx format, choose the csv-or-xlsx format and the records, list or dict orientation, then press Execute Tool Engine. The page returns the same table as JSON with its row and column counts, so a truncated paste is visible as a count that does not match the source.

An unsupported format is refused with the reason rather than parsed as the wrong kind, and an empty input is refused before any parsing. The request carries the content and the two options for that one run and keeps nothing.

What to Expect

Best for

  • Turning a pasted CSV into JSON for an API
  • Reading an xlsx export without a spreadsheet app
  • Reshaping a table between the three orientations

Not ideal for

  • Multi-sheet workbooks with formulas intact
  • Cleaning or validating the table first
  • Files too large to paste

What this tool keeps

  • Every cell the parse could read
  • The same JSON for the same input and options
  • Your table private beyond the single request

What may need cleanup

  • Checking the counts against the source sheet
  • Typing headers the CSV never had
  • Re-encoding special characters for the target system

Common errors

  • Pasting xlsx bytes as text instead of Base64
  • Choosing the wrong format for the pasted content
  • Expecting formulas to survive as formulas

Example use cases

  • Converting an exported report for an import endpoint
  • Turning a copied spreadsheet range into row objects
  • Inspecting a workbook's shape through its counts

Sample input

CSV text with a header row, converted with the csv format and records orientation.

Sample output

An array of row objects with the row and column counts, parsed on the tool server.

Who this is for

  • Developers feeding APIs
  • Analysts reshaping exports
  • Anyone moving tables into JSON

Frequently asked questions

What can I paste in?

Raw CSV text, or a workbook encoded as Base64 for the xlsx format. The format switch tells the page which one it is reading.

What do the three orientations mean?

Records is the standard array of row objects, list is an array of arrays, and dict groups rows by column. All three describe the same table.

Does the page keep my spreadsheet?

No. The content is sent for that one conversion and the JSON comes back with its row and column counts; nothing is stored.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.