D
djh
I have a PDF file that I would like to work with in Excel. Any
recommendations for converting the file?
recommendations for converting the file?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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.
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.
B
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
scan the printed version (sometime the PDF file itself) into a text file.
Open in Excel and use Data|Text to Column
best wishes
J
JoAnn Paules [MSFT MVP]
As you've seen, it's not a simple procedure. Plus you need third-party
software - preferably Acrobat.
software - preferably Acrobat.
H
Harlan Grove
garfield-n-odie wrote...
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 $$$?
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 $$$?