All Tools
Categories
XML Tools 64 Email Marketing Tools 55 Import-Export Tools 50 JSON Tools 36 Text Tools 12 Shipping Freight Tools 5 Calculator 4 Marketing Tools 3
About Contact Privacy

Extract JSON Values

Extract values from JSON by key name or dot path — every occurrence, anywhere in the tree. Output as a list, JSON array or CSV, with unique and source-path options.

JSON Input
Waiting for input
Values
Key-anywhere collects every occurrence of the field name at any depth; exact path targets one location. Leave the target empty to inventory all leaf values.

About Extract JSON Values

The information you need from a JSON document is rarely the whole document. You want the customer's email, the status of every order, the regions covered by a report — values scattered across dozens of nested objects and array elements. Opening the file and copying them out one by one is slow, error-prone, and loses the connection between each value and where it lived.

Extract JSON Values harvests them all at once. Give it a field name and it walks the entire tree, returning the value of every matching key at any depth — or give it a precise dot path to target one location. No target at all collects every primitive value, giving an instant inventory of the payload. Unique mode collapses repeats for clean answers to questions like which statuses or regions exist; source paths show exactly where each value came from. Output lands as a list, JSON array or CSV, ready for scripts, spreadsheets and documentation.

Features

  • Key-anywhere mode: Collect the value of every occurrence of a field name at any depth — customer.email, settings.email, all of them.
  • Dot-path mode: Target one precise location like settings.limits.max_items and return exactly those values.
  • Leaf-values mode: Leave the target empty to inventory every string, number and boolean in the document.
  • Unique toggle: Collapse repeats for instant answers to which-statuses and which-regions questions.
  • Source paths: See where each value came from — shown as a prefix or a CSV column.
  • Three output formats: One per line, JSON array, or CSV for spreadsheets.
  • Live counts: Occurrences and distinct values reported as you edit.
  • Copy and download: Export the result in one click.
  • Private: Everything runs client-side; nothing is uploaded.

How to Use

  1. Paste your JSON into the input pane.
  2. Enter the target — a field name like email, a dot path like order.items.sku, or leave it empty for all leaf values.
  3. Choose key or path matching depending on whether you want every occurrence or one location.
  4. Set the options: unique, source paths, and the output format.
  5. Copy or download the harvested values.

Examples

Example 1 — Compliance audit of a log export. A security team needs every email address that appears in a week of API logs. Target key email, unique on, CSV with source paths: the audit trail of addresses and the exact payloads they came from is generated in seconds.

Example 2 — Which regions does our fleet cover? A transport company's report JSON nests region inside every vehicle record. Key mode with unique on collapses the answer to a short list — eu-west, us-east, ap-south — instead of scanning hundreds of lines.

Example 3 — Extracting IDs for a batch script. An order archive needs every order.id. Path mode with order.id collects them in order; output as a JSON array drops straight into the batch-processing script.

Example 4 — Inventorying hard-coded values. A config dump from an embedded device: leaf mode reveals all primitive values in one list, making hard-coded credentials or thresholds visible without reading the whole file.

Benefits

  • Harvest fields without hunting: One key name returns every occurrence at any depth.
  • Answers, not raw data: Unique mode turns repeated values into clean facts — the regions, the statuses, the emails.
  • Traceable results: Source paths keep the connection between value and location.
  • Script-ready output: JSON arrays and CSV feed directly into automation and spreadsheets.
  • Safe and private: Client-side extraction means sensitive payloads never leave the browser.

Frequently Asked Questions

How do I extract every value of a specific field?
Type the field name into the target box — for example email — and the tool walks the entire document, collecting the value of every email key it finds, at any depth, in array elements or nested objects alike. Occurrence count and source paths are reported, so you know both the answers and where each one came from.
What is the difference between key mode and path mode?
Key mode matches the field name anywhere in the tree: email finds customer.email, settings.email and notifications.email at once. Path mode matches a specific dot path like settings.limits.max_items and returns the values at exactly that location. Use key mode to harvest, path mode to target.
What does leaf-values mode do?
With no target entered, the tool collects every primitive value in the document — all strings, numbers and booleans — in document order. This gives an instant inventory of the data the payload actually carries, which is useful for sampling and for spotting hard-coded values in logs or configs.
How do I get unique values?
Enable the unique toggle and repeated values collapse into a single entry. This is the quickest way to answer questions like what regions exist in the data or which statuses appear — without deduplicating by hand.
Which output formats are available?
One per line for scanning, a JSON array for passing into scripts, and CSV for spreadsheets. The source-paths option adds a second column in CSV or a path prefix in list mode, showing exactly where each value came from.
Is my JSON uploaded anywhere?
No. All extraction happens in your browser. Nothing is uploaded, stored or logged.