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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert PDF to Excel 2

Status
Not open for further replies.

cajunbob99

Technical User
Jan 28, 2008
2
US
Greetings all,

I hope I have posted this question in the right forum, if not, please let me know and I will move it accordingly.

I am working on a project involving several dozen PDF files containing some data in tables. I would like to be able to convert those PDF tables to Excel so that I can work with the data in Excel spreadsheets.

The PDF files are located on several research websites that all happen to use PDF.

I have Windows Vista Ultimate and I have a DELL Inspiron 9400. Presently I am using Adobe Reader 8.1 to read the PDF files.

I sure would appreciate some advice as I don't have weeks to manually load the data.

Thanks.

Bob
 
No way to do it without 3rd party software, sorry.

Google 'pdf to excel converter' for links.
 
Depending upon format, your might be able to simply copy and paste, then use Data | text to columns.

 
elsenorjose and mintjulep,

Thank you for taking the time to respond.

Mintjulep, your suggestion to use "Data | text to columns" would be more feasible if I had a few tables with a several lines of data, unfortunately I have dozens of tables and many lines, often in an inconsistent format.

I will likely try the the 3rd party software.

Thanks again!

Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top