Copy tables from PDF to EXCEL

Hello, I have some pdf files with lots os tables in it, but i need to use them in EXCEL... I've tried to copy it and paste into WORD to "convert text into table", but im having a hard time... I've attached one of the pdf files here as example...

Im using OFFICE 2007.
Relatorios-P2.zip
MelissaCGAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nike_golfCommented:
PDF's are designed t obe an '"end document" so converting back to something usable has some interpretation issues.

You will able to copy paste some aspects of tables but a perfect conversion may not be possible.

I use a program called Able2Extract and it allows conversion to multiple formats with reasonable accuracy. I wish there was an easy answer for your problem but a conversion utility is where you are headed.

NG,
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MelissaCGAuthor Commented:
It doesnt need to be a utility, it can be a macro to split the columns or any other workaround, the important is that it should be a automatic, because there are a lot of pdfs like this one =/
0
nike_golfCommented:
Unfourtunately, reading/converting information from a pdf isn't as easy as writing a macro in most cases, Excel just isn't a file conversion utility. I think your going to have a hard time automating this process which is why I suggested you might consider using a PDF conver utility instead.

I converted your file using Able2Extract so that you could see the end results.

NG,
Book1.xls
0
MelissaCGAuthor Commented:
Well I just manged to do it by programming with another question in Delphi area...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_25961388.html

What shoukd I do with the points??
0
nike_golfCommented:
Not through Excel but through Delphi... so that really is your answer - it can't be done via Excel.

Essentially what you've done is converted a .PDF document with an external converter, as I suggested, so that you are able to import it into Excel.

Glad you were able to get your problem solved.

NG,
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.