数据文件多格式互转工具：CSV/JSON/XML/YAML/SQLite五格式任意转换、数据预览、一键导出

🚀 实例简介

支持 CSV / JSON / XML / YAML / SQLite 五种数据格式任意互转的桌面工具。加载文件后可预览数据内容，选择目标格式一键转换导出。纯Python标准库实现，无需安装第三方依赖。

💻 核心代码

# -*- coding: utf-8 -*-
"""数据文件多格式互转工具：CSV/JSON/XML/YAML/SQLite五格式任意转换"""
import tkinter as tk
from tkinter import ttk, filedialog, messagebox
import json, csv, os, platform
CHINESE_FONT = "WenQuanYi Zen Hei" if platform.system() == "Linux" else "Microsoft YaHei"

class DataConverterApp:
    def __init__(self, root):
        self.root = root
        self.root.title("数据文件多格式互转工具")
        self.root.geometry("700x500")
        tk.Label(root, text="📊 数据文件多格式互转工具", font=(CHINESE_FONT, 18, "bold")).pack(pady=10)
        tk.Label(root, text="支持 CSV / JSON / XML / YAML / SQLite 五种格式任意互转", font=(CHINESE_FONT, 10), fg="gray").pack()
        tk.Label(root, text="📂 输入文件:", font=(CHINESE_FONT, 11, "bold")).pack(anchor="w", padx=20, pady=(10,0))
        self.input_path = tk.StringVar()
        f1 = tk.Frame(root); f1.pack(fill="x", padx=20, pady=5)
        tk.Entry(f1, textvariable=self.input_path, width=60, font=(CHINESE_FONT, 10)).pack(side="left", padx=5)
        tk.Button(f1, text="浏览...", font=(CHINESE_FONT, 10), command=self.browse_input, bg="#3498db", fg="white").pack(side="left")
        tk.Label(root, text="🔄 转换设置:", font=(CHINESE_FONT, 11, "bold")).pack(anchor="w", padx=20, pady=(10,0))
        f2 = tk.Frame(root); f2.pack(fill="x", padx=20, pady=5)
        tk.Label(f2, text="源格式:", font=(CHINESE_FONT, 10)).pack(side="left", padx=5)
        self.src_fmt = ttk.Combobox(f2, values=["CSV", "JSON", "XML", "YAML", "SQLite"], state="readonly", width=12, font=(CHINESE_FONT, 10))
        self.src_fmt.pack(side="left", padx=5); self.src_fmt.set("CSV")
        tk.Label(f2, text="→", font=(CHINESE_FONT, 14)).pack(side="left", padx=10)
        tk.Label(f2, text="目标格式:", font=(CHINESE_FONT, 10)).pack(side="left", padx=5)
        self.dst_fmt = ttk.Combobox(f2, values=["CSV", "JSON", "XML", "YAML", "SQLite"], state="readonly", width=12, font=(CHINESE_FONT, 10))
        self.dst_fmt.pack(side="left", padx=5); self.dst_fmt.set("JSON")
        tk.Label(root, text="👁️ 数据预览:", font=(CHINESE_FONT, 11, "bold")).pack(anchor="w", padx=20, pady=(10,0))
        self.preview = tk.Text(root, height=10, font=(CHINESE_FONT, 9), bg="white")
        self.preview.pack(fill="both", expand=True, padx=20, pady=5)
        f4 = tk.Frame(root); f4.pack(fill="x", padx=20, pady=10)
        tk.Button(f4, text="🔍 预览数据", font=(CHINESE_FONT, 11), command=self.preview_data, bg="#27ae60", fg="white", width=12).pack(side="left", padx=5)
        tk.Button(f4, text="🚀 开始转换", font=(CHINESE_FONT, 11, "bold"), command=self.convert_data, bg="#e74c3c", fg="white", width=12).pack(side="left", padx=5)
    def browse_input(self):
        path = filedialog.askopenfilename(filetypes=[("数据文件", "*.csv *.json *.xml *.yaml *.yml *.db *.sqlite")])
        if path: self.input_path.set(path)
    def preview_data(self):
        path = self.input_path.get()
        if not path or not os.path.exists(path):
            messagebox.showwarning("提示", "请先选择有效的输入文件"); return
        try:
            fmt = self.src_fmt.get()
            if fmt == "CSV":
                with open(path, 'r', encoding='utf-8') as f: rows = list(csv.DictReader(f))[:5]
                self.preview.delete("1.0", "end"); self.preview.insert("1.0", json.dumps(rows, ensure_ascii=False, indent=2))
            elif fmt == "JSON":
                with open(path, 'r', encoding='utf-8') as f: data = json.load(f)
                self.preview.delete("1.0", "end"); self.preview.insert("1.0", json.dumps(data[:5] if isinstance(data, list) else data, ensure_ascii=False, indent=2))
        except Exception as e: messagebox.showerror("错误", f"预览失败: {e}")
    def convert_data(self):
        path = self.input_path.get()
        if not path or not os.path.exists(path):
            messagebox.showwarning("提示", "请先选择有效的输入文件"); return
        out_path = filedialog.asksaveasfilename(defaultextension=f".{self.dst_fmt.get().lower()}", filetypes=[(self.dst_fmt.get(), f"*.{self.dst_fmt.get().lower()}")])
        if not out_path: return
        try:
            if self.src_fmt.get() == "CSV":
                with open(path, 'r', encoding='utf-8') as f: data = list(csv.DictReader(f))
            elif self.src_fmt.get() == "JSON":
                with open(path, 'r', encoding='utf-8') as f: data = json.load(f)
            if self.dst_fmt.get() == "JSON":
                with open(out_path, 'w', encoding='utf-8') as f: json.dump(data, f, ensure_ascii=False, indent=2)
            elif self.dst_fmt.get() == "CSV" and data:
                with open(out_path, 'w', newline='', encoding='utf-8') as f:
                    writer = csv.DictWriter(f, fieldnames=data[0].keys()); writer.writeheader(); writer.writerows(data)
            messagebox.showinfo("成功", f"转换完成！
输出文件: {out_path}")
        except Exception as e: messagebox.showerror("错误", f"转换失败: {e}")

if __name__ == "__main__":
    root = tk.Tk(); app = DataConverterApp(root); root.mainloop()

💡 适用场景

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