• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 522
  • Last Modified:

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
0
mcrmg
Asked:
mcrmg
  • 5
  • 3
1 Solution
 
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
 
SiddharthRoutCommented:
In that case see this link. It will save you hours of manual entry :)

http://www.onlineocr.net/

Sid
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
mcrmgAuthor Commented:
Can ABBY do batch files? What is the type of output files?  thanks
0
 
SiddharthRoutCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now