Bidirectional JSON Converter - Nested ⇄ Flattened Excel Format

Bidirectional JSON Converter - Auto-detects format and converts between nested JSON and flat Excel format

πŸ”„ What does this tool do?

This tool automatically detects your input format and converts it:

  • Nested JSON β†’ Flattened Excel: Converts complex nested objects into a simple key-value spreadsheet
  • Flattened Array β†’ Nested JSON: Reconstructs nested structure from flat Key/Value array format

Use Cases:

  • Analyze API responses with nested data structures
  • Convert i18n/localization files between formats
  • Transform configuration files for easy viewing
  • Share JSON data with non-technical team members
  • Rebuild nested JSON from Excel exports

πŸ“‹ Examples - Works Both Ways!

Direction 1️⃣: Nested JSON β†’ Flattened Excel

Input (Nested JSON):

{
  "user": {
    "name": "John Doe",
    "email": "john@example.com",
    "address": {
      "street": "123 Main St",
      "city": "New York"
    }
  },
  "active": true
}

Output (Excel + JSON):

Key Value
user.nameJohn Doe
user.emailjohn@example.com
user.address.street123 Main St
user.address.cityNew York
activetrue

βœ“ Nested objects flattened using dot notation

Direction 2️⃣: Flattened Array β†’ Nested JSON

Input (Flattened Array):

[
  {
    "Key": "common.agree",
    "Value": "εŒζ„"
  },
  {
    "Key": "common.continue",
    "Value": "繼續"
  },
  {
    "Key": "common.skip",
    "Value": "η•₯過"
  },
  {
    "Key": "settings.language",
    "Value": "繁體中文"
  }
]

Output (Nested JSON):

{
  "common": {
    "agree": "εŒζ„",
    "continue": "繼續",
    "skip": "η•₯過"
  },
  "settings": {
    "language": "繁體中文"
  }
}

βœ“ Automatically reconstructs nested structure
βœ“ Perfect for i18n files!

Paste Your JSON Here:


πŸ’‘ The tool will auto-detect your format and convert accordingly. Excel file will download automatically.