Bidirectional converter between Excel (.xlsx/.xlsm) and text-based JSON format with full round-trip support.

Unlike simple text extractors, xlsx2txt preserves everything — formulas, styles, merged cells, VBA macros — and can fully restore the original Excel file.

• 📊 Git-friendly — meaningful diffs for Excel files
• 🔄 Round-trip — xlsx → text → xlsx without data loss
• 👁️ Human-readable — JSON format for easy review
• ✅ Verifiable — built-in integrity checks

pip install xlsx2txt

# Export Excel to text format
xlsx2txt export report.xlsx ./report/

# Edit JSON files or commit to Git
git add report/
git commit -m "Q1 2025 updates"

# Restore Excel file
xlsx2txt import ./report/ report_new.xlsx

# Verify integrity
xlsx2txt verify ./report/

report/
├── manifest.json           # Metadata
├── data/
│   ├── workbook.json       # Workbook properties
│   ├── sheets/
│   │   ├── _index.json
│   │   └── Sheet1.json     # Cells, formulas, dimensions
│   └── styles/
│       ├── fonts.json
│       ├── fills.json
│       └── ...
├── vba/                    # VBA code (for .xlsm)
│   └── modules/*.bas
└── _verify/                # Verification data
    └── checksums.json

BSD 3-Clause License

Copyright (c) 2025, Vladyslav V. Prodan

Inspired by the need for proper Excel version control. Name used with permission from @cloudwu.