In this video we’ll import spreadsheet data from an Excel .xlsx file to our Treeview in Tkinter with Python.
To pull data from Excel, we’re going to use Pandas and Numpy to do most of the heavy lifting. You don’t need to know anything about Pandas or Numpy in order to do this, we’ll pip install them and I’ll show you everything you need.
We’ll also use a Tkinter Filedialog box to select the excel file we want to open. Then our Treeview will be updated automatically.