Flatten JSON
Turn nested JSON into a flat object, with dot-notation keys such as user.name or user.roles[0].
How it works
Need to import nested JSON into a spreadsheet or a tabular database, or just quickly spot every key path in a complex structure? Flattening turns each final value (string, number, boolean) into a single key/value pair, where the key describes the full path from the root: objects use a dot (user.name) and arrays use square brackets (roles[0]).
What happens to empty arrays and objects?
An empty array or object is kept as is in the result ([] or {}) under its path key, since it has no final value to extract.
Is this operation reversible?
Yes, use the "Unflatten JSON" tool with the result obtained here to rebuild the original nested structure.
100% local processing: flattening runs entirely in your browser via WebAssembly — your JSON data never leaves your device.