How to Create an Excel Data Entry Form in 10 Minutes Using Python (No VBA) | Easy & Simple

👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Did you know you can use Python code to create an Excel Data Entry Form? This is a tutorial that will show you how to create one using the PySimpleGUI & Pandas library. No VBA or macros are required. At the end of the tutorial, we will also be converting the Python script to a standalone program. In doing so, we could share this data entry form with colleagues & friends, and they could use our program without having to install Python. The best part is that you could use this code as a starter template whenever you want to build a data entry form for Excel. If you want to add or remove columns, you only need to change one line of code. Additionally, you could also easily add more elements to the user form, like Multiline Input Fields, sliders, list boxes, a file dialogue box and much more.
PySimpleGUI Documentation:
▶ pysimplegui.readthedocs.io/en...
Full code and sample files are available here:
▶ github.com/Sven-Bo/data-entry...
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: pythonandvba.com/coffee-donation

[@PySimpleGUI]

FANTASTIC video! In the first 3 minutes and 20 seconds you've taught the entire concept of PySimpleGUI. You're really good at this! 💖 the style, the clarity, the animations, and so much more about what you've done.

[@CodingIsFun]

Thank you so much for your comment & this fabulous and simple to use library. I simply love it - with just a few lines of code, we can add a GUI to our program without messing around with the underlying frameworks. So clever and very well done! 😃👍

[@meshramab1]

@@CodingIsFun Very nice. I have just started learning PySimpleGUI, last month. I want to build a project for my niece for garment shop. Hope I will achieve it soon with the help of experts like you. Thanks a lot. Keep it up.

[@shiv_kna]

Seriously I loved it. No one has this organized tutorial with documentation as implementation.... I'm in love

[@CodingIsFun]

Thank you so much for your kind feedback! :)

[@pleabargain]

Super impressed! Finally a clear demo of how to build a UI that writes to Excel via python. Thank you!

[@CodingIsFun]

Hi Dennis G D! Happy to hear that you liked the video. Thanks for watching and taking the time to leave a comment! :)

[@anthonyjobey8821]

By far this is the best tutorial video I have seen, clear instructions, demonstrations in theory behind each concept and easy to follow bite size steps, learnt more in this short video then in some hour long ones. Thank you for taking the time to produce this and share your expertise with the Community

[@CodingIsFun]

So happy to hear that you found the video helpful. Thank you very much for watching the video and taking the time to leave a comment! :)

[@shawnvines2514]

Good job on the video! Clear, concise and good presentation. I really like the code animations. Looking forward to watching more of your videos.

[@CodingIsFun]

Thank you. Glad you like the video :)

[@auusiebatman]

This is the correct benchmark of technical teaching - I wish more technical trainers could adopt your clear framework for breaking down technical concepts for coding - thank you !

[@CodingIsFun]

Thanks for the kind words! I am glad you enjoyed it.

[@lemonjuice9844]

Oh man, I'm just started to learn python, and find out that your channel has a bunch examples with 99% of all my needs and also real life examlples which I saw during past years while trying to achieve some automation via VBA. Keep up the good work ❤❤❤

[@CodingIsFun]

Thanks for the kind comment, and happy to hear you're enjoying the videos!

[@florianroeseler2404]

Didn't know this was possible so easily. Very practical!

[@CodingIsFun]

Thank you for watching the video, Florian. Glad it is helpful!

[@tonyquique1912]

This video is awesome. The concision, clarity and simplicity put in the explanations are impressive! Thanks and please do keep up!!!

[@CodingIsFun]

Thank you so much for your positive feedback! I appreciate it! 😃

[@charliearmour1628]

Thinking about the many ways I could use this method. Thank you so much for this. Please keep up the tremendous work. This one's a real gem.

[@CodingIsFun]

*I am glad you liked the video; thanks for watching and the kind words.* 😀

[@alicemystery5520]

This is a great video. I am a beginner at using python and coding. This will help me understand what a GUI is and allow me to create something nice for work. Thanks a lot!

[@CodingIsFun]

