ODS to JSON

Your files never leave your device.

Choose a format
Choose a format

The first row becomes the keys and every row after it becomes one object. A workbook with several sheets gives one list per sheet.

Questions about ODS to JSON

How does ODS to JSON work?

ODS to JSON reads every sheet of an OpenDocument spreadsheet and turns each row into a JSON object keyed by the first row. Numbers and true/false keep their types, dates become ISO dates like 2024-01-15, and formulas give their results. With several sheets you get one object containing a list per sheet name.

Which JSON shape do I get?

For a single sheet, an array of objects. For several sheets, an object whose keys are the sheet names, each holding its own array. Both shapes can be turned back into a spreadsheet with JSON to ODS.

Are formatted values kept?

No, you get the raw value. A cell showing 25% becomes 0.25 and a currency amount becomes a plain number, which is easier to work with in code.

What happens to empty rows and cells?

Completely empty rows are skipped. Empty cells inside a row become null, so every object from a sheet has the same keys.