PDF file to Excel

[djh]

I have a PDF file that I would like to work with in Excel. Any
recommendations for converting the file?

 

[garfield-n-odie]

If you have the full version of Adobe Acrobat (not just the free
Adobe Reader), then you can use the Select Text tool in Acrobat
to copy text from the PDF file, paste the copied text into Excel,
and then use the Data->TextToColumns command in Excel to parse
the pasted text into columns.

 

[Bernard Liengme]

And if you do not have the full Adobe version you can use an OCR program to
scan the printed version (sometime the PDF file itself) into a text file.
Open in Excel and use Data|Text to Column
best wishes

 

[JoAnn Paules [MSFT MVP]]

As you've seen, it's not a simple procedure. Plus you need third-party
software - preferably Acrobat.

 

[Harlan Grove]

garfield-n-odie wrote...

If you have the full version of Adobe Acrobat (not just the free
Adobe Reader), then you can use the Select Text tool in Acrobat
to copy text from the PDF file, paste the copied text into Excel,
and then use the Data->TextToColumns command in Excel to parse
the pasted text into columns.

There's also a shareware product called PDF2Text, which is MUCH CHEAPER
than Adobe Acrobat standard (there are now many levels of 'full'
Acrobat though not as many levels as there are of Office). There's also
an OLD freeware utility still available at

http://www.pricelesswarehome.org/2003/PL2003TEXT.htm

(Simtel used to have it, but Simtel now carries the LATER shareware
program of the same name). Finally, GhostScript (free software) will
also read PDF files and can convert them into other formats.

Why do so many people only offer suggestions that will cost $$$?