JSON Flattener

The JSON Flattener collapses deeply nested objects and arrays into a single flat object whose keys are dot-notation paths like user.address.city. Flattened JSON is far easier to feed into spreadsheets, environment variables, and key-value stores, and it makes comparing structures trivial. Array indices are preserved in the path so nothing is lost.

• Collapses arbitrarily deep objects into dot-notation key paths
• Encodes array indices in the path, for example items.0.sku
• Choose your delimiter, such as a dot, slash, or underscore
• Preserves every leaf value with its original type
• Ideal input for CSV export, config maps, and flat key-value stores
• Round-trips with the JSON Unflattener to rebuild the original

1. 1

   Paste nested JSON

   Add the object or array with the nested structure you want to flatten.

2. 2

   Choose a delimiter

   Keep the default dot or pick a custom separator for the generated key paths.

3. 3

   Flatten

   The tool produces a single-level object mapping each path to its leaf value.

4. 4

   Export the result

   Copy the flat map for spreadsheets, env files, or comparisons.

• Preparing nested JSON for import into a spreadsheet as columns
• Turning a config object into flat environment-variable-style keys
• Making structural differences obvious by comparing flat key lists
• Loading JSON into a key-value store that expects flat keys
• Building translation files where each string has a dotted path