Autumn Offers - hours only!Up to 80% off on all courses and bundles.-Close

Python is a general-purpose language that allows you to perform various tasks related to programming and data science. Thanks to Python, you can freely process many different file formats including Excel and automate your daily work.

Excel, a spreadsheet application developed by Microsoft, is one of the most popular data exchange formats used by businesses and individuals. Most likely, you too are using Excel to record expenses, plan budgets, track progress, and complete many other tasks. Why not use Python to automate boring, everyday Excel-related tasks? Write some code that will do the work for you, and you will have more time to plan your next steps and strategies. Work more efficiently, because time is money!

“How to Read and Write Excel Files in Python” is an online course that introduces you to working with Excel files in Python. You'll learn how Excel files are built and how to work with them, with practical examples. You’ll learn how to process Excel files with openpyxl, a popular Python library that allows you to read and write Excel 2010 and later. We use Python version 3.0.4 for this course, but the features covered in the course are compatible with versions going back to 2.5.0.

In the course, we will first examine how Excel files are organized, and review some basic terminology related to Excel spreadsheets. After the introduction, we will explain how to read Excel files with openpyxl and how to process them in for loops. Finally, we will see how to create Excel files and modify their content in Python. In the final quiz, you’ll do several practical tasks on Excel files.

“How to Read and Write Excel Files in Python” is one of the courses from our Python File Processing track, where you'll learn to work with different file formats in Python. You can complete the courses from this track in whatever order you wish, since they don’t depend on each other. See what will be most useful to you! Remember that each course is a way to make your daily work easier.

Do you deal with Excel files at work? Then this skill is a must-have on your list.

Are you a data science beginner or a business professional performing data analysis using Excel files? Then this course is perfect for you!

Scroll down for an overview of the topics covered in this course, and for more about who all can benefit from it.

What's in It for Me?

  • 45 interactive exercises. Learn at your own pace, anywhere and anytime. Interact with hands-on exercises for improved retention.
  • Lifetime access to the course. When you purchase the course, you'll get instant personal access to all of its content.
  • Certificate of completion. After you successfully finish all of the exercises, you'll get a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money back guarantee. If you're not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
  • Hints for the exercises. You can ask questions and share insights with other members of the community through the Discuss tab. We'll be more than happy to answer! 😉

What Are the Requirements?

Learn How to:

  • Name the elements of Excel files.
  • Work with Excel files in Python.
  • Open and read an Excel file with openpyxl.
  • Create an Excel file in Python.
  • Write to an Excel file and modify its contents in Python.

Who Should Take This Course?

  • Students taking entry-level classes in Python.
  • Data analysts and other people interested in data science in Python.
  • Business professionals using Excel to analyze data.
  • Anyone working with Excel files who wants to automate simple work tasks.
    Start this course

    Bundle deals


    Reg. price

    One to Rule 'Em All

    Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python

    Bundle price $199

    37 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 45 exercises done

    1. Spreadsheet Basics & Opening Excel Files

    Learn the basic structure of Excel spreadsheets and how to open them in Python.

    More details Less
    Start now

    0% completed 0 of 5 exercises done

    2. Accessing Data in Excel Files

    Discover how to get data from Excel sheets, cells, and selection areas using Python.

    More details Less
    Start now

    0% completed 0 of 17 exercises done

    3. Working with Workbooks

    Add, modify, and delete data in Excel files.

    More details Less
    Start now

    0% completed 0 of 16 exercises done

    4. Final Quiz

    Put your new skills to the test in these challenging exercises.

    More details Less
    Start now

    0% completed 0 of 7 exercises done


    Average rating

    5/5100.0 (1)


    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews