Read & write, merge & split, clean & validate, pivot & chart, template fill, encrypt & protect — just describe what you need in natural language. Local execution, zero subscription.
From quick preview to encrypted delivery — 22 tools covering every step of your Excel workflow.
Auto-detect sheet structure, column names, data types, row counts. Know your file before you act.
Combine multiple files into one, or split by sheet or column value. 5 monthly reports → 1 annual summary in seconds.
Cross-table join by any key. Smart dedup keeping the latest record. No more formula errors.
Bar, line, pie, combo charts. Cross-tabulation pivot tables. Statistical summaries. All from natural language.
Batch-generate offer letters, notifications, certificates from data + template. 100 letters in one command.
File-level password protection for sensitive data. Set, modify, or remove passwords. Compatible with Office/WPS/LibreOffice.
Every tool you need, organized by category. Just describe what you want — the skill auto-routes.
| # | Feature | Description | Trigger Example |
|---|---|---|---|
| 1 | 📋 Smart Preview | Sheets, columns, rows, data types | "Show me this Excel" |
| 2 | 📖 Read | Precise read by sheet/column/range | "Read columns A-D from Sheet2" |
| 3 | ✏️ Write & Create | Write data to new Excel file | "Generate an Excel from this data" |
| 4 | 🔄 Format Convert | xlsx ↔ csv ↔ json ↔ tsv | "Convert CSV to xlsx" |
| 5 | 📎 Merge | Combine multiple files/sheets | "Merge these 5 monthly reports" |
| 6 | ✂️ Split | Split by sheet into separate files | "Split by sheet" |
| 7 | ✂️ Split by Column | Split by a column's values | "Split by department" |
| 8 | 🔗 VLOOKUP | Cross-table join | "Join by employee ID" |
| 9 | 🧹 Dedup | Deduplicate by specified columns | "Dedup by name + phone" |
| 10 | 🧽 Data Cleaning | Empty rows, format standardization | "Clean dirty data" |
| 11 | 📄 Template Fill | Batch generate from template | "Batch generate offer letters" |
| 12 | ✅ Validation | Email/ID/phone format check | "Check which emails are invalid" |
| 13 | 🎨 Conditional Format | Auto-color by rules | "Red below 60, green above 90" |
| 14 | 💅 Styling | Header beautification, auto width | "Bold header with background" |
| 15 | 📐 Formulas | Auto-insert Excel formulas | "Add SUM in column E" |
| 16 | 📊 Charts | Bar/line/pie/combo charts | "Generate a sales bar chart" |
| 17 | 📈 Pivot Table | Cross-tabulation analysis | "Summarize sales by dept and month" |
| 18 | 🔬 Data Analysis | Statistical summary: mean/median | "Give me a statistical summary" |
| 19 | 🔍 Diff | Row-by-row file comparison | "Compare two versions of the roster" |
| 20 | 🖼️ Image Insert | Batch insert images to rows | "Insert employee photos" |
| 21 | 🔒 Password Protect | File encrypt/decrypt | "Password-protect the salary table" |
| 22 | ⚡ Large File | 100K+ rows auto-streaming | Auto-triggered |
| Dimension | mu-excel-toolbox | Manual Excel | DIY Python |
|---|---|---|---|
| Merge 10 reports | ✅ 1 command, seconds | 10-30 min copy-paste | Write script each time |
| Split by column | ✅ Auto-split | Filter→Copy→Paste×N | Implement yourself |
| Data cleaning | ✅ 8 rules, one click | Manual find-replace | Debug each rule |
| Large file (100K+) | ✅ Auto-streaming | ❌ Excel freezes | Implement streaming |
| Encoding issues | ✅ Auto-detect | ❌ Manual import | ❌ UnicodeDecodeError |
| Safety backup | ✅ Auto-backup | ❌ Overwrite risk | ❌ Overwrite = gone |
| Barrier to entry | ✅ Natural language | Excel skills needed | Python + libs needed |
| Open Source | ✅ MIT | ❌ N/A | ✅ Your code |
Local execution · Zero subscription · MIT License · 5,636 lines of code · 22 features