Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

OCR to excel

Posted on 2011-02-11
9
Medium Priority
?
511 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

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

609 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