Sheet to JSON
Convert tabular data to JSON records.
Add documents
PDF, DOCX, images, spreadsheets or text files.
Choose a tool
Convert tabular data to JSON records.
About Sheet to JSON
Sheet to JSON turns the first worksheet of a spreadsheet into an array of JSON objects. The first row is used as the property names, and each following row becomes one record. Empty cells become null, so every record has the same keys, which suits APIs, seed data and front-end apps.
When it helps
- Seeding a database or mock API with data maintained in Excel
- Turning a product or price list into data for a website
- Handing a non-technical colleague's spreadsheet to a developer in a usable format
Tips
- Make sure row 1 has unique, clear column headers, since they become the JSON keys. Blank or duplicate headers produce awkward key names.
- Dates stored as real date cells may come out as Excel serial numbers, such as 45000, rather than formatted dates. Store dates as text if you need them readable.
- Numbers are output as JSON numbers, so IDs with leading zeros should be stored as text in the sheet to keep them intact.
Good to know
Quick answers about sheet to json in your browser.
An array of objects, one per row, for example [{"name": "Ana", "age": 31}, ...], using the header row as keys.
Yes. CSV and TSV files are read as a single sheet and converted the same way.
Yes. There is no sign-up, no watermark and no limit on how many files you process.
No. Files are read and processed locally in your browser, so they never leave your device.
Related tools
Part of the Document Converter collection.