Python Excel App - Excel Viewer & Data Entry Form [Tkinter, openpyxl] Python GUI Project

Build a modern Tkinter GUI project to automate Excel tasks with Python. This Python GUI project works as both a data entry form and an Excel viewer.

In this video, you will:
- Create your first Tkinter application
- Create a modern Tkinter app
- Use a Tkinter theme with ttk
- Create a Tkinter data entry form
- Use the Tkinter Button, ComboBox, Spinbox, Entry, CheckButton
- Style and modify Tkinter widgets
- Use both a dark and a light mode for the app
- Install openpyxl
- Load data from Excel into Python
- Use data entry form to add data into Excel

Timestamps:
00:00 Introduction and Overview
01:05 Forest-ttk Theme Overview
01:58 Project folder structure
03:13 Starter code
04:44 Using the theme
05:40 Understanding Tkinter geometry managers
10:16 Creating the Name entry
15:36 Creating the Age spinbox
17:56 Creating the Subscription Status combobox
20:44 Creating the Employment Status checkbutton
22:58 Creating the Insert button
23:34 Updating the padding of the widgets
25:19 Creating the separator
26:15 Creating the Mode switch
27:17 Changing between dark mode and light mode
29:34 Creating the Treeview to display the Excel data
34:21 Installing openpyxl
35:27 Loading data from Excel into the treeview
39:28 Collecting the data from the Insert Row form
42:52 Inserting the data into the Excel sheet and treeview
45:12 Clearing the form after inserting

Socials:

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

[mthorne]

The way she explains the code and what it is used for as she goes along is a lesson other youtubers could learn.

[gunloco]

These tutorials are great for learning the Tkinter library I hope everyone is jumping back and forth between the video, their code and the docs to see the full capabilities of Tk

[shallanrambaran]

After 2 mins of how she tackled the lesson I saved the video because I can tell I'm not going to be wasting my time here. Will try her tutorial in a few days (I will be more free then). I love how Hala starts the video; no nonsense and straight to the point.

[blendid]

Thank you for this tutorial. Your explanations are very clear. I can follow along without getting lost. Now I understand better how to build Python code with tkinter. Thank you, Hala!

[juancharlie]

I've watched three of your videos now. Thank you and well done.

[billpowell]

Excellent presentation about developing a fairly simple app to interface with Excel. Thank you for sharing.

[Deepakkumar-iuve]

What a great explanation! Thank you so much❤.

[marciojunior]

Hala, thanks for the great video. You are a very good teacher. Well explained 👏🏻👏🏻

[bithepower]

Thank you for an excellent video. New to your channel and just subscribed!

[carneica]

Very well structured tutorial! No BS, direct to the point!
I'm new at Python but already made some progs using ttk so, knew most of the things you explained! Nevertheless, you gave me a new insight on how to structure the widgets around the root>frame>cols structure/hierarchy... I was making it to complex... but you don't! ;)
Keep on doing great stuff like this! Congrats!

[painkillerO]

You got a new subscriber. First time looking at Python.

[ihnpuhf]

Amazing Video with all necesarry explanation. The best I ever saw

[gerancemdm]

I like all your videos; You're a great teacher!!thank's

[DexterOhaeri]

I seldom comment on tutorial videos, but this one is good. Keep it up!

[barackuse]

Nice video, it took me a while to place the required images but I figured it out.

[zeli]

Great course. Thank you so much. I hope to see your more and more lightweight widget software.
Best wishes to you.

[Funtstk]

excellent presentation and very clear mind

[Steve.Outdoors]

Excellent video and all well explained getting straight to the point. Brilliant thank you x

[socdocm]

Thank you for the interesting explanation

[serenadenphoto]

That was an excellent presentation with a good pace which made it easy to follow along.