Possible to import pdf data onlin into excel?

escapeqnim - Oct 12, 2009 at 09:56 PM
 Rajesh - Mar 6, 2014 at 06:51 AM

Does anyone know if it is possible to import pdf data from the internet into excel? Or do I need a special adobe acrobat program to do so?

Basically, I need to be able to automatically refresh data connected to pdf's online so that I can use that data in pivot tables. Examples of data I might use are coffee or sugar prices. Would I have any luck?

Thanks to anyone for helping!

7 replies

I have just created an Excel VBA routine that uses an open source PDF to text conversion utility and then imports data from multiple PDF files based on matching rules into a structured Excel table. You can download and use this for free at https://www.business-spreadsheets.com/forum.asp?t=884
Ambucias Posts 47357 Registration date Monday February 1, 2010 Status Moderator Last seen September 1, 2021 11,234
Jan 16, 2011 at 05:08 PM
Hi Russ

Too much! Thanks
Really nice one ...