I'm exploring the idea of automating the process of inputting data from approximately 12,000 raffle tickets (now sales leads) into Excel. These tickets contain names, numbers, emails, and addresses, and they are mostly handwritten. I was wondering if it's theoretically possible to create a script that could read the information from photos I take of these tickets and organize it into a table. I have some experience with Python, but I got frustrated with while loops in the past. Any advice or suggestions? I'm just a low-paid receptionist and this repetitive task is really getting to me!
2 Answers
It sounds like you've got quite a task ahead of you! Automating data entry from handwritten tickets can be tricky, but there are tools out there, like Adobe Scan or other OCR (Optical Character Recognition) software, that could help with the job. These tools can convert images of text into actual text you can manipulate in Excel. Just be aware that since they're handwritten, you might need to do some cleanup afterward. Good luck!
Honestly, consider using Microsoft Access instead. You could set up a table that prevents duplicates, and then import your data there. It’s super fast and would let you manage the data easily before transferring it to Excel if needed. Plus, if you’re dealing with duplicates, it’ll save you a headache!
Haha, my managers probably haven’t heard of Access! I haven't used it since school either, but I'll consider it for sure.