JSON Analyzer
Get JSON Analyzer
macOS + Windows · local-first

See any JSON
as a spreadsheet.

Open a messy JSON dump (or a whole NDJSON log) and read it as a sortable, filterable grid. Query it, flatten it, export to Excel. No jq, no online formatters, nothing leaves your machine.

macOS universal (Apple Silicon + Intel) · Windows x64 + ARM64 · 14-day Pro trial included

JSON Analyzer showing a deeply nested employees.json in tree view: profile, contact, address, location, geo and timezone nested six levels deep.
Nested ten levels deep.
Flat
The same file in JSON Analyzer's flat view: a 402-row spreadsheet with columns like profile.contact.address.city, and an export menu offering CSV and XLSX.
402 rows. Every leaf a column.

A 5,000-line JSON dump is not a table. Your eyes know it.

So you paste it into an online formatter you shouldn't trust with prod data, or wrestle jq until the array finally lines up. JSON Analyzer skips all of it: open the file, and arrays of objects are a spreadsheet: one you can sort, filter, query, flatten, and hand to Excel.

The loop

Blob to Excel in three moves.

01 — OPEN

Drop in the JSON

Files up to 50 MB open instantly as a dense nested grid, several at once as tabs. JSON Lines, NDJSON and log files open as one table, one row per line.

02 — NARROW

Query & filter to what matters

Press ⌘⇧F and type $.rows[?(@.status=="ERROR")]. Or just ask “rows where status is ERROR” in plain English. Stack Excel-style column filters on top.

03 — EXPORT

Send it to a real file

Right-click → export the exact visible view to CSV, XLSX, or Markdown. Newlines, commas and quotes inside cells stay intact, which a clipboard copy can't do.

JSON Analyzer's Ask bar with the plain-English question: All employees with more than 8 years of experience. The JSONPath the app wrote from that question, $.employees[?(@.profile.projects[*].tasks[*].assignedTo.skills.experience.years > 8)], with its 54 matching rows highlighted in the grid.
02 — Narrow. Ask in English. The app writes the query, six levels down, and highlights all 54 matches.
Built for real files
▦ GRID

Nested grid rendering

Structure shows through cell containment, not runaway indentation. Expand any node in place; 1k-row chunking keeps huge arrays fluid.

A contact object in JSON Analyzer's grid: address nested inside it, location inside that, then geo and timezone, each drawn as a box within a box rather than indented text.
⊟ FLAT

Flat view

One click flattens any nesting into a single spreadsheet: every leaf becomes a column (user.address.city), arrays expand to rows. Query it like any table.

JSON Analyzer's flat view: every nested leaf has become its own column, with dotted header names like employees[].name and profile.contact.email, and an export menu offering CSV and XLSX.
⌘⇧F QUERY

Structural queries

A documented JSONPath subset. $.rows[?(@.id>3)] filters a table to matching rows in place, and composes with sort, filters and editing.

JSON Analyzer's query bar running $.employees[*].profile.contact.email, with every matching email cell highlighted in the grid below.
✦ ASK

Ask in plain English

Type what you want; the app writes the query. “Explain this JSON” summarizes an unfamiliar file's shape. Optional, uses your own Anthropic key, and you preview every request before it's sent.

JSON Analyzer's Ask bar with a plain-English question typed into it: All employees with more than 8 years of experience.
▼ FILTER

Excel-style column filters

Per-column value checklist with live counts, funnel indicators, and visible/total tallies. Column profiling on header hover: distinct, min, max, null share.

A column filter dropdown in JSON Analyzer: sort A to Z or Z to A, a search-values box, and a checklist of every distinct value with its row count, plus a clear-filter action.
⤓ EXPORT

CSV · XLSX · Markdown · JSON

A real .xlsx with typed numeric cells. No dependency, no upload: what you see filtered on screen is exactly what lands in the file.

JSON Analyzer's right-click menu on a subtree: copy subtree as JSON, export subtree as JSON, copy TypeScript type, copy JSON Schema, copy path, and export the table as CSV, XLSX or Markdown.
✎ EDIT

Byte-fidelity editing

Edit scalars in place with type auto-detection and undo/redo. Save is byte-minimal: untouched bytes stay byte-identical to the original.

✓ SCHEMA

Validate & infer types

Check a document against a JSON Schema with inline errors on the exact cells. Going the other way, copy an inferred TypeScript type or JSON Schema from any file.

⧉ TABS

Multi-file tabs

Compare an API response against yesterday's fixture side by side. Each tab keeps its own view, filters, query, and undo history.

Developers debugging API dumps QA reading fixtures Support engineers Data analysts
Pricing

Free to explore, one-time payment for advanced features. Because everybody hates subscriptions.

14-DAY TRIAL Every download starts with full Pro for 14 days — no account, no card, it just quietly becomes Free.
Free
€0
  • Open & view any JSON as grid or tree
  • JSON Lines / NDJSON / logs as one table
  • Sort, flip, resize, expand/collapse
  • Text search, copy value / subtree / path
  • Query, filters, Flat view & exports
  • Editing, validation, AI & multi-tab
Launch price
Pro — one-time
€19 then €29
pay once, yours forever · not a subscription
  • Everything in Free
  • Structural queries + plain-English ask
  • Column filters & profiling · Flat view
  • Export CSV, XLSX, Markdown & subtree JSON
  • Byte-fidelity editing & saves · multi-file tabs
  • Schema validation · TS type / JSON Schema inference
  • Free updates within the major version
WINDOWS · UNSIGNED

The Windows installers aren't code-signed yet, so Windows greets them with a blue “Windows protected your PC” screen. That's expected: click More info, then Run anyway. It's the same app as the macOS build, from the same source. We'll buy a signing certificate once Windows demand covers the yearly cost; until then we'd rather ship it than make you wait.

Windows x64 Windows ARM64 x64 for most PCs · ARM64 for Snapdragon / Surface
◆ LOCAL-FIRST

Your JSON never touches a server. No sign-up, no cloud, no analytics — just a fast native app reading files on your own disk.

The two AI features are strictly opt-in: they use your own Anthropic API key, stored in the macOS Keychain or Windows Credential Manager, and show you the exact request (a capped outline of the file's structure) for approval before anything is sent. Skip them and the app never makes a network call at all.

Stop scrolling raw JSON.

Open it as a spreadsheet, filter to what broke, and export the proof, all in about ten seconds.