Updated · Built and checked by the PlinzoTools team, formulas tested against published sources
Extract a specific key's values from an array of JSON objects.
Extracted values will appear here.
Given a JSON array of objects, this tool extracts just the values of one specific key across every object -- useful for quickly pulling e.g. every "email" or "id" out of a larger JSON dataset without writing a script.
Paste your JSON array and enter the key name to extract. The extracted values appear instantly as a JSON array.
You supply a JSON array and one key name. The tool parses the array, keeps only the elements that are objects and that actually contain the key, and returns the value stored under that key for each one, formatted as a pretty-printed JSON array with two-space indentation. The order of the output matches the order of the input. Nothing is sorted, deduplicated, or type-converted; a number stays a number, a string stays a string, and a nested object or array is returned whole.
Take this made-up array of users: an object with name Alice and email a@example.com, an object with name Bob and no email at all, and an object with name Cara and email c@example.com. Extracting the key email returns an array with two strings: a@example.com and c@example.com. Bob contributes nothing, because his object does not contain the key. Note that this means the output can be shorter than the input, so you cannot assume that position 3 in the output corresponds to the third original record.
If a key exists but its value is null, the entry is kept and appears as null in the output. There is a difference between a missing key, which is skipped, and a key that is present with an empty or null value, which is included.
Developers often need a quick list of identifiers from an API response to feed into another request, or a column of values to paste into a spreadsheet or a database query. Analysts use it to check what distinct-looking values a field holds before cleaning data. Support and operations staff can pull every email address, order ID, or SKU out of a JSON export without writing code. Because the result is again valid JSON, you can pass it into the JSON to CSV converter available on this site if you want a single-column spreadsheet. Since processing happens locally in your browser, records you paste are not sent to a server, though you should still avoid pasting live credentials or highly sensitive personal data into any web tool as a general habit.
Those entries are skipped in the output -- only objects that actually contain the specified key contribute a value.
No. Only keys directly on each top-level object are matched. Copy the inner array out first, or extract the parent key and run the tool a second time on that result.
Yes. The key must match exactly, including capitalization, so Name and name are treated as different keys.
The entry is included as long as the key exists. Only objects that lack the key entirely are skipped, so null and empty strings show up in the output.
The input either is not valid JSON or is not an array at the top level. Check for trailing commas and single quotes, and make sure the text starts with an opening square bracket.