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

convert pdf to excel spreadsheet in adobe acrobat 9 extended

melbrock12
Registered: Aug 18 2010
Posts: 2

does anyone know how to convert an existing pdf to an excel spreadsheet in the trial version of adobe acrobat extended?

My Product Information:
Acrobat Pro Extended 9.0, Windows
daka630
Expert
Registered: Mar 1 2007
Posts: 1420
First, confirm that you do not have a scanned image and nothing else.
If only an image then there is nothing to "export" out other than the image.

Note:
Having a well-formed Tagged PDF makes a difference when moving tabular content to a spreadsheet.

Here are somethings suggested by others that you may wish to try:

Quote:
File > Save As menu in Acrobat 9, there is an option to Save as Type: "Tables in Excel Spreadsheet (*.xml)". This will help you export to Excel.You can highlight the text and then either copy as table or open in spreadsheet from Acrobat ...

Select the table, right-click to display the shortcut menu and choose Export to Spreadsheet to open it in Excel.

In Acrobat go in the "FILE" menu, choose "EXPORT" and then "export multiple files".
In the batch window add your files and then in the OUTPUT OPTIONS select "Tables in Excel Spreadsheet" as output format.

Shift and select a column to transfer (right click for the context menu that provides choices).
~ n.b., the below discussion is also applicable to Acrobat 9 ~

Quote:
Use Acrobat Pro 8 with all updates.
Go to a single page continuous view.
View > Page Display > Single Page Continuous
Drop the document zoom low, say 25%. This makes the area you must select smaller.
View > Zoom > Zoom To - enter zoom value > OK
Make the Select Tool active
Tools > Select & Zoom > Select Tool
With the Select Tool, select the first page.
Top left to bottom right.
Place cursor (still having Select Tool active) on high lighted content in a cell on page 1.
Right click with mouse. The Context menu is presented.
--| Context Menu choices
--| Copy
--| Copy with Formatting
--| Copy As Table
--| Save As Table
--| Open Table in Spreadsheet
--| Select All
--| Deselect All
--| 5 entries associated with Comments
--| Add Bookmark
Select Open Table in Spreadsheet.
A *csv file is created by Excel.
or
Select Copy as Table, Paste copied content into Excel cell.
Repeat for each page. Use Excel to aggregate the pages.
Save to *xls file.

I have tried, on multi-page PDF from Excel, to select all pages.
That works. However, only the page in which I place the cursor (in order
to get to the context menu) goes to the Excel *.csv file.
A plus, as long as a number of pages are selected, you can
process each in turn rather than have to recommence selection for each page.

It works quite well, one page at a time.
A link to a PDF, at acrobat.com, with a Captivate video demonstration:
[url=https://acrobat.com/#d=zOS8WOBJxmjlD*StHkU6aA]PDF to Spreadsheet[/url]

Be well...

Be well...

TonyPotter
Registered: Feb 1 2010
Posts: 85
Why not try to use PDF to Excel Converter, which is also a good way to export pdf to excel. By the application, you can do the work automatically.

I will try my best to help you in PDF converison fields, objectively and Neutral.