Python Excel AutomationPractical guides for developers

All guides

The whole site as a reading list. Each track opens with an overview, then works through its guides; every guide has its own step-by-step how-tos underneath.

Know the subject rather than the route? Browse by topic.

How a track is organised: an overview maps the area, each guide covers one subject in full, and each how-to solves one task.How a track is organised: an overview maps the area, each guide covers one subject in full, and each how-to solves one task.every track reads the same way downOverviewthe map of a track4 tracksGuideone subject in fullwith its how-tosHow-toone taskstart to finish

Getting Started with Python Excel Automation

Pick a library, read and write workbooks, handle every file format, and drive Excel when you must.

  1. Automating Excel with COM and pywin32
    Show the how-tos
  2. Automating Excel With xlwings: The Basics
    Show the how-tos
  3. Choosing a Python Excel Library
    Show the how-tos
  4. Handling Excel File Formats and Conversions
    Show the how-tos
  5. Reading Excel Files with Pandas
    Show the how-tos
  6. Troubleshooting Common Python Excel Errors
    Show the how-tos
  7. Using openpyxl for Excel File Manipulation
    Show the how-tos
  8. Using Python in Excel
    Show the how-tos
  9. Working with Excel Formulas in Python
    Show the how-tos
  10. Working with Multiple Excel Sheets in Python
    Show the how-tos
  11. Writing DataFrames to Excel with Pandas
    Show the how-tos

Advanced Data Transformation and Cleaning for Excel Automation

Clean, validate, join, pivot and reshape spreadsheet data — including sheets built by hand.

  1. Applying Conditional Formatting With openpyxl
    Show the how-tos
  2. Cleaning Excel Data With Pandas: A Production Workflow
    Show the how-tos
  3. Creating Pivot Tables from Excel Data with Pandas
    Show the how-tos
  4. Excel Formula Equivalents in pandas
    Show the how-tos
  5. Extracting Data from Messy Excel Sheets
    Show the how-tos
  6. Handling Missing Data in Excel Reports with Pandas
    Show the how-tos
  7. Merging and Joining Excel DataFrames with Pandas
    Show the how-tos
  8. Moving Data Between Excel and Databases
    Show the how-tos
  9. Reading Excel with Polars and Arrow
    Show the how-tos
  10. Validating Excel Data with Python
    Show the how-tos
  11. Working with Dates and Times in Excel Data
    Show the how-tos
  12. Working with Large Excel Files in Python
    Show the how-tos

Formatting and Charting Excel Reports with Python

Styles, number formats, tables, charts, images and protection for reports people read.

  1. Applying Number and Date Formats in Excel
    Show the how-tos
  2. Building Excel Reports with xlsxwriter
    Show the how-tos
  3. Creating Charts in Excel with openpyxl
    Show the how-tos
  4. Creating Excel Tables and Autofilters with Python
    Show the how-tos
  5. Inserting Images and Logos into Excel
    Show the how-tos
  6. Protecting and Sharing Excel Workbooks
    Show the how-tos
  7. Styling Excel Cells with openpyxl
    Show the how-tos

Automating Reporting Workflows with Python and Excel

Templates, dashboards, PDF, email, cloud delivery, scheduling, web apps and testing.

  1. Automating Excel Online with Microsoft Graph
    Show the how-tos
  2. Building Finance and Operations Reports in Excel with Python
    Show the how-tos
  3. Building Multi-Sheet Excel Dashboards
    Show the how-tos
  4. Emailing Excel Reports with smtplib
    Show the how-tos
  5. Error Handling and Logging in Excel Automation
    Show the how-tos
  6. Exporting Excel Reports to PDF
    Show the how-tos
  7. Generating Excel Reports from Templates
    Show the how-tos
  8. Publishing Excel Reports to Cloud Storage
    Show the how-tos
  9. Scheduling Python Excel Scripts with Cron
    Show the how-tos
  10. Serving Excel Files from Python Web Apps
    Show the how-tos
  11. Testing and Packaging Excel Automation Scripts
    Show the how-tos