Thank you for watching the video. I am glad to hear that the video was helpful. Happy coding! 😃👩‍💻

[@Kicsa]

This is so fun, thank you so much! I'm happy I found this channel!

[@CodingIsFun]

Happy to hear that you liked the video!

[@KartikeyRiyal]

I'm soooooooooooooo happy to see this. Much needed video. I was searching for this only.

[@CodingIsFun]

Glad you found it. Hope it is helpful :)

[@ermalgashimramori]

As always, your content is pure gold!

[@CodingIsFun]

Thank you for your kind words :)

[@andrell1206]

i enjoy all your tutorials. this was the 4th i have followed along. i am learning so much

[@CodingIsFun]

I am happy to hear that you have been finding the videos helpful. Thanks for taking the time to leave a comment and for watching!

[@bensonyeo1087]

you just got another subscriber , this is so useful and relevant in my field of work . Just started out with python and your explanation is so clear and concise . Thank you brother.

[@CodingIsFun]

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

[@Axfourty]

Sorprendente, es un super video, breve claro, práctico y muy educativo. Muchas gracias

[@CodingIsFun]

Thanks for the kind words! Glad to hear you found the video helpful and educational. 👍

[@eteichma]

What more can I add than what has mentioned many times before? Simply a FANTASTIC video!! Thank you for your wonderful contribution.

[@CodingIsFun]

Loved reading your comment! Thanks for the support! 👍❤️

[@bzaz228]

One of the best tutorials I have seen. Thank you

[@CodingIsFun]

Thank you!

[@fizahmajid1930]

Thanks for the video. I am going to start using this. Good work! Hope to see more tutorials.

[@CodingIsFun]

Thanks for watching the video and taking the time to leave a comment! :)

[@darkened_controller_001]

Bro, seriously, you are really the god of coding to me , it was the best tutorial i have ever seen

[@CodingIsFun]

Thank you, mate! Happy to hear that the video helped you. Happy Coding! Cheers, Sven ✌️

[@Mattykek]

Wow you made that so easy to understand. This topic was intimidating for me being new to coding. Thank you for the vid :)

[@CodingIsFun]

Glad to hear you liked it! Thank you for commenting and watching. 😃

[@erickgutierrez6471]

You explain really well. I’m feeling motivated to automate a task

[@CodingIsFun]

Thank you for watching the video and taking the time to leave a comment. I am glad you liked the video.

[@chessking6518]

Bro you are great. You taught exactly what I needed. Love you man

[@CodingIsFun]

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍

[@JorgeMuxica]

WOW I am impressed. This video is friendly and right to the point. Love it. In 10 minutes I learnt more stuff than reading any book on this topic. Excellent Job!

[@CodingIsFun]

Thanks for the positive feedback! Appreciate you taking the time to leave a comment. Cheers, Sven ✌️

[@coolboysidd]

Super!!explained in a very simple way but very effective..so many things learnt in a such a small video!!great work sir!!

[@CodingIsFun]

Happy to hear that. Thanks for watching and your kind words!

[@drjainbhopal]

This is very useful. Thanks Sven!

[@CodingIsFun]

Thank you! Glad you like the solution!

[@dmz140]

Excellent video! Thanks for the help!!

[@CodingIsFun]

Glad I could help! Thanks for watching! 👍

[@deanlawson6880]

Well done nice little video! Thanks for this!

[@CodingIsFun]

Glad you enjoyed it! Thanks for watching and taking the time to leave a comment! 👍

[@shout-style]

Very well explained!! Thank you!

[@CodingIsFun]

Glad you liked it. Thanks for watching. Cheers, Sven ✌️

[@deborahodion5240]

This was beautifully taught. Thank you.

[@CodingIsFun]

Thanks for the kind words! I am glad you enjoyed it. 🤩

[@KhalilYasser]

Awesome. Thank you very much.

[@CodingIsFun]

A pleasure! Thanks for watching :)

[@jasonjang5112]

Thank you❤, really appreciate your efforts

[@CodingIsFun]

Glad you liked it. Thanks for watching.

[@mohamedlahrech178]

Awesome, thank you.

