search
format_align_left
JSON Formatter CSS Formatter HTML Formatter JavaScript Formatter XML Formatter SQL Formatter Exception Formatter Markdown Preview & HTML to Markdown
data_object
JSON to Excel/CSV JSON to TypeScript, C#, Go, Java, Kotlin, Python & Dart JSON ⇄ YAML / TOML Converter JSON Diff – Compare Two JSON JSON Viewer & JSONPath Tester
table_chart
Excel/CSV to JSON Excel/CSV to SQL Excel/CSV to HTML
description
Compare text Text to Hex Text to Base64 Case Converter Regex Tester Vietnamese Accent Remover & Slug Generator Word Counter Line Tools: Remove Duplicates, Sort Lines Lorem Ipsum Generator
image
Convert Image Image to Base64 Converter Image Compressor Resize & Crop Image Favicon Generator Color Palette from Image EXIF Viewer & Remover
qr_code_2
QR Code Generator QR Code Scanner VietQR Bank Transfer QR Generator Wi-Fi QR Code Generator vCard QR Code Generator (Business Card) Barcode Generator (EAN-13, Code 128, Code 39)
lock
Convert Token Convert Hash Generate Password HMAC Generator (SHA-256, SHA-512) AES Encrypt / Decrypt Online Bcrypt Hash Generator & Checker
schedule
Convert datetime Timezone Info Vietnamese Lunar Calendar Converter Date Calculator Cron Expression Parser Countdown Timer
link
Encode and Decode URLs Shorten URL URL Parser & UTM Builder HTTP Header Checker
storage
Statistics Parser Statistics Compare SQL INSERT to JSON Converter SQL Table to C# / TypeScript / Java Class
travel_explore
Create Sitemap robots.txt Generator Meta Tag Generator Open Graph Preview
terminal
Number Base Converter UUID / ULID / NanoID Generator Chmod Calculator HTTP Status Codes
palette
Color Picker
help_outline
About UsPrivacy PolicyTerms of Service
THUTOOL
search

JSON Viewer & JSONPath Tester

🔒 Processed 100% in your browser – your data never leaves your device

Paste JSON on the left to see it as a tree.

Click a key to copy its JSONPath.

JSONPath query

Examples:

How to use the JSON Viewer

  1. Paste JSON in the input box (or click Sample). It is shown as a tree with the first two levels open.
  2. Click ▸ / ▾ to open or close a node, or use Expand all / Collapse all.
  3. Type in the search box to highlight matching keys and values. Nodes that contain matches open automatically.
  4. Click a key to copy its JSONPath, for example $.store.book[0].title.
  5. Type a JSONPath expression in the query box to list every matching value.

Supported JSONPath syntax

  • $ root, .key or ['key'] child, .* / [*] all children
  • [0], [-1] (last), [0,2] indexes, [1:3], [::2] slices
  • ..key search at any depth
  • Filters: [?(@.price < 10)], [?(@.type == 'book' && @.stock)], [?(@.isbn)] (key exists)

Example

For {"store": {"book": [{"title": "A", "price": 8}, {"title": "B", "price": 12}]}}, the query $.store.book[?(@.price < 10)].title returns "A".

FAQ

Can it open large files? Yes. Large arrays show 200 items at a time with a "Show more" button so the page stays responsive.

Is the full JSONPath standard supported? The common syntax above is supported. Script expressions such as (@.length-1) are not.

Is my JSON sent anywhere? No. Parsing, search and queries run in your browser.

Related tools

  • JSON to Excel/CSVConvert JSON to Excel (XLSX) or CSV online for free. Paste or upload JSON and download a ready-to-use spreadsheet in seconds.
  • JSON to TypeScript, C#, Go, Java, Kotlin, Python & DartGenerate TypeScript interfaces, C#/Java/Kotlin classes, Go structs, Python dataclasses/Pydantic and Dart models from JSON. Runs in your browser.
  • JSON ⇄ YAML / TOML ConverterConvert JSON to YAML or TOML and back. Choose indent, pretty or minified output, see syntax errors by line and column. Runs 100% in your browser.
  • JSON Diff – Compare Two JSONCompare two JSON documents online, ignoring key order. See added, removed and changed values by JSON path, side by side. Runs in your browser.
  • Date CalculatorCount days, weeks, months and business days between two dates, or add and subtract days, weeks, months and years. Free and runs in your browser.
  • URL Parser & UTM BuilderSplit a URL into protocol, host, port, path, query parameters and hash; edit parameters, rebuild the URL and add UTM tags. Runs in your browser.
@Made by THUTOOL