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

Cleaning a PDF for Export to Excel

arpreiss
Registered: Jul 3 2007
Posts: 2

I am trying to use Omni Page Pro 15 or the accompanying pdf Converter to drag tables out of a pdf file into excel. Some of the column lines in a few of the tables are a bit light and Omni Page doesn't pick them up and consequently puts two horizontally adjacent cells into one cell.
 
What is the best way to clean the pdf to avoid this. I have tried everything I can think of. I am fairly new to this.
 
Oh, small side note, I would like to find a command to do it instead of the "Draw Column Line" command in Omni Page as I have 1,000 sixty page pdf files to do this to a month.
 
Thanks,
 
Artie

My Product Information:
Acrobat Pro 8, Windows
dbaker
Expert
Registered: Feb 10 2006
Posts: 413
Hi --

Here are a couple of ideas:

* You are going to have to check the Omni Page Pro documentation for assistance.

* If you are using Acrobat 8, select the table, right-click to display the shortcut menu and choose Export to Spreadsheet to open it in Excel.

donna.

A prolific author and writer of many Acrobat books, as well as books on graphic and Web design software.
Donna lives on a lakeshore in central Canada, where all manner of wildlife from muskrats to coyotes come to call.

abvjav
Registered: Nov 10 2008
Posts: 7
There is a service available at http://www.reportminers.com/ which will convert your pdf files to excel.