Converting PDF to Excel

S

SBSP

Senior Member
Joined
Sep 7, 2007
Messages
667
Reaction score
16
I have a few users who needs to convert PDF documents into excel.

The PDF's that are getting seems to converted with Vectors and searchable text (Not just an image converted to PDF)

Whats the easiest way to get it onto excel ? It doesnt have to do a perfect Job.
Copy and paste doesnt work so well. And the Source cant send it in Excel only PDF
 
Open the file in acroread, choose Save as Text from the menu.
Open text in excel.

No idea if this will work for you but it is one way.
 
Thanks just tried, It dumps everything into 1 column

Does Acrobat Pro have excel capabilities ?
 
SBSP said:
Thanks just tried, It dumps everything into 1 column

Does Acrobat Pro have excel capabilities ?
Click to expand...

Yes it does

Also make sure you have selected continuous view rather than single page view when trying to copy paste. That helps sometimes
 
Are there delimiters? If so, you can use the text-to-columns function on Excel.
 
In my experience you'll never get any satisfactory results with the tools out there. I had to convert bank statements a couple of years ago and I eventually did the following:

Bought this utility: http://www.a-pdf.com/text/cmd.htm (was $10 way back, see its $35 now)
Run it and get a text file with each text element and it's coordinates (i.e. Text = "MyText" x=10 y=200 page=1 or something along the lines)
Write an app that knows where columns in tables are (i.e. first column is between x=10 and x=80, second column is between x=90 and x=120 etc.)
Loop through all the text elements and filter it out, write it to a CSV and import it into Excel.

Works well enough although its a lot of work.

Edit: I see they have more tools, perhaps there's something you can use!
 
Hi. Try Nitro PRO. There are trial versions of their products. Works quite well and saves PDF's to most common formats like Excel, Word etc
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X