[@CodingIsFun]

You're very welcome! Thank you for watching and for the comment!

[@BRAM_PC]

This is great! Thank you a lot!

[@CodingIsFun]

My pleasure! Appreciate you taking the time to watch and leave a comment.

[@yajan6650]

This is seriously impressive. 👏

[@CodingIsFun]

Thank you very much!

[@metomeid1693]

...wow..Very good video...thank...

[@CodingIsFun]

Thank you! :)

[@rmp5s]

Very cool!!

[@CodingIsFun]

Thanks! :)

[@tinavo1758]

Thanks for making this so simple to understand

[@CodingIsFun]

Glad it was helpful! Thanks for watching the video & taking the time to leave a comment :)

[@amoldalwai3961]

This is top notch content ..hope you gain more subscribers

[@CodingIsFun]

Thank you 😃🙏

[@dotank35]

What is amazing video, many thanks!

[@CodingIsFun]

Glad you liked it. Thanks for watching and taking the time to leave a comment!

[@tobiewaldeck7105]

Thank you for the video. I was using the append with concat when I was trying Web Scraping, but it was very confusing when dealing with multiple page scrapes because I'm a beginner. I saw someone with pdf extraction use something called a namedtuple for combining values, and appending a list which is then put into a dataframe. That method seemed simpler to me.

[@CodingIsFun]

Thank you for watching the video and taking the time to leave a comment!

[@mohsowadi8302]

Most clear and cleaver video I've ever seen >>>>>> good job

[@CodingIsFun]

Thank you very much! :)

[@mohsowadi8302]

@@CodingIsFun Although there is a problem i hope you can help me with , the script wont convert to .exe , whenever i tried it says (IndexError: tuple index out of range) , dist folder is empty as well everything is updated i'm using Visual Studio and the script work fine with Visual Studio and from the Command prompt I would really appreciate if you know the answer Regards

[@michaels7886]

Best tutorial on the net

[@CodingIsFun]

Thanks for the kind words! I am glad you enjoyed it. 👍

[@e-normous]

Very helpful tutorial, thx a lot!

[@CodingIsFun]

Thanks for the positive feedback! Appreciate you taking the time to leave a comment.

[@Frank-si2jd]

Hello Sven, I can just add another positive reaction to all the others you already received, WOW WOW what a great tutorial! Thanks for this amazing work and I guess the Python community should build a statue for you! Regards, Frank

[@CodingIsFun]

Hey Frank, Thanks for watching and leaving such a kind comment! I really appreciate it. 🙏 I'm glad you found the tutorial helpful. Happy Coding! 🚀

[@HeyFaheem]

Great Work Sir...

[@CodingIsFun]

Thanks for the kind words! I am glad you enjoyed it.

[@christiansfaith5631]

Another great video discover

[@CodingIsFun]

Happy to hear that you enjoyed this one too! Thanks for the comments! :)

[@erolsavas19]

Thanks for this great example.

[@CodingIsFun]

An absolute pleasure, very happy to hear that you found it useful! 👍

[@XLnCADMalayalam]

Awesome work 😀

[@CodingIsFun]

Thank you!

[@ankitseth100]

Great video, subscribed

[@CodingIsFun]

Thanks for the sub! :)

[@csantino5728]

Love it I already reply this project it work 🎉

[@CodingIsFun]

Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️

[@haribhaskar72]

Wow .very nice video...thanks ..

[@CodingIsFun]

Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️

[@rodrigovieira4113]

congratulations, thank you for sharing your knowledge

[@CodingIsFun]

Thank you for watching the video and taking the time to leave a comment! 👍

[@Youtuber-Hub]

Very beautifully explained....very informative

[@CodingIsFun]

Thanks for the kind words! I am glad you enjoyed it.

[@chrisr2063]

Love the voice/accent. Cross between a man child and very intelligent man. Love the vids too. Will sub

[@CodingIsFun]

Hey Chris! Thanks for watching and subscribing, welcome aboard! 👍

[@elroeanunciado7202]

i learned a lot..thank you

[@CodingIsFun]

