Production-focused guides that turn recurring Excel work into maintainable Python — reading any workbook, cleaning and reshaping the data, writing formatted reports with charts, and scheduling and delivering them. Find your subject by topic, follow a track from the beginning, or search for the exact error you are looking at.
Each topic page gathers every guide, how-to, comparison and fix on its subject, wherever in the site it lives. All topics →
Getting data out of a workbook and back into one — every format, every layout, every sheet.
Turning what the workbook holds into data you can trust and reshape.
Writing formulas from Python, reading their results, and replacing them with code.
Making a generated workbook look like somebody finished it.
The job around the workbook: where the data comes from, when it runs, and who receives it.
When the file is not enough and you need the Excel application — on the desktop or online.
Choosing the right library, making it fast, and decoding what it throws at you.
Each track opens with an overview, then works through its guides, and every guide has its own how-tos. The full reading list →
Pick a library, read and write workbooks, handle every file format, and drive Excel when you must.
Clean, validate, join, pivot and reshape spreadsheet data — including sheets built by hand.
Styles, number formats, tables, charts, images and protection for reports people read.
Templates, dashboards, PDF, email, cloud delivery, scheduling, web apps and testing.
The most recent additions to the site.
