Python Excel Data Entry Form with Tkinter tutorial for beginners - Python GUI project [openpyxl]

Excel Data Entry form with Python tutorial for beginners. Python GUI project for beginners. Learn how to create a responsive data entry form with Tkinter and add the data to Excel.
Learn openpyxl. Learn how to launch and create your first Data Entry GUI for Python programs and desktop applications.
Part 1 (Tkinter GUI) • Tkinter Data Entry For...
In this tutorial, you will learn how to use Tkinter, Python, and Openpyxl to enter data to excel using your data entry form. You will:
- Install and setup openpyxl
- Create a new excel file with Python
- Write data to excel with Python
- Save data from form to excel
Source code: github.com/codefirstio/tkinte...
For more info:
Install and Setup Tkinter for beginners: • Install and Setup Tkin...
Playlist link: • Tkinter tutorials
Timestamps:
00:00 Introduction and overview
01:27 Recap
03:22 Installing openpyxl
04:37 Creating the Excel file with Python and adding headings
13:45 Inserting the data into Excel
Socials:
My email: [e-mail]
Tiktok: / hala.codes
*************
*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

[@MrFrancoA3]

I have seen a lot of tkinter tutorials in the last weeks but so far you have been the best teacher, I really think you have a gift to teach in a very clear and concise way. Thank you very much for sharing your knowledge. 😊

[@engineeringwithandy6434]

Excellent simple and clear tutorial I have shared this with my students for their Digital Technology assignment as a reference.

[@astropgn]

I'm 35 old guy with high blood pressure and the doctor said I need to log it 3 times a day. Me being me, I had to add all the data into a database, and every measurement is taken 3 times (so 3x3x30 per month!). I made a simple gui program using the info from this video and now I just open it, type the values and it saves it for me. Next time I will create a plot automatically as soon as a new point is added. This knowledge was so helpful!

[@user-yn3zl1fd4k]

Your tutorials are the best Hala! Thx for sharing! Keep up the great work!

[@McGre9or]

Great course! Great teacher! Awesome skills learned! Thank you so much Hala! 💯👏💚

[@bellaeke1010]

You're a great teacher Hala. These learning nuggets are golden. Thank you so much!❤

[@moneyraymondottv]

Your tutorials have been amazing. I've learnt a lot from them

[@micmike]

Thanks, really enjoyed the lesson. I struggled because i forgot that i had to double slash my filepath so that took a while to resolve and then like a dummy I put the variables names in quotes and so kept getting multiple heading entries but not the data, so after I returned to earth I discovered that and now everything works fine. Much appreciated!

[@JonelAlibasa-zt4mo]

Please continue uploading more videos. We really appreciate your work. Ty

[@ramamurthi7939]

I concur with the rest of the people. You are excellent in presenting this. I will give you 5 stars

[@kidsworld1801]

I am a beginner and i really understood everything which you have taught in the tutorial.Excellent teaching skills you have

[@Diogene-pl1lq]

Waouuuuh Always GREAT teaching as crystal clear. Merci beaucoup Hala

[@Explore4code]

Super Wow, this Tkinter course is an absolute gem! 👏

[@jimalix6270]

Another outstanding tutorial! Thanks very much!

[@michaelallison7259]

Your videos are fantastic, best i have seen for learning python

[@Zak-l7e]

i have just finished the previous tutorial, and this is my second one, so far you nailed it, your way of showing and tutoring is fantastic, you take your time and explain code very patiently, not like many others that skip a lot of explaining and assume you know, keep going and do more practical (by example) tutorials please. thank you

[@agrnpg]

Thankx for breaking it down.. great tutorial for beginners

[@khaladmohaned2002]

you are the best teacher ever ....do more and more please🙂..thank you

[@BillyT83]

Clear explanation and amazing presentation!👍

[@codefirstwithhala]

Thank you for watching! :)

[@paulg6094]

Hi I'm in my 60's and I found this tutorial EXCELLENT, especially the way you break everything down. I would love to see a tutorial of a form like you have but with a data entry that has a scrollable grid and where you can read the information back in from the spreadsheet to the scrollable grid. Thanks again for you knowledge!

[@kakairecharles3474]

I have just landed in, just a few minutes but I am already very comfortable! She is such a wonderful instructor!

[@chellahkalampaoverseas6221]

You the best❤❤❤❤❤❤❤❤❤❤❤ watching from Zambia

[@dmskarunaratne80]

your way is very concise and and clear. Love it.

[@sumitkumargupta1720]

Very helpful video. Thank you so much for posting it.

[@ss-jy2ig]

I just wanna thank you for creating these tutorials. You have no idea how much these tutorials have helped me and many others, I pretty much learned everything I know about pyqt all thanks to your tutorials. Thank you so much Hala!

[@codefirstwithhala]

Thank you so much for your comment 😊It makes me happy to know that at least someone out there is benefitting from these videos. I hope to continue to make more :) thanks again

[@fk4523]

​@@codefirstwithhalathanks giving me sach good teaching. Plz start a fresh python course for data science and machine learning. Plz its request. You r really really amazing teacher. love 💕 ur way of teaching Hala. Love 💕 u

[@fk4523]

​@@codefirstwithhalaplz convert this app in exe file. When i convert using pyinstaller. It converts but exe file not works.

