JSON Extractor

Extract nested values, filter fields, and export data from JSON. Use dot-notation paths and key filters to pull exactly what you need, then export as JSON, plain values, or CSV.

Dot-notation path to navigate into nested data

Comma-separated keys to keep from each object

Pull Exactly What You Need from JSON

API responses often carry far more data than you actually need. Use a dot-notation path to navigate to the right part of the JSON, then apply a key filter to keep only the fields you care about. Export the result as clean JSON, a plain values list, or a CSV you can open in a spreadsheet.

Path · Keys · Export

Why use this JSON Extractor tool

Navigate with Dot Notation

Reach any nested value using paths like response.data.users[0].email — no manual counting of brackets or scrolling through large JSON blobs required.

Filter to Specific Keys Only

Strip unwanted fields from every object in an array in one step. Keep only name and email out of a 20-field user object without writing any code.

Export Directly as CSV

Turn a JSON array of objects into a spreadsheet-ready CSV table with headers in one click. Paste it into Excel, Google Sheets, or import it into a database.

Flatten to a Plain Value List

Collapse any JSON structure down to just its scalar values — strings, numbers, booleans — as a clean line-by-line list for quick scanning or bulk copying.

How this JSON Extractor works

Paste your JSON into the input field, then use the path query box to navigate into the data using dot notation — for example, users extracts the users field from the root object, and data.items[0] extracts the first item from a nested items array. Leave the path empty to work with the entire JSON input as-is.

After navigating to the right section, enter a comma-separated key filter to keep only the fields you need from each object — for example, name, email strips every other field from each record in the result. Choose JSON output for formatted structured data, Values for a flat line-by-line list of all scalar values, or CSV to generate a spreadsheet-ready table with headers. The result updates when you click Extract, and a copy button lets you grab it immediately. All processing runs locally in your browser, so your data stays on your device.

How to use this JSON Extractor

1

Paste your JSON

Paste the full JSON object or array you want to work with. Click "Load Sample" to see a quick example.

2

Set your path and key filters

Enter a dot-notation path like users or users[0].email to navigate to a nested value. Add a comma-separated key list to keep only certain fields from each object.

3

Extract and export

Choose JSON, Values, or CSV as output format, click Extract, then copy the result or use it directly.

Example Usage

Extracting and filtering fields from a users array:

Input
JSON with users array, Path: users, Keys: name, email
Output
[{"name":"Alice","email":"[email protected]"}, ...]

Frequently Asked Questions

What can I extract with this tool?
You can extract any nested value, sub-object, or sub-array using a dot-notation path. You can also filter which keys to keep from each object in an array, and export the result as formatted JSON, plain values, or CSV.
How does the path query work?
Use dots to navigate into nested objects and square brackets with an index for arrays. For example, data.users extracts the users field from a data object. data.users[0] extracts the first user. Leave the path empty to work with the entire JSON input.
What does the key filter do?
The key filter takes a comma-separated list of field names and removes every other key from each object in the extracted result. For example, entering name, email will strip all other fields and keep only those two from every object in the result.
Can I extract from a deeply nested structure?
Yes. Dot notation supports any depth. Use paths like response.data.items[0].details.title to reach deeply nested values. If a path segment does not exist, the tool will show an error instead of returning undefined silently.
What is the difference between JSON, Values, and CSV output?
JSON output preserves the full structure with formatting. Values output flattens the result to a plain list of scalar values (strings, numbers, booleans), one per line. CSV output generates a spreadsheet-compatible table with headers when the extracted data is an array of objects.
Can I use this to extract data from an API response?
Yes. Paste the raw API response JSON, use the path to reach the data array or object you care about, apply any key filters to trim fields you do not need, and export in your preferred format.
Does this tool send my JSON to a server?
No. All extraction runs locally in your browser. Your JSON data never leaves your device.
What happens if an object in an array is missing a key I filtered for?
The key is simply omitted from that object in the output. No error is thrown. Objects that do have the key will include it; objects that do not will not include it.
Can I extract a single value like a string or number?
Yes. If the path resolves to a primitive value like a string, number, or boolean, the output shows that value directly. In Values mode it appears as a single line; in JSON mode it is a raw JSON primitive.
Does the CSV export handle special characters and quotes?
Yes. Values containing commas, double quotes, or newlines are properly escaped according to the CSV standard — wrapped in double quotes with internal quotes doubled.

Related Tools

Try It

JSON Formatter

Beautify and validate JSON data.

Try It

JSON Compare

Compare two JSON objects side-by-side and spot differences instantly. Free online JSON diff viewer for developers.

Try It

JSON Analyzer

Analyze JSON structure online. Validate syntax, count keys, objects, arrays, values, depth, and payload size in your browser.

Try It

JSON to Text Converter

Convert JSON data to plain, readable text. Choose readable format, flat key-value pairs, or values-only output.

Try It

CSV to JSON Converter

Convert CSV files or text into valid JSON arrays. Smart parsing with header detection.

Try It

JSON Decode

Decode escaped JSON strings, unescape characters, and format the result.

The JSON Extractor is maintained by CodeItBro. We aim to provide the best free developer tools on the web. If you have feedback or suggestions, please visit our contact page.

Featured On

CodeItBro - Free dev tools + practical guides to help you ship faster | Product HuntCodeItBro - Free Online Developer Tools badgeCodeItBro badge