.pdf to excel

chneby · Sep 17, 2006

Hi

I regularly get a list of information sent to me in Excel format which I cut and past into a master list.

The sender has now seen fit to send this info as a pdf file.

Is there any way of being able to cut and past or whatever from the pdf list to excel whether it be directly or into word and then excel etc.

It would be great if I could.

Regards

DavidGP · Sep 17, 2006

You can copy and paste the info from a .pdf, however it doesnt always format correctly when pasting into Word or Excel, but try this and see......

Acrobat Reader free is I guess what your using?

Open the .PDF and choose the Select tool > highlight the text you want > rigth click the highlighted text and choose Copy to Clipboard then paste into your Excel spreadsheet ( or use a new blank workbook to test if the copy and paste works ok )

Note: it will not copy any gridlines or images, only text.
Acrobat Pro version gains an option to Open table/selected text in Spreadsheet directly and also a Copy as Table option which is handy for Excel docs.... sadly Acrobat Pro costs $£$£

This app which I've never used does allow you to freely convert PDFs to Text or Word Doc formats http://www.majorgeeks.com/download.php?det=4511 ( do read the advertising notice tho to this free software )

other thought is have you asked the sender to possible re-send the data in Excel format again rather than PDF?

montecristo314 · Sep 17, 2006

I'm not sure what type of data it is, but you could try to copy it into Notepad, save it, and import it into Excel as tab- or comma-delimited text. Not as fast or easy as cut-and-paste, but would be effective.

Log in or Sign up

.pdf to excel

chneby Private E-2

DavidGP MajorGeeks Forum Administrator - Grand Pooh-Bah Staff Member

montecristo314 Private E-2