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

Selecting Table

vr1001
Registered: Mar 27 2007
Posts: 2

How to select a column from a PDF table and copy it into Excel? I used to do it easily in Acrobat version 6; I don't see an icon for "Select Table".

My Product Information:
Acrobat Pro 8, Windows
tedpadova
ExpertTeam
Registered: Dec 31 2005
Posts: 848
When you use the Select tool and select table text. your options include Copy As Table, Save As Table, and Open Table in Spreadsheet. These options appear in a pop-up or context menu.

A problem you may encounter when trying to copy or export table data is that Acrobat may not recognize your table as table data. Inasmuch as you're looking at a table, it may have been formatted in the authoring program in such a way that Acrobat can't see the data as a table or the file may not be tagged properly.

As a workaround, you can select the text with the Select tool and choose Copy with Formatting from a context menu. Paste the copied text in Word and it should be reconized as a table. You can then get the Word data to Excel if you want to work with it in a spreadsheet. (Note that pasting directly from Acrobat to Excel most likely won't work —you first need to go through Word).

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.

sierrachang
Registered: Jun 19 2007
Posts: 3
The main problem is the convience of the Table Select tool seems to be missing. Is there anything that forces Acrobat to select text from only a specified area? For example, in the table below, I am able to select text, but when pasted it shows up as "Data from 5 1998-2000 Data from 10 2001-2005". I used to be able to at least select it by column. Now I have to hope that Acrobat can recognize it as a column. Is there any equivalent to the user-defined Column and Table select tools? It seems silly that I have to break out the Adobe Pro 5.5.

YEARS Number
Data from 5
1998-2000
Data from 10
2001-2005
tedpadova
ExpertTeam
Registered: Dec 31 2005
Posts: 848
Press the Control (Win) or Command (Mac) key and you can select columns and rows.

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.