Adobe Acrobat

2007-06-01 19:29:00

Kyleca1

Registered: Jun 1 2007

Posts: 3

Hi,

I have Acrobat Professional 8 and Microsoft Excel 2002 (SP3). I get PDF files that contain what looks like to be tables on several pages that contain columns of numeric and text data.

I would like to get this table information into MS Excel, so I can produce graphs on the data.

Whenever I try to do a cut and paste or an export and then put it in Excel, it includes garbage data as well as the data I want and is not in any fixed delimited form that I can use.

Some rows do not necessarily have data in the table columns.

Anyone know how I can get the data from these tables (on several pages) into Excel without the garbage (might be the column separators) and having an Excel Column for each table column?

I see there are many products you can buy, but I was hoping there was a way to do without purchasing another product or having to be an expert at Excel.

Thanks,
Kyle.

2007-06-09 15:20:38

[email protected]

Registered: Sep 24 2005

Posts: 252

You can highlight the text and then either copy as table or open in spreadsheet from Acrobat ...

Jon

I've been using Acrobat since v1.0 and still get amazed by its power. An Acrobat ACE since 1999

2007-06-11 18:51:14

Kyleca1

Registered: Jun 1 2007

Posts: 3

Hi jon,

Thanks for the information.

Unfortunately I have already tried this, as well as exporting or saving in different formats and they all add varying amounts of the following characters to the begining of each line and also combines multiple rows of the table on a single line.

ÒÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÅÒ Ò Ò Ò Ò Ò Ò Ò

Because of the large amount of table data I have, manually editing the text to add the commas would take a very long time. Even if I was able to get ride of the above show characters.

I would like to be able to take the entire PDF that has tables on multiple pages and get them into Excel in just a few steps.

have tried the Column Select Tool (even though I need a whole lot more) and it stills seems to give me the garbage characters and more than one column of the table.

If any of you are a Sprint cell phone customer and know how to get to the Bill Archiving on the Sprint web page, that produces a PDF version of your bill details and the phone call details tables in that PDF is what I am trying to get into Excel.

Any other suggestions?

Thanks,
Kyle.

2007-06-17 05:33:50

[email protected]

Registered: Sep 24 2005

Posts: 252

Try the 8.1 update - see if this helps the situation

Jon

I've been using Acrobat since v1.0 and still get amazed by its power. An Acrobat ACE since 1999

2011-06-14 16:29:34

rsanagustin

Registered: Jun 14 2011

Posts: 1

Hello,

I am currently having this exact same issue with converting PDF to Excel. Did you ever find a solution? I'd really appreciate it. Thanks!

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

How to get PDF tables into Excel