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.

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 · Edit JSON as a Table · JSON Guides and Free JSON Tools

How to use the JSON Array to Editable 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},{"id":2}]

Output: 2 rows

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

What if my array is nested inside an object?

The editor finds every list of objects in your JSON and lets you choose which one to show as rows.

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