?
Solved

OCR to excel

Posted on 2011-02-11
9
Medium Priority
?
502 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
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

 

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 1000 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This video Micro Tutorial is the first 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 al…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

762 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