excel-analyst-cn · zhaoheng588-tech/ai-skills-collection
Clean up, total and merge Excel spreadsheets
Reads Excel workbooks, calculates sums, averages, and totals for chosen columns, builds formatted reports, and merges multiple files while deduplicating repeated headers. Useful for turning scattered spreadsheet exports into a single reviewable report without manual formulas.
Good for
- Merge multiple Excel files into one
- Calculate column totals and averages
- Generate a formatted report with subtotals
- Source repository
- zhaoheng588-tech/ai-skills-collection
- Category
- Office
Open-source skills are maintained by their authors and listed as published, with attribution. Results depend on how well the skill fits your task and material.
A good place to start
Merge these five monthly sales spreadsheets into one file, remove duplicate headers, and add column totals.

Make your next great thing.
Bring a question, a file, or an idea that’s not quite there yet.