Glad to hear that! Thank you for watching the video & taking the time to leave a comment 😃

[@DG-xg8vg]

thank you for the video!

[@CodingIsFun]

Thanks for watching the video & your comment. 😀

[@mind7106]

Awesome sir god bless you You explained it simply amd effectively and more important clearly Thank you sir 🙏🏻

[@CodingIsFun]

Thanks for leaving a comment! Happy you enjoyed the video! 🙏

[@veerendranadhkillampalli3387]

i am python biggner, thanks and more helpful

[@CodingIsFun]

Glad you liked it. Thanks for watching.

[@svem1972]

Amazing tutorial and truly i am very much impressed for your knowledge and sharing such a beautiful content to Enthusiast Pythonist developers.

[@CodingIsFun]

Happy to hear that you liked the video; thank you for taking the time to leave a comment and for watching the video! 👍

[@svem1972]

@@CodingIsFun sir not only liked your video, subscribed.as well

[@elmondo.]

Thanks for sharing

[@CodingIsFun]

A pleasure. Thanks for watching!

[@aravinthmegnath3569]

Ultimate bro

[@CodingIsFun]

Thanks! 💪

[@shamsul262]

Excellent.

[@CodingIsFun]

Thank you!

[@BiP00]

Man I wish I'd found your channel earlier!!! This is super useful!!!

[@CodingIsFun]

Happy to hear that you find the video useful! Thanks for watching and commenting! :)

[@samaritanx9609]

Xlent video.. ❤️simple and clear Sven..U shortened my learning with this video.. if possible.. please make video on update, search and delete options on this topic itself...which will enhance knowledge of ur followers. ❤️ My advanced wishes...

[@CodingIsFun]

Thanks for your kind words & video suggestion! I appreciate it! :)

[@aishasalim4243]

We have same opinion and waiting.

[@anawerena5396]

I love your channel

[@CodingIsFun]

It's very kind of you to say so, thank you! 🙏

[@IoTWebPlanet]

Excellent 🙏

[@CodingIsFun]

Thank you! :)

[@solomondagnew2590]

i have impressed with your tutorials .please show us save delete and edit button and report generation based on the saved data

[@CodingIsFun]

Thank you very much. For retrieving/editing data, have a look at the following short example: kzbin.info/www/bejne/iJ-3op-Br7abiLs I hope this helps!

[@MonstroFull]

thanks my friend...

[@CodingIsFun]

Thank you for watching the video and taking the time to leave a comment!

[@Ja14111948]

exzellent.

[@CodingIsFun]

Glad you liked it. Thanks for watching.

[@apsellynch]

Pythons for business in a nutshell 🤯🤯 So many ideas to work with this base...thanks

[@CodingIsFun]

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

[@gasskeunchannel2741]

this is what I need. thanks man. +1 subscriber from me

[@CodingIsFun]

Great! Welcome aboard! :)

[@achyarfauzan4880]

thanks, i love it. the best for now

[@CodingIsFun]

Thanks!

[@achyarfauzan4880]

@@CodingIsFun why u dont use openpyxl?

[@CodingIsFun]

@@achyarfauzan4880 No particular reason. You can also use openpyxl.

[@alenpauls5159]

amazing video Sven! i was wondering if there is way to work whit an excel that has two cells merged as a heading and inside that there are two different attributes. for ex: sales on row 1: columns 1,2; and row 2, column 1 is price, column 2 is quantity. when i put the key as price or quantity it makes a new column with these heading, can i point the program to read row 2?

[@igormaricic7093]

awesome

[@CodingIsFun]

Thank you! :)

[@sureshgoku]

Great video and a simple explanation thanks Sven. Needed to know how to retain same info for additional information entry. Like say there are two customers whose item list is similar except for 1 or 2 additional items. While doing the data entry for customer 2 I would like to give an option to retain items added for customer 1 and just add new items and do the data entry.

[@CodingIsFun]

