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

Report
-
 Rajesh -
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!

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
9
Thank you

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

CCM 2845 users have said thank you to us this month

Posts
48725
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
June 23, 2020
15,374
Hi Russ

Too much! Thanks
Really nice one ...
Posts
1
Registration date
Monday December 12, 2011
Status
Member
Last seen
December 12, 2011

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:

https://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
791
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.

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
791
carlos cuervo

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