Turning Spreadsheets into JSON
What this converter does
A spreadsheet is a grid of rows and columns; JSON is a tree of keys and values. This tool bridges the two by reading an Excel workbook — XLSX, XLS, CSV, or ODS — and rewriting each row as structured JSON. It parses the file directly, detects the sheets inside it, and lets you decide how the rows should be shaped in the output.
Two output modes cover most needs. Object format uses the header row as keys, producing one JSON object per data row — the shape most APIs and scripts expect. Array format drops the keys and emits each row as a compact array of values, which is smaller and closer to the raw grid.
When to use it
The typical case is turning a spreadsheet someone maintains by hand into data a program can read. A product list, a price table, or an exported report becomes a JSON array you can drop into an API request, a config file, or a database seed.
It also helps while you are prototyping. Instead of hand-writing sample JSON, you can lay the data out in familiar spreadsheet columns, convert once, and paste the result straight into your code or a mock server.
Example: rows to objects
Imagine a sheet whose first row reads name, price, in_stock, and whose next rows hold Keyboard, 39.90, true and Mouse, 19.50, false. With the first row treated as headers and object format selected, the converter returns [{"name":"Keyboard","price":39.90,"in_stock":true}, {"name":"Mouse","price":19.50,"in_stock":false}]. Each header becomes a key, each cell becomes its value, and one object is produced per row.
Notes and edge cases
A few options shape the result. When the first row holds column titles, enable header handling so those titles become keys instead of a data row. Date parsing turns spreadsheet date cells into readable values rather than Excel's internal serial numbers, while raw-value mode keeps cells exactly as stored when you would rather format them yourself. Empty cells can be filled with a default such as an empty string, blank rows can be skipped, and surrounding whitespace can be trimmed. If a workbook holds several sheets, pick one to convert or export them all; the row, column, and sheet counts shown next to the preview help you confirm the file parsed as expected.