---
title: "ODS to JSON Converter Online: Free & Private - WeConvert"
description: "Convert ODS to JSON free. Your files never leave your device. The first row becomes the keys; dates become ISO dates. Every sheet is read."
url: "https://weconvert.app/convert/ods-to-json"
language: "en"
---

> Prices, limits and privacy: https://weconvert.app/llms.txt

# ODS to JSON

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.

## Related

[All ODS conversions](https://weconvert.app/convert/ods)

- [ODS to CSV](https://weconvert.app/convert/ods-to-csv)
- [CSV to JSON](https://weconvert.app/convert/csv-to-json)
- [ODS to TSV](https://weconvert.app/convert/ods-to-tsv)
- [TSV to JSON](https://weconvert.app/convert/tsv-to-json)
- [ODS to XLSX](https://weconvert.app/convert/ods-to-xlsx)
- [XLSX to JSON](https://weconvert.app/convert/xlsx-to-json)
- [XLS to JSON](https://weconvert.app/convert/xls-to-json)
