Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

converting PDF to Excel

Status
Not open for further replies.

debbz82

Technical User
Nov 25, 2003
1
US
Hi~ I don't have the Adobe Acrobat 5.0 software, just the Adobe Reader. I was wondering it was possible to convert a PDF file into a EXCEL spreadsheet using Adobe Photoshop?
Thanks

Debbie
 
My goodness - why would you even consider using Photoshop????

Assuming the contents you want to transfer from the PDF to Excel is data in columns and rows (otherwise, why would you be going to Excel?) then...

In the Reader, you have the 'Column Select Tool'. Use this to select columns of data, then copy and switch to Excel and paste into a cell at the top of the column. You cannot do any more than one page at a time (gets too messy) and if you try and select more than one column of the PDF at a time, it gets put into the one column in Excel.

There was another thread which discussed this some time back and I will try and find it.
 
Have a read of this thread: thread223-514652 other important thing is to have the format of the cells into which you are pasting the PDF data set to TEXT. Otherwise some very weird changes can occur to the data.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top