# jsoncsv | alingse | Knowledge Base | Instagit a command tool easily convert json file to csv or xlsx wiki https://deepwiki.com/alingse/jsoncsv GitHub Stars: 100 Repository: https://github.com/alingse/jsoncsv --- ## Articles ### [Loading Headers in jsoncsv Dumps: Methods and Source Code Analysis](/alingse/jsoncsv/what-methods-are-used-for-loading-headers-in-jsoncsv-dumps) Discover how alingse/jsoncsv loads headers automatically using ReadHeadersMixin.load_headers. Learn the source code analysis for efficient JSON to CSV and Excel conversion. - Tags: internals - Published: 2026-02-24 ### [How jsoncsv Handles Type Detection for Restoring Arrays: A Deep Dive into the Source Code](/alingse/jsoncsv/how-does-jsoncsv-handle-type-detection-for-restoring-arrays) Discover how alingse/jsoncsv detects arrays by identifying sibling keys with sequential 0-based integer indices. Explore the source code for restoring nested JSON from flat data. - Tags: deep-dive - Published: 2026-02-24 ### [What Is the Purpose of utils.py in jsoncsv? Type Safety and Safe Key Encoding](/alingse/jsoncsv/what-is-the-purpose-of-utils.py-in-jsoncsv) Discover the purpose of utils.py in jsoncsv. Learn how it defines JSON type aliases and implements key encoding for safe nested object flattening and type safety. - Tags: internals - Published: 2026-02-24 ### [How jsoncsv Handles Empty Dicts and Lists During Excel Export](/alingse/jsoncsv/how-does-jsoncsv-handle-empty-dicts-and-lists-during-excel-export) Learn how jsoncsv manages empty dicts and lists in Excel exports. Discover the differences between DumpCSV and DumpXLS for blank cell representation. - Tags: how-to-guide - Published: 2026-02-24 ### [How the restore Function in jsontool.py Reconstructs JSON Objects](/alingse/jsoncsv/how-does-the-restore-function-in-jsontool.py-reconstruct-json) Uncover how the restore function in jsontool.py reconstructs JSON objects by reversing flattening, parsing dot-notated keys, and rebuilding nested structures. - Tags: deep-dive - Published: 2026-02-24 ### [How the jsontool.py Module Works in jsoncsv: Flattening and Restoring Nested JSON](/alingse/jsoncsv/how-does-the-jsontool.py-module-work-in-jsoncsv) Discover how jsontool.py in jsoncsv flattens nested JSON to dot notation and restores it. Understand the core transformation logic for efficient data handling. - Tags: internals - Published: 2026-02-24 ### [CLI Entry Point for jsoncsv: How the Command-Line Interface Works](/alingse/jsoncsv/where-is-the-cli-entry-point-for-jsoncsv) Discover the CLI entry point for jsoncsv in jsoncsv/main.py. Learn how the command-line interface works and how it's registered via pyproject.toml for easy execution. - Tags: internals - Published: 2026-02-24 ### [Architecture of the jsoncsv Python Tool: A 4-Layer Deep Dive](/alingse/jsoncsv/what-is-the-architecture-of-the-jsoncsv-python-tool) Explore the modular four-layer architecture of the jsoncsv Python tool. Understand its CLI dispatcher, JSON processor, dump engine, and utility layer for efficient data conversion. - Tags: architecture - Published: 2026-02-24 ### [How to Use Pre‑Read Rows for Header Detection in jsoncsv](/alingse/jsoncsv/how-to-use-pre-read-rows-for-header-detection-in-jsoncsv) Learn to use pre-read rows for header detection in jsoncsv with the -r option or Python API. Efficiently map JSON data to CSV/XLS columns. - Tags: how-to-guide - Published: 2026-02-24 ### [How jsoncsv Automatically Detects CSV Headers from JSON Data](/alingse/jsoncsv/how-does-jsoncsv-detect-headers-automatically) Discover how jsoncsv automatically detects CSV headers by scanning JSON data for unique keys, creating a sorted header row for seamless conversion. Convert your JSON to CSV effortlessly. - Tags: internals - Published: 2026-02-24 ### [What is the Safe Mode in jsoncsv for Escaping Characters?](/alingse/jsoncsv/what-is-the-safe-mode-in-jsoncsv-for-escaping-characters) Discover jsoncsv's safe mode for escaping characters. Prevent ambiguous flattening and ensure lossless JSON to CSV round-trip conversion. Learn how it works. - Tags: deep-dive - Published: 2026-02-24 ### [How to Use Custom Separators in jsoncsv: CLI and Python API Guide](/alingse/jsoncsv/how-to-use-custom-separators-in-jsoncsv) Learn to use custom separators in jsoncsv with our guide. Easily change delimiters in the CLI or Python API for flexible JSON data handling. - Tags: how-to-guide - Published: 2026-02-24 ### [What Is Dot Notation in jsoncsv Keys?](/alingse/jsoncsv/what-is-dot-notation-in-jsoncsv-keys) Understand dot notation in jsoncsv keys for flattening nested JSON into CSV. Learn how jsoncsv uses dot notation to represent hierarchical data structures simply. - Tags: api-reference - Published: 2026-02-24 ### [How jsoncsv Handles Line-Delimited JSON: Stream Processing Explained](/alingse/jsoncsv/how-does-jsoncsv-handle-line-delimited-json) Discover how jsoncsv handles line-delimited JSON using efficient stream processing. Learn to parse independent JSON objects with minimal memory. - Tags: internals - Published: 2026-02-24 ### [jsoncsv Commands: Expand, Restore, and Convert JSON from the Command Line](/alingse/jsoncsv/what-are-the-main-commands-in-jsoncsv) Master jsoncsv commands to expand, restore, and convert JSON to CSV or Excel directly from your command line. Effortlessly manage nested JSON structures with this powerful Python utility. - Tags: tutorial - Published: 2026-02-24 ### [How to Convert JSON to XLSX Using Python with the jsoncsv Library](/alingse/jsoncsv/how-to-convert-json-to-xlsx-using-python) Convert JSON to XLSX effortlessly using Python and the jsoncsv library. Flatten nested data and export directly to Excel format with this powerful tool. - Tags: how-to-guide - Published: 2026-02-24 ### [How to Convert JSON to CSV Using Python CLI with jsoncsv](/alingse/jsoncsv/how-to-convert-json-to-csv-using-python-cli) Convert JSON to CSV easily using the Python jsoncsv CLI tool. This package offers a stream-based solution to flatten and export your JSON data to CSV or XLS format efficiently. - Tags: how-to-guide - Published: 2026-02-24