This project automates the inclusion of product data into a web system using Selenium for browser automation, OpenPyXL for reading Excel files, and CustomTkinter for providing a simple and modern GUI interface.
It is designed to speed up repetitive tasks by reading structured data from Excel and automatically filling out online forms without manual typing.
📂 The program allows the user to load an Excel file via a graphical interface, map the required fields, and automatically send the data to the target system.
💡 Built for ease of use, it requires no coding skills to operate.
The application is composed of:
- Developed using CustomTkinter
- Dark mode design
- Allows the user to select the Excel file containing product data
- Displays the chosen file path in the interface
- Selenium WebDriver handles browser automation
- Automatically locates and interacts with HTML elements on the web system:
- Text inputs (
<input>
and<textarea>
) - Buttons (by text, CSS, or XPath selectors)
- Text inputs (
- Supports hidden (headless) browser execution for background automation
- OpenPyXL loads the spreadsheet
- Reads each row and maps it to the form fields in the system
- Python – Core programming language
- Selenium – Web browser automation
- OpenPyXL – Excel file reading
- CustomTkinter – Modern and customizable GUI
- Tkinter – Standard Python GUI library
- cx_Freeze – Packaging into an executable file for Windows