Thread: pdf to excel
View Single Post
  #2  
Old 29th July 2002, 01:15 PM
Equine Investor Equine Investor is offline
Member
 
Join Date: Jan 1970
Location: Melbourne
Posts: 740
Default

If the data is in table form in pdf then here's what to do...

Firstly you need more than the Acrobat Reader, you need the full Adobe 5 program.

In Adobe Acrobat 5.0, open the PDF document. Make sure you are working in Adobe Acrobat 5.0, as opposed to the Adobe Acrobat Reader.

NOTE: PDF documents on the Web open in the Reader, even if you have Adobe Acrobat 5.0 installed on your workstation. If you would like to export a table from a document on the Web, you must first save the PDF document within your browser (Select File -> Save As... etc.) and then open it in Adobe Acrobat 5.0.

From the main toolbar, select the Table/Formatted Text Select Tool (or click Shift+V). This tool's icon, , will appear in the main toolbar once it has been selected from the drop down menu.

NOTE: If you prefer to export a column of data as opposed to an entire table, you can use the Column Select Tool as opposed to the Table Select Tool and continue with the instructions.

Select the table that you would like to export by clicking and dragging a box around the table.
Right click within the box. A menu window will appear.

Make sure that the Table option is checked.
Select Save As…from this window (select Copy if you are using the Column Select Tool).

Select a file in which to save your table, and type a name for the file containing your table. In the Save As Type window select ANSI Text (*.txt) and click on Save.

Now minimize Adobe Acrobat 5.0 and open Excel.
In Excel, select File -> Open….
In the Open window, make sure under Files of Type: Text Files is selected. This way you will be able to see your .txt document.
Select your table.
Select Open.

The Text Import Wizard window will appear.
Observe the Preview of File window. View the entire table by scrolling to the bottom of the file.

Hope this is not too confusing and remember you need the full program not just the reader.

Cheers.

Reply With Quote