Link to home
Start Free TrialLog in
Avatar of mcrmg
mcrmg

asked on

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
Avatar of SiddharthRout
SiddharthRout
Flag of India image

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
Avatar of mcrmg
mcrmg

ASKER

I dont have that yet. Users have to open pdf and do the data entry.  thanks
In that case see this link. It will save you hours of manual entry :)

http://www.onlineocr.net/

Sid
Avatar of mcrmg

ASKER

Can ABBY do batch files? What is the type of output files?  thanks
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Try www.verypdf.com/pdf2txt/pdf-to-excel.html ... it is what big organisations use for their daily processing job.
Avatar of mcrmg

ASKER

the pdfs we received are image based.  verypdf seems to work well with text based pdf.  thanks

ABBY is the best OCR software as of date.

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

Sid