JSON数据扁平化工具：嵌套结构一键展开为表格、自定义路径分隔符、字段筛选过滤、导出CSV

🖥️ 运行效果

🚀 实例简介

一款实用的JSON数据扁平化桌面工具，可将深层嵌套的JSON数据一键展开为扁平表格形式。支持自定义路径分隔符、字段关键词过滤、数组自动索引展开，以及一键导出CSV文件。特别适合API接口调试、配置文件分析、数据迁移等场景。

💻 核心代码

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
JSON数据扁平化工具
功能：将嵌套JSON一键展开为表格、自定义分隔符、字段筛选、导出CSV
"""
import tkinter as tk
from tkinter import ttk, filedialog, messagebox
import json
import csv
import platform

CHINESE_FONT = "WenQuanYi Zen Hei" if platform.system() == "Linux" else "Microsoft YaHei"

def flatten_json(data, sep=".", prefix=""):
    """递归扁平化嵌套JSON，支持dict和list"""
    items = {}
    if isinstance(data, dict):
        for k, v in data.items():
            new_key = f"{prefix}{sep}{k}" if prefix else k
            if isinstance(v, (dict, list)):
                items.update(flatten_json(v, sep, new_key))
            else:
                items[new_key] = v
    elif isinstance(data, list):
        for i, v in enumerate(data):
            new_key = f"{prefix}{sep}{i}" if prefix else str(i)
            if isinstance(v, (dict, list)):
                items.update(flatten_json(v, sep, new_key))
            else:
                items[new_key] = v
    return items

class App(tk.Tk):
    def __init__(self):
        super().__init__()
        self.title("JSON数据扁平化工具")
        self.geometry("900x620")
        self.configure(bg="#f5f5f5")
        self.result_rows = []
        self._build_ui()

    def _build_ui(self):
        # 顶部控制区
        ctrl = tk.Frame(self, bg="#f5f5f5", padx=10, pady=8)
        ctrl.pack(fill=tk.X)

        tk.Label(ctrl, text="分隔符:", font=(CHINESE_FONT, 11), bg="#f5f5f5").pack(side=tk.LEFT)
        self.sep_var = tk.StringVar(value=".")
        tk.Entry(ctrl, textvariable=self.sep_var, width=4, font=(CHINESE_FONT, 11)).pack(side=tk.LEFT, padx=5)

        tk.Label(ctrl, text="字段过滤:", font=(CHINESE_FONT, 11), bg="#f5f5f5").pack(side=tk.LEFT, padx=(15, 0))
        self.filter_var = tk.StringVar()
        tk.Entry(ctrl, textvariable=self.filter_var, width=18, font=(CHINESE_FONT, 11)).pack(side=tk.LEFT, padx=5)

        tk.Button(ctrl, text="加载JSON", font=(CHINESE_FONT, 11), bg="#4CAF50", fg="white",
                  command=self.load_json).pack(side=tk.LEFT, padx=5)
        tk.Button(ctrl, text="扁平化", font=(CHINESE_FONT, 11), bg="#2196F3", fg="white",
                  command=self.do_flatten).pack(side=tk.LEFT, padx=5)
        tk.Button(ctrl, text="导出CSV", font=(CHINESE_FONT, 11), bg="#FF9800", fg="white",
                  command=self.export_csv).pack(side=tk.LEFT, padx=5)

        # 左右分栏
        paned = tk.PanedWindow(self, orient=tk.HORIZONTAL, bg="#f5f5f5")
        paned.pack(fill=tk.BOTH, expand=True, padx=10, pady=5)

        # 左侧：原始JSON
        left = tk.Frame(paned, bg="#f5f5f5")
        tk.Label(left, text="📄 原始JSON", font=(CHINESE_FONT, 11, "bold"), bg="#f5f5f5").pack(anchor=tk.W)
        self.json_text = tk.Text(left, font=("Consolas", 10), bg="white", wrap=tk.NONE)
        self.json_text.pack(fill=tk.BOTH, expand=True)

        # 右侧：扁平化表格
        right = tk.Frame(paned, bg="#f5f5f5")
        tk.Label(right, text="📊 扁平化结果", font=(CHINESE_FONT, 11, "bold"), bg="#f5f5f5").pack(anchor=tk.W)
        cols = ("字段路径", "值")
        self.tree = ttk.Treeview(right, columns=cols, show="headings", height=18)
        self.tree.heading("字段路径", text="字段路径")
        self.tree.heading("值", text="值")
        self.tree.column("字段路径", width=300)

💡 适用场景

办公自动化、数据分析、快速原型开发