Skip to the tool
GigaJSON

JSON Path Finder

All tools
Format and check
View and query
Convert
Encode and decode
Sample files
Guides Open GigaJSON

Paste JSON and click a key or value in the tree to get its path, written three ways: JSONPath ($.items[0].sku), jq (.items[0].sku) and JavaScript (data.items[0].sku). Keys with spaces, dots or quotes are quoted the way each language expects. To find something without scrolling, type part of a key or value in the search box.

How to use it

  1. Paste JSON or open a file.
  2. Click a key or value in the tree, or search for it and click a match.
  3. Copy the path you need: JSONPath, jq or JavaScript.

Private, and made for big files

This tool runs in your browser, in a background worker: nothing you paste or open is uploaded, and nothing is kept after you leave. JSON and XML input can be up to 1 GB, depending on available memory. Processing runs in a background worker; large analyses can take a minute or more. If your connection drops while you're here, the tool keeps working. When one tool isn't enough, GigaJSON opens your data with a tree, a table, JSONPath/JMESPath/jq queries, transforms, diff and history.

Questions

How are keys with spaces or dots written?

In brackets with quotes: $['first name'] in JSONPath, .["first name"] in jq and data["first name"] in JavaScript. Quotes and backslashes inside a key are escaped, so the path reads back the same value.

Can I use the path in a query?

Yes. The JSONPath form works in the JSONPath tester and the jq form in the jq playground. Both start from the root of the document.

Does it work with large files?

Yes. A large document opens one level deep, and you open the branches you need. Search lists the first 100 matches and counts the rest.

Is my data uploaded?

No. The tool runs in your browser, in a background worker. Nothing you paste or open goes to a server, and nothing is kept after you leave the page.

All tools