JSON → Table
Turn a JSON array of objects into a sortable table you can copy as CSV or Markdown.
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 arrayFrequently 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).