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?
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.