Nested JSON Flattener
Transform a deeply nested JSON structure into a flattened key-value format where each path is represented by dot notation
Start file
{
"company": {
"details": {
"name": "TechCorp",
"founded": 1995,
"isPublic": true
},
"locations": {
"headquarters": {
"address": {
"street": "123 Innovation Way",
"unit": "4B",
"city": "San Francisco",
"state": "CA",
"zip": "94105"
},
"coordinates": {
"lat": 37.7749,
"lng": -122.4194
}
},
"branches": {
"europe": {
"primary": {
"city": "London",
"employees": 250,
"opened": "2020-01-15"
},
"secondary": {
"city": "Berlin",
"employees": 120,
"opened": "2021-03-01"
}
},
"asia": {
"primary": {
"city": "Tokyo",
"employees": 180,
"opened": "2019-11-30"
}
}
}
},
"metrics": {
"financial": {
"revenue": {
"2021": 1500000,
"2022": 2200000,
"2023": 3100000
},
"expenses": {
"2021": 1200000,
"2022": 1800000,
"2023": 2500000
}
},
"performance": {
"goals": {
"q1": 85,
"q2": 90,
"q3": 88,
"q4": 92
}
}
}
}
}
End file
company.details.name=TechCorp
company.details.founded=1995
company.details.isPublic=true
company.locations.headquarters.address.street=123 Innovation Way
company.locations.headquarters.address.unit=4B
company.locations.headquarters.address.city=San Francisco
company.locations.headquarters.address.state=CA
company.locations.headquarters.address.zip=94105
company.locations.headquarters.coordinates.lat=37.7749
company.locations.headquarters.coordinates.lng=-122.4194
company.locations.branches.europe.primary.city=London
company.locations.branches.europe.primary.employees=250
company.locations.branches.europe.primary.opened=2020-01-15
company.locations.branches.europe.secondary.city=Berlin
company.locations.branches.europe.secondary.employees=120
company.locations.branches.europe.secondary.opened=2021-03-01
company.locations.branches.asia.primary.city=Tokyo
company.locations.branches.asia.primary.employees=180
company.locations.branches.asia.primary.opened=2019-11-30
company.metrics.financial.revenue.2021=1500000
company.metrics.financial.revenue.2022=2200000
company.metrics.financial.revenue.2023=3100000
company.metrics.financial.expenses.2021=1200000
company.metrics.financial.expenses.2022=1800000
company.metrics.financial.expenses.2023=2500000
company.metrics.performance.goals.q1=85
company.metrics.performance.goals.q2=90
company.metrics.performance.goals.q3=88
company.metrics.performance.goals.q4=92
View Diff
1,67c1,29
< {
< "company": {
< "details": {
< "name": "TechCorp",
< "founded": 1995,
< "isPublic": true
< },
< "locations": {
< "headquarters": {
< "address": {
< "street": "123 Innovation Way",
< "unit": "4B",
< "city": "San Francisco",
< "state": "CA",
< "zip": "94105"
< },
< "coordinates": {
< "lat": 37.7749,
< "lng": -122.4194
< }
< },
< "branches": {
< "europe": {
< "primary": {
< "city": "London",
< "employees": 250,
< "opened": "2020-01-15"
< },
< "secondary": {
< "city": "Berlin",
< "employees": 120,
< "opened": "2021-03-01"
< }
< },
< "asia": {
< "primary": {
< "city": "Tokyo",
< "employees": 180,
< "opened": "2019-11-30"
< }
< }
< }
< },
< "metrics": {
< "financial": {
< "revenue": {
< "2021": 1500000,
< "2022": 2200000,
< "2023": 3100000
< },
< "expenses": {
< "2021": 1200000,
< "2022": 1800000,
< "2023": 2500000
< }
< },
< "performance": {
< "goals": {
< "q1": 85,
< "q2": 90,
< "q3": 88,
< "q4": 92
< }
< }
< }
< }
< }
---
> company.details.name=TechCorp
> company.details.founded=1995
> company.details.isPublic=true
> company.locations.headquarters.address.street=123 Innovation Way
> company.locations.headquarters.address.unit=4B
> company.locations.headquarters.address.city=San Francisco
> company.locations.headquarters.address.state=CA
> company.locations.headquarters.address.zip=94105
> company.locations.headquarters.coordinates.lat=37.7749
> company.locations.headquarters.coordinates.lng=-122.4194
> company.locations.branches.europe.primary.city=London
> company.locations.branches.europe.primary.employees=250
> company.locations.branches.europe.primary.opened=2020-01-15
> company.locations.branches.europe.secondary.city=Berlin
> company.locations.branches.europe.secondary.employees=120
> company.locations.branches.europe.secondary.opened=2021-03-01
> company.locations.branches.asia.primary.city=Tokyo
> company.locations.branches.asia.primary.employees=180
> company.locations.branches.asia.primary.opened=2019-11-30
> company.metrics.financial.revenue.2021=1500000
> company.metrics.financial.revenue.2022=2200000
> company.metrics.financial.revenue.2023=3100000
> company.metrics.financial.expenses.2021=1200000
> company.metrics.financial.expenses.2022=1800000
> company.metrics.financial.expenses.2023=2500000
> company.metrics.performance.goals.q1=85
> company.metrics.performance.goals.q2=90
> company.metrics.performance.goals.q3=88
> company.metrics.performance.goals.q4=92
Solutions by @ehre9305:
Unlock 1 remaining solutions by signing in and submitting your own entry