*Hello Nikhil Gore, thanks for watching the video and your question.* I have created a custom solution for you. Kindly have a look at the following video: 👉 kzbin.info/www/bejne/iJ-3op-Br7abiLs&ab_channel=CodingIsFun You will find the source code and the Excel File for your solution in the description box. Please treat it as a 'starter template'. You might want to adjust it to your specific use case. I hope it helps 😃 Cheers!

[@sureshgoku]

@@CodingIsFun thanks Sven just what I was looking for. Thanks alot

[@TheStevenStevenson]

Combining this concept within a streamlit app [taking user input and recording into an excel spreadsheet] would be first class.

[@CodingIsFun]

Thank you for watching the video & your suggestion.

[@hgyt5yh3h53t]

Subscribed! Thank you so much for the tutorial, I'm just a beginner in python but this really helped me building a simple database. It could be useful to upgrade the form allowing to modify the excel data once they are stored. Could you point me in the right direction? Thanks again!

[@CodingIsFun]

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

[@edmundosilva6309]

This is great! I would like to know if we share the file and employees fill on their desktop if the information start updating on its own

[@CodingIsFun]

Thanks for watching. Sorry, but I am not sure what you mean.

[@nagendravishwamitra3652]

Super,,, you are making our life simpler

[@CodingIsFun]

*Hello nagendra vishwamitra, thanks for watching the video.* Glad it was helpful!

[@nagendravishwamitra3652]

Sir, could you please give the code for pyinstaller --onefile--noconsole data_entry.py in jupyter notebook

[@CodingIsFun]

@@nagendravishwamitra3652 The code would be the same - you could run it in a Jupyter Notebook cell, or do you get any errors?

[@lindal9056]

Hi Sven! Thank you so much for such an informative video! I have a question: what happened if we have multiple sheets in our excel file we want to enter the data into instead of the default sheet 1? Thank you in advance!

[@CodingIsFun]

You could export it to an existing/specific sheet. Here is an example of how to do it in Pandas: kzbin.info/www/bejne/eqPSkpmNhr2ketk

[@paxter3219]

THX! for the video, is there a use and input box to add numbers to multiple certain cell location within the CSV file? For the file I need to create, there is a value that need to input to multiple location within the CSV. So one input multiple output in different locations within the CSV.

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@moisesnava6142]

Great video Thanks for this, I have one question y supossed that when I share the exe file needs to be with the excel and has to be in the same path right? To change this path I could implement other window with option to change the path or the file to append data?

[@CodingIsFun]

Thanks for watching. You are right. Currently, the application is looking for an Excel file in the same folder. Yet, you can select the Excel file dynamically by inserting the 'FileBrowse' Element: pysimplegui.readthedocs.io/en/latest/call%20reference/ www.screencast.com/t/64AUEVrzN I hope it helps! Happy Coding! :)

[@Pankaj-Verma-]

Thanks.

[@CodingIsFun]

My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

[@walidmat8972]

amazing video thanks a lot

[@CodingIsFun]

Thanks for watching and your comment! :)

[@walidmat8972]

@@CodingIsFun can we set coordinates X,Y as an arguments to position an element like a text, a button or an input field ? thanks

[@CodingIsFun]

@@walidmat8972, I am not sure if that is possible. I quickly checked the documentation but could not find an option to set the x and y position. But perhaps I have overlooked something. Here is the link to the official documentation: pysimplegui.readthedocs.io/

[@walidmat8972]

@@CodingIsFun Thanks a lote 🙏

[@rulibeatz2885]

Thanks a lot! Is it possible for text fields to have text prediction, autocomplete?

[@CodingIsFun]

Thanks for watching. You might want to check out the following GitHub issue: github.com/PySimpleGUI/PySimpleGUI/issues/820

[@SanataniAryavrat]

awesome tutorial... could you also please make a tutorial on "Copy pasting cells within an excel file using python". something like: copy only the entire (rows) cells and columns in which data is, and then paste this after the last data column.

[@CodingIsFun]

Thanks for watching and for your suggestion. I have done something similar already in the past. You can find the video here: kzbin.info/www/bejne/gKDSn4WggtiGmrs I hope it helps! Happy Coding!

[@ahmedhelal920]

