View JSON as a Table

This tool converts JSON arrays into a visual HTML table format. It's the fastest way to preview JSON data in a readable, spreadsheet-like view without leaving your browser.

Supported JSON Structures

The tool works best with arrays of objects:

[
  { "name": "Alice", "age": 30 },
  { "name": "Bob", "age": 25 }
]

Or an object containing an array:

{
  "users": [
    { "name": "Alice", "age": 30 },
    { "name": "Bob", "age": 25 }
  ]
}

Features

• Auto-detect arrays — Finds the first array in your JSON
• Merged columns — Handles objects with different fields
• Type highlighting — Booleans, nulls, and objects are color-coded
• HTML export — Copy as HTML table for use in documents

Common Use Cases

• API response inspection — Quickly visualize API data
• Data validation — Check data structure at a glance
• Documentation — Generate tables for documentation
• Debugging — Easier than reading raw JSON

Handling Special Values

HTML Export

Click "Copy HTML" to get a clean HTML table you can paste into:

• Confluence or wiki pages
• Email clients
• HTML documents
• CMS platforms

Programmatic Conversion

JavaScript

function jsonToHtmlTable(data) {
  if (!Array.isArray(data) || data.length === 0) return '';
  
  const headers = Object.keys(data[0]);
  const headerRow = headers.map(h => `<th>${h}</th>`).join('');
  
  const bodyRows = data.map(row => 
    `<tr>${headers.map(h => `<td>${row[h] ?? ''}</td>`).join('')}</tr>`
  ).join('');
  
  return `<table><thead><tr>${headerRow}</tr></thead><tbody>${bodyRows}</tbody></table>`;
}

Python

import json
import pandas as pd

# Read JSON and convert to HTML table
data = json.loads(json_string)
df = pd.DataFrame(data)
html_table = df.to_html(index=False)

Pro Tips

• 💡 Large datasets — For very large arrays, the table might be slow. Consider paginating or filtering first.
• 💡 Nested data — For deeply nested JSON, useJSON Flatten first.
• 💡 Export to spreadsheet — Use JSON to CSV for Excel or Google Sheets.

Related Tools

• JSON to CSV — Export to spreadsheet format
• JSON Flatten — Flatten nested data first
• JSON Path — Extract specific data
• JSON Validator — Validate your JSON