These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Copy a multi page pdf into an excel spreadsheet

Forum Index > General Acrobat Topics > Copy a multi page pdf into an excel spreadsheet
2007-09-26 11:38:00
petermb72
Registered: Sep 26 2007
Posts: 4

I want to be able to copy a complete multi page pdf file and insert it into an excel worksheet. I can only seem to get the first page, and if I do an export, I will get multiple files, one for each page. I want an easy way to just copy and paste an entire pdf into excel. Any help would be great!!

Thanks,
Peter

Top
2007-10-01 08:38:41
#1
petermb72
Registered: Sep 26 2007
Posts: 4
I am still looking for a way of doing this. Any Ideas???
Top
2007-10-01 15:30:23
#2
tedpadova
ExpertTeam
Registered: Dec 31 2005
Posts: 848
To copy data from multiple pages you need to view the PDF in a continuous page view. Ity's best to soom out a little after changing the view to see a few pages in the document pane.

Use the Select tool and drag from the top of the first page and drag down. Pages with automatically scroll until you reach the end of the document. Then you can use Edit > Copy.Be aware that copying an entire document unless it's one continuous table may not paste the way your want in Excel. If you have problems getting data in the right cells, first paste in Word and format the table. Then open the Word file in Excel.

Hope this helps.

ted

The author of numerous books on Acrobat, Photoshop, Illustrator and the Adobe Creative Suite, and an international speaker on Adobe Acrobat, Ted Padova is a well-known PDF guru.

Top
2007-10-01 16:14:36
#3
tedpadova
ExpertTeam
Registered: Dec 31 2005
Posts: 848
I should also mention that you can click anywhere in the PDF when viewing in a continuous view and press Cmd/CTRL + A to select all.

ted

The author of numerous books on Acrobat, Photoshop, Illustrator and the Adobe Creative Suite, and an international speaker on Adobe Acrobat, Ted Padova is a well-known PDF guru.

Top
2007-10-04 08:32:57
#4
petermb72
Registered: Sep 26 2007
Posts: 4
Still not working, I still cannot select more than one page. What could I be doing wrong?
Top