Possible to import pdf data onlin into excel? [Solved/Closed]

- - Latest reply:  Rajesh - Mar 6, 2014 at 06:51 AM
Hello,

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!
See more 

7 replies

Best answer
9
Thank you
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 http://www.business-spreadsheets.com/forum.asp?t=884.

Thank you, Russ 9

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2635 users this month

Ambucias
Posts
50333
Registration date
Monday February 1, 2010
Last seen
November 22, 2018
-
Hi Russ

Too much! Thanks
Really nice one ...
Posts
1
Registration date
Monday December 12, 2011
Last seen
December 12, 2011
1
Thank you
I use EDI Link Connect. It will convert a PDF (like an invoice or Purchase Order) into a file that can be used with Excel, Quickbooks or Simply Accounting. It was designed for people who do more than about 2 hours/month of inputting data from a PDF. Works great for converting Invoices & Purchase Orders into Excel files or compatible with Quickbooks & Simply Accounting. Here is an article about it for more info:

http://softertech.wordpress.com/2011/12/12/importing-pdfs-into-quickbooks-or-simply-accounting

Its not free since its not for personal use but rather for businesses who want to save data entry and errors.

Hope that helps.

Kevin.
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
0
Thank you
there are third party software for converting pdf to excel. some of them priced. some free on trial. I could not find completely free software.

make a google search.
0
Thank you
Use this online site to convert pdf documents into excel


http://www.pdftoexcelonline.com/

best regards
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
0
Thank you
carlos cuervo

thanks I shall try that
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
0
Thank you
Russ thanks I shall try.
0
Thank you
Russ, Excelent work