Really thank you very much , you are a great teacher , and i have question please , i need to know how can we make form size bigger than this

[@CodingIsFun]

Thank you! You can change the layout as follows: window = sg.Window('Simple data entry form', layout ,size=(290, 50))

[@freddykibassa3383]

Thank You so much for the video, it was very helpful. Exactly what I was looking for to complete a project at work. But I have a question, after generating that "little application" that prompt our form, how do I share it with other people?

[@CodingIsFun]

7:40 min

[@ahmedjoo1858]

amazing video, one of the most valuable 3min i spent on youtube. would you show how we read combo information from mySQL db instead of hard code it in the program? thanks

[@CodingIsFun]

Thanks for watching the video. Happy to hear that you found the video valuable. In essence, PySimpleGUI is 'just' used to create the GUI. If you want to manipulate a MySQL database, I would suggest coding out your pure Python script first (without GUI). Once you got your CRUD (Create/Read/Update/Delete) functions in place (or whatever you want to do) when you can build the GUI using PySimpleGUI. To get started with MySQL + PySImpleGUI, check out the following post: stackoverflow.com/a/622308 Happy Coding! 🚀

[@giorgiopesci1273]

I am a novice, and I need guidance on how to install the Command Prompt. The Windows Command Prompt returns errors only. Thank you. BTW. Great job! Straight to the point, and it is exactly what I needed. Regrettably, I am not a programmer and I have difficulties to install the tools to code and follow your instructions. Thanks again.

[@CodingIsFun]

Thanks for watching. The actual error message would be helpful if you would like some guidance. Thanks! Cheers, Sven ✌️

[@nssdesigns]

I was looking for a way to get data from and Excel file to use in an online web form filling. I've done this successfully using Power Automate Desktop but now I don't have a license. Looked at AHK but without the coding skill it's beyond my scope for now. Watched your video using chatGPT to write Python automation BUT I guess this is a bit more challenging as each input field needs to be mapped in Python. How deep would this be?

[@patriziotiburzi136]

Amazing tutorial. Thanks for your work. I have a question tho. What should I do if i need some of the fields of the excel file to be filled always with the same data? I'll explain this. I have to worl with a boring CSV File in wich i have to manually fill only 2 or 3 cells, and the remaining (a total of 10 in a line) they have always the same data. A boring work of copy/paste for hundreds of lines. This will help me a lot if I could apply your teaching on my needs. Thank you

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@hasanaqbayli149]

Hello Man, The way you are explaining is excellent!!! Thanks a lot, Please tell me Do you have similar tutorial or code where Data Entry is My SQL intesad of excel? Thanks in advance

[@CodingIsFun]

Thanks for watching. Nope, I do not have a tutorial on that topic.

[@fernandocoelho1334]

Very Good! There is a complete application with Save, Read, Update and Delete.

[@CodingIsFun]

Thanks! No, I do not have a 'complete' CRUD application.

[@fernandocoelho1334]

@@CodingIsFun Great!

[@michaelskirde-visuata5742]

Hey, really a great tutorial. This I was looking for. Let‘s see if there is also an app to display the content of the excel file.

[@CodingIsFun]

Thanks! Here is a small example of how to retrieve data: kzbin.info/www/bejne/iJ-3op-Br7abiLs Perhaps it already helps. Happy Coding!

[@guatireguitar]

Fantástic video. Thanks you very much. One question: what IDE you use? I'm using Visual studio code...

[@CodingIsFun]

Thank you. In the video I used 'Atom'.

[@padula77]

Thanks for the helpful video! is it possible also to make some calculations before insert the data into the excel? How to do it? thks

[@CodingIsFun]

Thanks for watching. Yes, it is possible to perform calculations before inserting the data into Excel. You can do this by manipulating the data in the "values" dictionary or the "new_record" DataFrame. Happy Coding!

[@stevemorse5052]

Hi great video, clear and concise. I do have one question though, having watched several videos on this kind of topic, I have noticed that Excel and Word files are used, why not Libre Office files?

[@CodingIsFun]

Simple answer for my videos: I only have MS Office installed ;)