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

PDF To Excel

preddy
Registered: Jan 21 2008
Posts: 2

I am a beginer, using Acrobat 7.0 Professional. I would like to export a 100 page pdf (contains 1 table) to excel. However I am able to get only the first page into excel. I have tried (1) Extracting the pages and using Accessibility, tagging the document (2) used Continuous page layout. Converting to MS word truncates the table and hence this option does not work. Someone mentions a 6-step process in the Forum, but I have been unable to find this.

Any help would be greatly appreciated

My Product Information:
Acrobat Pro 7.0, Windows
matchley
ExpertTeam
Registered: Feb 9 2006
Posts: 27
Preddy
This 100 page pdf, it contains 1 Excel table, and that table is part of each of the 100 pages?

If so, I'm not sure that exporting this PDF will result in what you want. Might be easier to track down the originator of the file.

Mark

Mark Atchley mark [at] printoptionz [dot] com
415-388-7040 office 415-860-3224 cell
Adobe Certified Expert – Adobe InDesign CS2
Adobe Certified Expert - Acrobat 7 Professional

mjbreunig
Registered: Jan 4 2008
Posts: 6
I have copied many pages of table data from a PDF file to an Excel spreadsheet, one page at a time. In Acrobat, use the Select Text tool to highlight table data on one page. Right click and select the Copy as Table choice. Switch to the Excel worksheet, select the first cell for the copied data, then press Ctrl+V. If the table columns are not well defined in the source PDF, you may have to do some cleanup in Excel after pasting.
pitics
Registered: Feb 7 2008
Posts: 9
hi mjbreunig
i have try your suggestion but it only owrks well on the first page only.
i cannot find the Copy as Table choice menu on the next page. what's wrong?

i am a freelance graphic designer, and now working for UNESCO.