Solved

OCR to excel

Posted on 2011-02-11
9
484 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
  • 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

I. Introduction In a previous article (http://www.experts-exchange.com/Web_Development/Document_Imaging/A_6537-PaperPort-Upgrade-How-to-download-and-install-updated-versions-of-PaperPort-11-and-12.html) (now deprecated), I discussed how to upgrad…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

828 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