OCR to excel

Hi,

We receive over 300 PDF every month.  We have to open each one and enter into database.  The format is like this
Payment1    $100
Payment2    $200
Payment3    $300
Payment4    $400
Payment5    $500

My question i, is there a way to OCR it into EXCEL horizontally?  So we can dump it into db in one shot?  thanks
mcrmgAsked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
0
 
SiddharthRoutCommented:
I use ABBY Fine Reader for such purpose and it suits me pretty well. Laying out the data in Excel comes later. A macro can help you there. Right now how is the output laid out in Excel at the moment?

Sid
0
 
mcrmgAuthor Commented:
I dont have that yet. Users have to open pdf and do the data entry.  thanks
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
SiddharthRoutCommented:
In that case see this link. It will save you hours of manual entry :)

http://www.onlineocr.net/

Sid
0
 
mcrmgAuthor Commented:
Can ABBY do batch files? What is the type of output files?  thanks
0
 
suvmitraCommented:
Try www.verypdf.com/pdf2txt/pdf-to-excel.html ... it is what big organisations use for their daily processing job.
0
 
mcrmgAuthor Commented:
the pdfs we received are image based.  verypdf seems to work well with text based pdf.  thanks

0
 
SiddharthRoutCommented:
ABBY is the best OCR software as of date.

Sid
0
 
SiddharthRoutCommented:
Why don't you download a trial version and check it out yourself ;)

Sid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.