Editing Excel Spreadsheets in Python With openpyxl

Joe Tatusko

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

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 Tatusko 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

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!

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