Course compare | Rootlet

Compare with 1 courses

Python Automation: Automate Files, Spreadsheets, Emails and the Web

Python Automation: Automate Files, Spreadsheets, Emails and the Web

Use Python to take repetitive jobs off your desk: tidy folders, combine CSV exports into Excel, read PDFs, write Word documents, send emails and run it on a schedule. 52 written lessons plus 10 practice downloads.

£34.99

Learn more

Has discount
Expiry period	Lifetime
Made in	English
Last updated at	Fri Oct 2026
Level	Intermediate
Total lectures	62
Total quizzes	10
Total duration	12:51:00 Hours
Total enrolment	0
Number of reviews	0
Avg rating
Short description	Use Python to take repetitive jobs off your desk: tidy folders, combine CSV exports into Excel, read PDFs, write Word documents, send emails and run it on a schedule. 52 written lessons plus 10 practice downloads.
Outcomes	Spot which everyday tasks are worth automating and set up a safe automation folder with a virtual environment Find, copy, move, rename, sort and back up files and folders without overwriting anything Use regular expressions to pull dates, codes, prices and invoice numbers out of text and rename files consistently Combine CSV exports and create and format Excel workbooks with openpyxl Read text from PDF invoices with pypdf and create Word documents such as purchase orders with python-docx Build and send emails with attachments safely, keeping passwords out of your scripts Read web pages with requests and Beautiful Soup politely, and call JSON APIs with keys, limits and error handling Make scripts dependable with command-line options, logging, settings files and a schedule, and build a complete weekly automation
Requirements	You know basic Python: variables, lists, dictionaries, loops, functions, reading a file and installing a package with pip A Windows, Mac or Linux computer where you can install Python 3.12 or newer and a few free libraries No paid software: a spreadsheet program helps for opening the workbooks you create