JSON to Table Online

Turn JSON into an editable table online, then download as JSON, CSV, Excel or Parquet. Free, private.

Quick answer: Edit nested JSON as a tree or a table and export it again.

Related: JSON Table Editor: Edit Nested JSON as a Table · JSON Visual Editor Online · Edit JSON as a Table · JSON Array to Editable Table · JSON Guides and Free JSON Tools

How to use the JSON to Table Online

Edit nested JSON as a tree or a table and export it again.

The JSON Table Editor lets you edit nested JSON without writing code. Open it as a tree to change any value, add or delete keys and items, and change types. Or switch to the Table view, where a list of objects becomes rows and columns (nested fields become columns such as customer.name), and edit cells like a spreadsheet. Every edit updates the JSON, so you can download it again as JSON, or export the table as CSV, Excel or Parquet. You can also open a CSV or Excel file and turn it into JSON; columns named like a.b become nested objects. It all runs in your browser.

1. Drop or paste JSON
2. Edit in the Tree, Table or Text view
3. Download the JSON or the table

Tips

• Use the Table view when your JSON has a list of records. If there are several lists, pick one in "Rows from".
• Type null, true or false in a table cell to set those values.
• Use Search rows to filter a big table. Edits and deletes still change the right row.
• Open a CSV and name columns like address.city to get nested JSON back.
• The Text view shows the exact JSON that will be downloaded.

Example

Input: [{"id":1,"city":"Pune"}]

Output: A table you can edit and export

Browse by topic

• Parquet Guides and Free Parquet Tools
• CSV Guides and Free CSV Tools
• JSON Guides and Free JSON Tools
• Excel Guides and Free Excel Tools
• Data Privacy Guides and Free Tools
• Test Data Guides and Free Generators
• Data Cleaning Guides and Free Tools
• AI Data Tools and Guides
• Extract Data from Screenshots and APIs
• File Format Guides and Free Tools

Who uses Data Utility

• Free Data Tools for Marketing Lists
• Free Data Tools for Finance and Accounting Exports
• Free Data Tools for Developers
• Free Data Tools for Data Analysts
• Free Data Tools for Small Business

Frequently asked questions · Data format benchmark

Frequently asked questions

Can I export the table to Excel?

Yes. Download as JSON, CSV, Excel or Parquet.

Does it handle nested JSON?

Yes. The Tree view shows every level. The Table view flattens nested fields into columns, and your edits go back into the nested JSON.

Can I turn a table back into JSON?

Yes. Open a CSV or Excel file, edit it, and download the JSON. Column names with dots, such as customer.name, become nested objects.

Related pages

• JSON Table Editor: Edit Nested JSON as a Table: Edit nested JSON as a tree or a spreadsheet-like table, then download JSON, CSV or Excel. Free, runs in your browser, nothing is uploaded.
• JSON Visual Editor Online: Edit JSON with a visual tree editor online: change values, add or remove keys and items, change types. Free, in your browser.
• Edit JSON as a Table: Turn a JSON array into an editable table, fix cells like in a spreadsheet and download JSON or CSV again. Nested fields become columns. Free.
• JSON Array to Editable Table: Show a JSON array of objects as a table you can edit, add rows to and export as JSON, CSV or Excel. Free, in your browser.
• JSON Viewer Online: View JSON as a tree or a table, expand nested data and edit values. Free, private, handles large files without freezing.
• Edit JSON Online: Edit a JSON file online in a tree, a table or as text. Change values, add and delete rows, then download. Free, nothing uploaded.
• View JSON as a Table: Show a JSON array as a spreadsheet-like table with one column per field, search it and edit cells. Free, in your browser.
• Edit Nested JSON: Edit nested JSON with objects inside arrays inside objects: expand the tree, edit values, or open an array as a table. Free, private.

Topic guides

• JSON Guides and Free JSON Tools