一键导出微信账单Excel的脚本

用微信账单做月度记账时，手动整理太慢：

import csv, sys

rows, found = [], False
with open(sys.argv[1], "r", encoding="utf-8") as f:
    for line in f:
        s = line.strip()
        if not found:
            if s.startswith("交易时间"):
                found = True
            continue
        p = s.split(",")
        if len(p) >= 11:
            rows.append({
                "日期": p[0], "类型": p[1],
                "对方": p[2], "商品": p[3],
                "金额": p[5].replace("¥", ""),
                "状态": p[8],
            })

with open(sys.argv[2], "w", encoding="utf-8-sig", newline="") as f:
    w = csv.DictWriter(f, fieldnames=rows[0].keys())
    w.writeheader()
    w.writerows(rows)
print(f"已导出 {len(rows)} 条记录")

步骤：

1. 微信 → 我 → 服务 → 钱包 → 账单 → 导出账单
2. `python bill.py 微信支付账单.csv output.csv`
3. Excel 打开 output.csv

导出后检查：记录数与微信显示是否一致，金额符号是否已清除。

▼ 愿你每天披荆斩棘所向披靡

长按识别二维码，关注摸鱼King，每天 8:10 准时摸鱼