What problem does it solve?
Provide a single, scene-driven workbench for any task where a spreadsheet file is the primary input or output: opening, reading, cleaning, transforming, analyzing, charting, converting, or generating .xlsx/.xlsm/.csv/.tsv outputs while preserving formulas, styling, and data provenance.
Core Features & Use Cases
- File conversion & ingestion: Convert CSV/TSV/JSON/PDF tables to polished XLSX workbooks and merge multiple tabular sources into one workbook.
- Edit, clean & transform: Data cleaning, merging, pivot creation, structural edits, and formula-safe rewrites while preserving original styles and VBA when required.
- Analysis, charts & QA: Run pandas/openpyxl analysis, insert native Excel charts or embedded matplotlib images, and enforce integrity via recalculation, audit, and scan workflows (recalc → audit → scan → validate).
- Use case: Combine five monthly CSV exports into a single multi-sheet Excel report, add a summary dashboard with KPI cards and charts, and run the QA pipeline to ensure zero formula errors.
Quick Start
Convert the file data.csv into a cleaned Excel workbook with a Summary sheet, pivot tables, and charts, then run the built-in validation and recalc.