Solved

OCR to excel

Posted on 2011-02-11
9
494 Views
Last Modified: 2012-05-11
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
Comment
Question by:mcrmg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34873437
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
 

Author Comment

by:mcrmg
ID: 34873507
I dont have that yet. Users have to open pdf and do the data entry.  thanks
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34873534
In that case see this link. It will save you hours of manual entry :)

http://www.onlineocr.net/

Sid
0
Technology Partners: 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!

 

Author Comment

by:mcrmg
ID: 34873537
Can ABBY do batch files? What is the type of output files?  thanks
0
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 250 total points
ID: 34873571
0
 
LVL 9

Expert Comment

by:suvmitra
ID: 34873582
Try www.verypdf.com/pdf2txt/pdf-to-excel.html ... it is what big organisations use for their daily processing job.
0
 

Author Comment

by:mcrmg
ID: 34873595
the pdfs we received are image based.  verypdf seems to work well with text based pdf.  thanks

0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34873606
ABBY is the best OCR software as of date.

Sid
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34873621
Why don't you download a trial version and check it out yourself ;)

Sid
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This video Micro Tutorial is the second in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles a…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question