This video is about How to read Excel XLSX files with Python and openpyxl library, and how to convert the exported data to a list of Python dictionaries.

If you are looking for “how to read excel file in python”, or “read excel file in python”, or “excel automation using python” - the video is right for you. All you need to do is to use the OpenPyXL libraries, and this tutorial is about it.

This Python Excel and Openpyxl Tutorial is a quite detailed explanation for absolute beginners.
And it includes the following topics:

• how to read Excel file in python
• how to get an active spreadsheet
• how to get a value of cells
• how to use Python generators and list comprehension to get the titles of columns
• using zip() function to combine titles and the rest data

#python