- 1000s
- Records automated
- 30+
- Columns per record
The problem
Government portal records were entered by hand from Excel sheets with 30+ columns, and every record needed a generated ID.
What I built
A desktop tool that reads the sheets, drives the portal with Playwright and generates IDs automatically, processing thousands of records without manual entry.
Architecture
How the pieces connect.
Highlights
- Playwright automation of portal forms
- Excel ingestion with 30+ columns per record
- Automated ID generation for thousands of records
- Tkinter desktop UI for operators
- OpenCV in the processing pipeline
Built with
- Python
- Playwright
- Tkinter
- OpenCV
- Excel Processing
- Data Automation
Building something similar?
Tell me about it and I will reply within a day.