Automating Boring Excel Tasks

Merge 100 files, rename sheets, format dozens of workbooks, send personalised emails — set it once and walk away.

Toolkit 7 lessons ~70 min

Lessons in this module

1. Merging many files into one · 9 min
   The everyday 'I have a folder of monthly reports' job.
2. Splitting one file into many · 7 min
   Group by a column and save one workbook per group.
3. Filling a template workbook · 8 min
   Open a pre-formatted .xlsx, drop data into specific cells, save with a new name.
4. Renaming and organising files in bulk · 6 min
   pathlib.rename, glob, regex — your weekend file-cleanup script.
5. Sending emails from Python · 8 min
   smtplib for the standard library way; better libraries for Gmail/Outlook.
6. Scheduling: run it automatically · 7 min
   Make a script run on its own — cron (Mac/Linux), Task Scheduler (Windows), or a Python scheduler library.
7. An automation recipe book · 10 min
   Eight common boring-Excel jobs and the 20-line scripts that automate them.