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
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.