Python Tkinter Load Excel Data tutorial [openpyxl, tkinter]

Tkinter Excel Viewer tutorial for beginners. Python GUI project for beginners. Learn how to load and view Excel data with Tkinter. Use a Tkinter Treeview for Excel.

In this tutorial, you will learn how to use Tkinter to view Excel data. In the video you will:
- Create your Python Tkinter application
- Use a Treeview in Tkinter
- Install openpyxl
- Use openpyxl with Python
- Load Excel data in Python
- Display data in the Tkinter Treeview

For more info:

Timestamps:
00:00 Introduction and demo
01:05 Project overview
01:39 Installing openpyxl
02:20 Loading excel data in Python
05:00 Creating a Tkinter application
06:30 Adding a Tkinter Treeview

Socials:

*************
**Tags**
Tkinter tutorial
Tkinter install
Tkinter Setup
Tkinter GUI tutorial
GUI tutorial Python
GUI Project Python
Graphical User Interface Python
openpyxl
openpyxl tutorial
learn openpyxl

[colinbolton]

I have just completed Python Excel Data Entry with Tkinter Python GUI Project and it is the best 2 videos of this type that I have viewed, and I have viewed a lot! You have explained everything very clearly, at a speed I was comfortable with. A lot of videos are made by Americans who shout fast information and jump about on screen and I just can't follow them.
I only decided to learn Python in January 2023 and I got nowhere really. I understand the language but methodology was just eluding me. You have taught me what I need to know to create an Excel Worksheet in just 2 days! I will now go on to create a complete workbook to replace the app I previously created using Visual Basic. Yes, I am a very old man and you have made me very happy. Thank You.

[aumvora]

Thank you much
I was trying to do this from many days, finally with your video it is now possible

[Piplover]

I am proud of you, you helped me a lot thank you.

[TrillDSeaux]

how can I do this the other way around? Say i read an nfc card that has a name, age, and absent/present options, I then would like to place that info in a spreadsheet

[yujin-a]

how can i sole problem of window freezing of pyqt5 gui after connecting it with source code

[anonymous-olej]

how can i only choose a number of headings to be display on my treeview ?

[frikuus]

Great work. Question: how to sort and search by name in columns?

[grif]

great vid. my only issue i had was that it will read the cells with values...but if it has a formula, itll only show the formula. to fix this I added a bit to the openpyxl.load_workbook(path). Here is what I came up with. openpyxl.load_workbook(path, data_only=True)

[Piplover]

Please can you make a video about converting multiple tkinter files + mysql database into .EXE file without any problems.

Thank you

[Albrazi]

Is there a way to connect a treeview to firebase? I’m doing a project where a user would be able to input data into treeview on the GUI then can access it through the webapp. Your videos have been really helpful especially the firebase and tkinter stuff. Thank you!