[@MohammedYilmaz-tb4cr]

Thank you so much, your video was very helpful and the best ❤

[@tarkhusny1075]

Great tutorial!

[@xujason4607]

great video , I learned !

[@fouadmoussa3475]

you are a mazing , your tutorial is very clear and inspire all the beginners like me keep going thanks a lot

[@rodrigodesousa7160]

Thanks, Im from Brazil

[@user-yg7uj2bw3k]

thanks form you tutorials i have created this thanks you very much

[@xujason4607]

that is what I need actually !

[@patriciascalisse5418]

Again excellent.

[@juniorludima2727]

very helpful video thank you a lot

[@mohamedalhashmi1386]

Thanks!

[@patriciascalisse5418]

First of all, you are excellent. Although you speak fast is very well understandable in special for people like me which english is not our language. You are really good. Thanks.

[@Sunilkumar-1564]

thank you so much

[@CodePhiles]

Thank you for your videos

[@codefirstwithhala]

You’re welcome!

[@souravbarua3991]

very helpful tutorial.Thank u.Please upload video tutorial for retrieving data or search data from excel and autofill using tkinter.

[@98854arjun]

Awesome

[@manoharsagunthalla9215]

You are the one person to make divisions of each part of tkinter and explain tharoghly. Please explain after entering data into the form and press enter data , the form widget should be blank.

[@feadai]

great

[@funwithlearning9612]

each and every line of code is Very well explained..... implemented a lot of efforts.......Superb...please add delete and update query to in sqlite project... it would cover everything.... and if possible do make a project where automation is applied with python...Keep up the hard work....

[@lenny95sehs]

Awesome video! I have subscribed. Question: Can this code be converted to a windows exe so those that don’t have python on their computers can complete the same action? Question: Is there a way for the GUI to read from excel and populate data from an entry, be edited and entered back in on the same line it came from?

[@jimhicks1947]

Great video, I really like your tutorials. Somebody below asked the same question I was going to ask, can you clear the form after hitting the "Enter Button" or maybe have a "Next" button that does the same thing. Very happy with your videos...😋

[@98854arjun]

Awesome Thanks again. Please we also want how it goes to DB

[@codefirstwithhala]

Same video but with SQLite coming on Friday!

[@98854arjun]

@@codefirstwithhala thanks a lot!!!!!

[@bobciv5171]

Thank you so much for making these videos. I was wondering how I would connect this to a Onedrive using excel?

[@jordanles1766]

hi thanx for the tutorial i have a question the form stores the numbers as text in excel which command can i use to auto convert them to numbers in excel without showing errors?

[@cmrncrick]

Can you clear the data from the entries upon hitting the Enter Data button? So that way you automatically get a clear form for another entry instead of having to delete each field?

[@xujason4607]

Pls keep going anayway .

[@emmanuelakpaklikwasi4300]

I really love your tutorials. Well done! But what will happen if i use the pyinstaller to covert it to an application and i install it on a different computer. The reason why am asking is because of the file path. How do i use the pyinstaller in way that i can install on any computer and retrieve the data in excel automatically as you just demonstrated? Or can you make a video on that? Thank you!

[@jamaicaigot9335]

Thank you for the information, are you also in audea btw? I'd love to listen more of your contents

[@rickswineberg]

The numbers you are currently entering into excel are formatted as text, how to change the formatting.? Thank you

[@assiaben1220]

It's really helpful thanks. How can we do the same thing with ms.word? instead of a form a deed template

[@w4twa]

Hala, great tutorial. I have a question for you. I use Linux, therefore I’m using Libre suite. Can this be used to do the same in a Libre spreadsheet, or only Excel? Thank you for the videos.

[@CodePhiles]

I think there is some code refactoring needed here , when you check the file existence like , if not exist:...create it and add the heading ==> else: ..load it then the remaining lines could come afterwards as: for line 41 same as line 35 and line 39 as line 44

[@TyphonNeuron]

How can you insert data in specific cells in the excel file? Great videos and tutorials BTW.

[@lamkequoc1]

Great tutorial, thank you for the sharing. However, if you insert again, the employment status doesn't set as "Unemployed" even through the checkbutton is cleared. We need to reset 'a' value to be 'False' as well by adding 'a.set(False)' at the of #clear the values codes

[@MohannadElMegharbel]

Can u advice how to develop an RTL form to accept Arabic input

[@moaz_alibrahim]

What theme name do you use in vscode please

[@mohamedalhashmi1386]

thank you a lot. By the way from which country are you from?

[@amanda-janedeagrella5020]

Hi Hala please could you make a video like this one but for saving to a csv file

[@MoMo-lj2ic]

How can the widget refresh in python after entering the data instead of closing it down all the time

[@AK-ox3mv]

Hey Hala, fun fact: "Hala" in Persian mean "now"

[@newlookak47]

I installed openpyxl. But your code is reporting an error

[@itsAyanAli]

the first asian john smith I ever seen

[@topgearIQ]

From where country hala

[@martijn34884]

Hi Hala, How do i import the saved data. I am building an app so i can make maintenance reports. But if they can finish the work they can save the info and reload. But its impossible to find

[@bunmi4164]

ur video is not clear