So I will include the best resources here in this post. You can also use it on Python to open Excel files to see how it reads and writes Excel files. 1. Excel's API (let) The Excel API is the standard for accessing functions in the spreadsheet software. Python doesn't have an equivalent to this but the let library can take care of everything. The let Library : excel.py : The main function to create a let library import let library = let.open('example.xlsx') print(library.read()) xlsx.py : a function to load a XLSX file into an Excel worksheet #load a let file into an instance of Excel worksheet = worksheet.add_workbook(path_filename) #create an instance of Excel worksheet.worksheets.add_sheet(sheet.name) Worksheet.add_sheet('example.xlsx', sheet.name) If you are running in an Python Notebook, it may not be that easy, but I bet you can do it. 2. Python Data Structures in Excel There are a lot of Python data structures like lists, diets and tables in Excel. So, if you haven't been using them in Excel yet, you need to start doing it. Excel Data Structures in Python 3 — A Tutorial Excel Data Structures in Python 3 — Excel Tips & Techniques 3. Python for Excel's API (let.API) Excel's API is the way to read and write Excel files. You can access the Excel files with the let library using the Excel API or the XLSX API. What is the let API?¶ The Excel API allows us to read and write files, read and write functions, and access data, functions, and objects from the Excel worksheet. For example a function like the following let.API.read_XLSX can read an Excel .xlsx file like this into a data frame. The same let.API.write_XLSX functions can write the same data frame as above.