Convert ODS to JSON

Row one supplies the keys and every row beneath it becomes an object. Merged headings are the thing to check first - a merge leaves one key with an empty one beside it, which is rarely what was meant.

Drop ODS file(s) to start

or click to browse

What is ODS?

LibreOffice and OpenOffice's spreadsheet, and the ISO-standard one - the same ODF packaging an ODT uses, with sheets where a document has pages. Every cell stores its value and, separately, the text shown for it, which is why a figure formatted as currency can still be read back as the number underneath.

What is JSON?

The format the web runs on. Nested objects and arrays, real types, and a syntax small enough to fit on a postcard. It maps badly onto a grid, which is why converting deeply nested JSON to a spreadsheet always involves losing something.

Your files never leave your device · no magic required