Skip to main content
WizTools123
Free Online Tools

Tool Categories


JSON Tools New Tool

Free Online JSON Key and Value Extractor

List every key a JSON document uses with how often each appears, pull out every value of one key wherever it occurs, or pick several keys and get a flat list of records ready for a spreadsheet. A key that is present but null is reported separately from a key that is absent, because those are different answers.

Free Forever Nothing Uploaded Keys and values Many files at once
Free Online JSON Key and Value Extractor
Share this tool
Advertisement Slot (Top Banner) Google AdSense Unit • Responsive Banner
JSON Key and Value Extractor Your file is read inside this tab. Nothing is uploaded anywhere.
Drop the JSON files you want to pull values out of Or paste one below. Nothing in the document is changed. Choose files Up to 15 MB per file. Nothing is uploaded.
0%
Or paste it
Reading
What to do
The key
The keys Separate them with commas. A dot reaches one level down.
The result

0 rows 0 distinct 0 present but null 0 absent

Result
0 characters 0 lines 0 B
Buy Us A Coffee

Enjoying WizTools123? Help keep our server infrastructure 100% free and open for everyone.

Buy Us A Coffee
Sponsored Content (Below Tool) Google AdSense Placement

How to Use JSON Key and Value Extractor

Step by step, start to finish.

1
Paste the JSON, or drop the files

Any shape. The sample has keys at several depths and one key that appears twice in different places.

2
Pick what you are after

The list of keys is for understanding an unfamiliar response. The other two modes are for getting data out of a familiar one.

3
Name the key, or several

Keys found in the document are suggested as you type. A dot reaches one level down, as customer.name.

4
Take it as lines, JSON or CSV

CSV opens straight in a spreadsheet. Several files each produce their own result, downloadable as one zip.

Key Features

What this tool does, and what it does not do.

Every key, with counts

The fastest way to understand a response you have never seen, including how deep each key sits.

One key, everywhere

Every value of a key at any depth, optionally with the full path of each one.

A flat table of records

Name several keys and get one row per record, which is what a spreadsheet actually needs.

Absent is not null

Missing keys and null values are counted separately, because they mean different things.

Lines, JSON or CSV

Three output shapes, with distinct values and counts as switches rather than separate tools.

Nothing is uploaded

Everything is read in this tab, so a response full of customer records never leaves it.

About JSON Key and Value Extractor

There are two completely different reasons to pull things out of a JSON document, and they want different tools. The first is understanding: you have been handed a response from an API nobody documented and you need to know what is in it. A list of every key, with how often each appears and how deep it sits, answers that in a few seconds, and it is much faster than scrolling through a formatted tree.

The second is extraction: you know the document and you want some of its data somewhere else, usually a spreadsheet. This is where most tools stop being useful, because the data you want is nested and a spreadsheet is flat. Getting every sku out of a nested order document is easy enough to describe and surprisingly annoying to do by hand, and getting four particular fields out as a table with one row per record is the thing people actually need and almost never have a button for.

The distinction the tool is careful about is absent against null. A record that has no note field and a record whose note is null are different facts about your data, and squashing them together into "empty" sends people to look for the wrong bug. So both are counted, separately, and you can see at a glance whether a field is sometimes missing, sometimes empty, or both.

The last decision is that distinct values are compared as values rather than as text. The number 5 and the string "5" look the same when printed and are not the same thing, and a tool that merges them helps hide exactly the kind of inconsistency you would want to find. Keeping them apart occasionally looks like a longer list than you expected, and that longer list is the answer.

Frequently Asked Questions

Common questions about this tool.

Listing keys tells you what is in a document you do not know. Pulling out one key gets you a single column of data. The flat table mode takes several keys and gives you rows and columns, which is what you want if the destination is a spreadsheet.

Yes. Naming a key finds it at every depth, which is what people mean by all the skus. If you only want one particular location, write the dotted path to it and nothing else is read.

Use the flat table mode and name the keys you want as columns. Rows come from the repeated structure those keys share, so a key inside an array produces one row per item of that array.

Because they are different facts. A key that is absent was never recorded; a key set to null was recorded as empty. Reporting both as empty hides which of the two situations your data is in.

Because they are two different values, one a number and one a string. Merging them would conceal exactly the sort of inconsistency that makes code fail later, so they are kept apart.

Yes. Set the mode and keys once, drop in as many files as you like, and each produces its own result. Download them together as a single zip.
Advertisement Slot (Bottom Banner) Google AdSense Unit • Responsive Banner