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.
With pandas version 1.4.0 DataFrame.append() and Series.append() have been deprecated and will be removed in a future version
- df = df.append(values, ignore_index=True)
+ new_record = pd.DataFrame(values, index=[0])
+ df = pd.concat([df, new_record], ignore_index=True)Explore my tools and templates for Excel, automation, and more.
- YouTube: CodingIsFun
- Website: PythonAndVBA
- LinkedIn: Sven Bosau
- Contact: Get in Touch
If you find this project helpful, consider buying me a coffee.
