JSON → Table

JSON → Table

Convert JSON to table online. Transform JSON arrays into sortable, searchable tables. Export to CSV or copy as markdown—free and instant.

JSON Array Input

0 lines · 0 chars

Loading editor...

Usage Tips:

  • • Input must be a JSON array of objects
  • • Each object becomes a row in the table
  • • Object keys become column headers
  • • Nested objects are displayed as JSON strings

Features

  • Convert JSON arrays to sortable tables
  • Search and filter table data
  • Export to CSV format
  • Copy as markdown table
  • Handle nested objects
  • Responsive table layout

Common Use Cases

  • Visualize JSON API responses as tables
  • Export JSON data to spreadsheets
  • Create markdown tables for documentation
  • Analyze array data quickly
  • Share readable data with non-developers

Understanding JSON to Table Conversion

JSON to table conversion transforms JSON arrays into tabular format for easier viewing and analysis.

How it works:

  • Arrays of objects - Each object becomes a table row, keys become column headers
  • Nested objects - Flattened using dot notation (e.g., user.name)
  • Arrays in values - Displayed as comma-separated values or JSON strings
  • Mixed types - All values converted to strings for display

Export options: Export to CSV for Excel/Google Sheets, or copy as markdown for documentation.

Examples

Valid - Simple array of objects
[
  {"name": "Alice", "age": 30},
  {"name": "Bob", "age": 25}
]
→ Table with columns: name, age
Valid - Nested object flattening
[
  {"user": {"name": "Alice", "id": 1}}
]
→ Column: user.name, user.id
Invalid - Not an array (invalid)
{"name": "Alice", "age": 30}
→ Error: Input must be an array

Frequently Asked Questions

What JSON format works best?

An array of objects where each object has the same keys. Example: [{"name":"Alice","age":30},{"name":"Bob","age":25}].

Can I convert nested JSON?

Yes! Nested objects are flattened using dot notation (e.g., user.name, address.city).

How do I export to Excel?

Click "Export to CSV" and open the downloaded file in Excel or Google Sheets.

What if objects have different keys?

All keys from all objects become columns. Missing values show as empty cells.

Can I sort the table?

Yes, click on any column header to sort by that column (ascending/descending).