json-normalize
Recursively flattens a JSON-like structure into a list of flat dicts.
Decision gist · record as of 2026-08-14
Yes, if you need to flatten nested JSON into flat dicts. The package is stable, dependency-free, and permissively licensed. Dormant maintenance is acceptable for a focused utility with no known vulnerabilities, but verify it handles your specific nesting patterns (especially multiple list branches) before committing to production use.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Low friction: pure Python wheel with no runtime dependencies.
- Maintenance is dormant (last commit 2024-09-25, 869 days since release), but the package is marked Production/Stable and has received no security reports.
License · maintenance · safety
MIT (permissive) — MIT license permits unrestricted use, modification, and distribution with minimal attribution requirements—suitable for any project type.
last release 2024-03-28 (869 days) · last repo commit 2024-09-25 · 28 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 80,227 downloads/mo, #14,305 on PyPI
Alternatives
Verify before relying
from json_normalize import json_normalize
json_like = {"city": "Stockholm", "coords": {"lat": 59.331924, "long": 18.062297}}
result = list(json_normalize(json_like))
# Output: [{'city': 'Stockholm', 'coords.lat': 59.331924, 'coords.long': 18.062297}]- Whether dormant maintenance status (869 days since last release) poses a risk for future Python or dependency ecosystem changes
- Performance characteristics on deeply nested or very large JSON structures
What it is and what it does
json_normalize takes a nested JSON-like structure—dicts, lists, generators, and other iterables—and flattens it into a sequence of flat dictionaries. Each key in the output is a dot-joined path from the root to a leaf value. The package handles the tricky case of data association: when nested dicts share a common dict ancestor, their data flows together into the same output records; when they share a list ancestor, they remain separate. When multiple independent lists exist in different branches, you can choose how to combine them: chain them sequentially, compute their Cartesian product, or drop problematic branches entirely.
The function is configurable: you can customize the path joiner (dot, arrow, or a callable), freeze certain nodes to prevent recursive normalization below them, drop nodes by name, and control list combination behavior. It accepts generators and lazy iterables as input, making it useful for streaming or memory-constrained scenarios.
Use it for
- Convert API responses with nested objects and arrays into flat rows suitable for CSV export or database insertion
- Flatten configuration files or metadata structures to extract all leaf values with their full paths
- Denormalize time-series data where measurements contain nested sensor readings and metadata
- Transform hierarchical log entries or event objects into tabular format for analysis
- Prepare nested JSON for pandas DataFrame construction by generating flat dict records
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need to flatten nested JSON into flat dicts.
The package is stable, dependency-free, and permissively licensed. Dormant maintenance is acceptable for a focused utility with no known vulnerabilities, but verify it handles your specific nesting patterns (especially multiple list branches) before committing to production use.
Install
json-normalize on PyPI
Before you install
Low friction: pure Python wheel with no runtime dependencies. Maintenance is dormant (last commit 2024-09-25, 869 days since release), but the package is marked Production/Stable and has received no security reports.
License in practice
MIT license permits unrestricted use, modification, and distribution with minimal attribution requirements—suitable for any project type.
Quickstart
from json_normalize import json_normalize
json_like = {"city": "Stockholm", "coords": {"lat": 59.331924, "long": 18.062297}}
result = list(json_normalize(json_like))
# Output: [{'city': 'Stockholm', 'coords.lat': 59.331924, 'coords.long': 18.062297}]Verify before relying
- Whether dormant maintenance status (869 days since last release) poses a risk for future Python or dependency ecosystem changes
- Performance characteristics on deeply nested or very large JSON structures
Package facts
| License | MIT permissive |
| Python support | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | None |
| Maintenance | Dormant 869 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 80,227 / month, #14,305 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableLicense :: OSI Approved :: MIT LicenseProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Topic :: Software Development :: Libraries |
Evidence: json_normalize-1.1.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “json to flat dict”
- json-normalizeRecursively flattens nested JSON-like structures (dicts and…
- flatten-dictConverts nested dictionaries into flat key-value pairs and back, with…
- flatdictFlattens nested dictionaries into single-level dicts with delimited…
Give your agent the search over MCP, or paste the wish link into any chat.
More Libraries packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Provides parsing, arithmetic, and recurrence rule computation for dates and times, with timezone support and iCalendar RFC compliance.
Install it if you need to parse flexible date strings, compute relative dates, handle timezones, or work with recurrence rules—it's the de facto choice for these tasks.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
See also flatdict · mo-dots · dm-tree · flatten-json · dict-recursive-update · json-flatten · lmz · flatten-dict · awkward · databind