Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting PDF to Excel

Status
Not open for further replies.

Morty24

Technical User
Aug 9, 2006
2
US
Not sure if this has been asked before, but is there any way to convert a scanned PDF to excel?
 
Hi,

What's a "scanned" PDF? How is that different from a PDF?

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
A Scanned PDF is a document that has been scanned and saved as a PDF document
 


Is it significant to this question, that it was scanned?

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
google > "convert pdf to excel" = answer

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
What you need is an OCR reader (Optical character recognition, conversion of images of text into characters). Most printers should come bundled with some type of software to do this

Failing that ABBYY PDF Transformer 2.0 is very good for what you need but costs £.

Failing that this is a possibility and free: OCRopus is a free document analysis and OCR system
 
If what you have will fit on a screen, you can do a print screen, paste that into MS Paint or some other graphics program, Save As a .tif then open the .tif in Microsoft Document Imaging which you almost certainly already own.

In the Tools menu are the commands to run the OCR and then the command to send to Word.

--Lilliabeth
 
If you have full version of Acrobat, you can use use Document, Recognize Text Using OCR. However, it doesn't seem to always capture/convert all the items. Perhaps the current version is better. I'm using 7.
 
If you can export the PFD as text, do so. Then open the text file in Word and use 'Replace' to turn spaces to tabs, ^t for Replace in Word. Then make a Word table. This can be pasted into Excel.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top