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.

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 or Tree · JSON Visual Editor Online · JSON Array to Editable Table · JSON Guides and Free JSON Tools

How to use the Edit JSON as a Table

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

Example

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

Output: id | city

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Can I edit JSON like a spreadsheet?

Yes. A list of objects becomes rows and columns. Edit a cell and the JSON updates.

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

Topic guides