How to use
- Paste JSON, or use Open file to load a .json file. You can also drag a file onto the input box.
- Pick a tab: Extract text pulls out every value, Extract by key pulls specific keys, Format & validate pretty-prints and finds errors, and To CSV builds a spreadsheet table.
- Copy or Download the result. CSV files open correctly in Excel, including non-English text.
Good to know
Extract text collects every string value in document order, one per line — handy for reviewing translation files, chat logs or API responses, or for running a character count.
In Extract by key, a plain name like name matches that key at any depth, while a dotted path like author.city finds only values nested in that structure (city inside author), walking through arrays along the way.
To CSV finds an array of objects and turns it into a table. Keys from every item become columns, nested values are flattened into columns like address.city, and the file is saved with a UTF-8 BOM so Excel displays it correctly.
FAQ
Is my JSON uploaded?
No. Everything runs in your browser and your data never leaves your device.
How do I find a JSON syntax error?
The Format & validate tab shows the line and column of the error. Common mistakes are trailing commas, single quotes and unquoted keys — JSON only allows double quotes.
How large a file can I use?
Files up to tens of megabytes work on most computers. Very large files depend on your browser’s memory.
Updated: