JSON Extractor
Paste JSON, set a path to an array or object (e.g. results, data.items[0]). For JSON whose root is an array, use path ., $, or leave Path empty. Comma-separated field paths per row and a column separator. Count and rows are separate outputs below.
Root array: use ., $, or clear the field.
Use the Tab button to insert a tab character into the field.
Nothing to parse.
Instructions
Pulls a flat table out of a nested JSON payload — one line per item, one column per field.
- Paste the JSON payload into the input.
- Set Path to the array you care about (
results,data.items[0]). If the root itself is an array, use.,$, or leave Path empty. - List the Fields you want, comma-separated. Nested fields use dots:
additionalFields.pipelineId. - Pick a Separator — the Tab button inserts a real tab, which is what you want for pasting into a spreadsheet.
- Copy Count for the number of items, or Rows for the table itself.
Tips
- Tick Format JSON to get one JSON object per row instead of separator-joined values.
- Your input, path, fields and separator are kept in this browser, so the page comes back the way you left it.
- A red message under Fields means the JSON did not parse or the path missed — the message says which.
- Hit Example: the Load example link fills a sample payload, and Format JSON loads the same payload with a nested field and JSON output.