?
Solved

pdf to excel

Posted on 2013-10-31
5
Medium Priority
?
476 Views
Last Modified: 2013-11-07
i have a scanned pdf document (source is just 100 sheets of paper) that i would like to convert to excel.

The trouble i am having is when i do the OCR function from adobe standard x it doesn't seem to pick up all the text correctly which makes for an ugly xlsx file.

Do any of you have any software that might do the trick or perhaps have some ideas to try?

I have been through multiple tutorials on the web and nothing seems to work well.  Thanks!
0
Comment
Question by:IKtech
  • 3
  • 2
5 Comments
 
LVL 58

Accepted Solution

by:
Joe Winograd, EE Fellow 2017, MVE 2016, MVE 2015 earned 2000 total points
ID: 39615142
I've had excellent results with this free online tool:
http://www.pdftoexcel.org/

It does a good (but not perfect) job of maintaining the formatting, which is always the trick with any PDF to Excel (or Word) conversion. I don't know if it will work well on your document, but it's worth a (free!) shot. If you do like it and would prefer a local install rather than the online tool, it is available for purchase and download (and it has a 7-day free trial):
http://www.investintech.com/prod_downloadsa2e.htm

Another product worth trying is A-PDF to Excel:
http://www.a-pdf.com/to-excel/index.htm

It's not free, but is reasonably priced at $39 USD, and it offers a free trial so you can see if it works on your doc before buying it. Regards, Joe
0
 
LVL 3

Author Comment

by:IKtech
ID: 39615340
so far so good i think you get the points Joe but i need to talk to the user that actually requested this what there thoughts are.  Thanks for the quick response.  Happy Halloween!!
0
 
LVL 58
ID: 39615353
Take your time...I'm in no rush for the points...make sure the user is satisfied. Happy Halloween back at you! May you have all treats and no tricks. :)   Regards, Joe
0
 
LVL 3

Author Closing Comment

by:IKtech
ID: 39632164
I ended up paying for the pro version of that software which saved us many hours!!!  Thanks Joe!
0
 
LVL 58
ID: 39632348
You're welcome...I'm glad you're happy with it. Free is always nice, but when you can save lots of time, spending some money is a wise move. Regards, Joe
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

599 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