Editing Excel Spreadsheets in Python With openpyxl

Joe Tatusko
Joe Tatusko 16 Lessons 1h 13m intermediate data-viz

Excel spreadsheets are one of those things you might have to deal with at some point. Either it’s because your boss loves them or because marketing needs them, you might have to learn how to work with spreadsheets in Python, and that’s when knowing openpyxl comes in handy!

In this course, you’ll learn how to use openpyxl to:

  • Read Excel spreadsheets and iterate through the data
  • Manipulate speadsheet data using Python data structures
  • Create simple or more complex spreadsheets
  • Format workbooks using styles, filters, and conditional formatting
  • Enhance spreadsheets by adding images and charts

What’s Included:

Downloadable Resources:

Related Learning Paths:

About Joe Tatusko

Joe is a manufacturing engineer turned Pythonista with interests in data wrangling and visualization.

» More about Joe

Each tutorial at Real Python is created by a team of developers so that it meets our high quality standards. The team members who worked on this tutorial are:

Participant Comments

Avatar image for ranjeet

ranjeet on April 6, 2022

Great course with very clear explanation for each and every topic discussed into this tut. Extremely helpful. More to utilize by looking into openpyxl documentation to see what all it will do while working with projects in near future. Thank you so much JOE!

Avatar image for Ricky Mitchell

Ricky Mitchell on Jan. 4, 2021

Great course. Extremely helpful. Now, it is time for me to read the openpyxl documentation to see what all it will do so that I can use it in a cool project. Thank you!

← Browse All Courses