Python automation: files, spreadsheets and the web
11 steps · about 8 h 5 min · Beginner
- Automate the Boring Stuff with Python (guide, Al Sweigart, 1 h)
Start with the author's free book. Skim the table of contents and read the early chapters to learn the basics and see what automation covers.
- Al Sweigart - Automate the Boring Stuff with Python - YouTube (video, Al Sweigart (YouTube), 2 h)
Watch the author's own free video lessons alongside the book if you learn better by watching code being written.
- Scripting & Automation With Python and AI (guide, Real Python, 20 min)
This gives you a map of the tools used in automation (pathlib, shutil, requests, openpyxl and more) before you go deep on each.
- File and Folder Automation Cheat Sheet (reference, Real Python, 25 min)
Your first real scripts work on files: build paths, glob, copy, move, rename and zip with pathlib and shutil.
- csv — CSV file reading and writing (doc, Python documentation, 25 min)
CSV is the simplest spreadsheet format, so use it to practise reading and writing tabular data before moving to Excel files.
- A Guide to Excel Spreadsheets in Python With openpyxl (tutorial, Real Python, 45 min)
Once you can handle CSVs, learn to read, edit and create real .xlsx workbooks, including formatting and charts.
- Beautiful Soup: Build a Web Scraper With Python (tutorial, Real Python, 45 min)
It teaches the fetch-parse-extract loop of web scraping on a practice site built for it.
- A guide to web scraping in Python using Beautiful Soup (article, Opensource.com, 20 min)
A second, shorter walkthrough reinforces the three scraping steps on a different page, so the pattern sticks.
- The Complete Guide to Python Web Scraping: Requests, Playwright, Scrapy and a Scraping API (guide, ScrapingBee, 40 min)
This explains why plain requests sometimes sees an empty page, and how pagination, browser rendering and scaling up work.
- Automate Emails with Python and smtplib (article, Academify, 25 min)
Send yourself an automatic report. It covers secure login with environment variables and running the script on a schedule with cron or Task Scheduler.
- intro to python (repo, GitHub (shaunickmistry), 1 h)
Finish with workshop exercises that use the book's chapters on web scraping and spreadsheets to build a small project of your own.