Buy me a coffee
Advertisement

Drag and drop a JSON file here, or click to select a file

Input JSON
Query JSON
Transform JSON
Output

Query JSON

Extract specific data using JSONPath queries.

Transform

Apply custom JavaScript transformations to your JSON data.

CSV Export

Convert JSON arrays to CSV format with customizable options.

Tree View

Visualize and navigate complex JSON structures with an interactive tree.

Advertisement
Query JSON with JSONPath

JSONPath Examples:

  • $.store.book[*].author - All authors of books
  • $..author - All authors
  • $.store.book[?(@.price < 10)] - Books cheaper than $10
  • $.store.book[-1:] - Last book
Transform JSON with JavaScript

Transform Examples:

  • Extract all names: return data.map(item => item.name);
  • Filter active items: return data.filter(item => item.active);
  • Sum all values: return data.reduce((sum, item) => sum + item.value, 0);
  • Restructure data: return data.map(item => ({ id: item.id, fullName: `${item.firstName} ${item.lastName}`, isActive: item.status === 'active' }));

Available Keys:

Copied to clipboard!