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

escapeqnim - Oct 12, 2009 at 09:56 PM - 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 

9 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

Something to say? Add comment

CCM has helped 1667 users this month

Ambucias 53303 Posts Monday February 1, 2010Registration dateModeratorStatus July 21, 2018 Last seen - Jan 16, 2011 at 05:08 PM
Hi Russ

Too much! Thanks
Really nice one ...
pdf_guru 1 Posts Monday December 12, 2011Registration date December 12, 2011 Last seen - Dec 12, 2011 at 03:51 PM
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.
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Oct 12, 2009 at 10:44 PM
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.
Carlos Cuervo - Oct 19, 2009 at 05:03 PM
0
Thank you
Use this online site to convert pdf documents into excel


http://www.pdftoexcelonline.com/

best regards
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Oct 19, 2009 at 08:38 PM
0
Thank you
carlos cuervo

thanks I shall try that
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Jan 16, 2011 at 08:11 PM
0
Thank you
Russ thanks I shall try.
0
Thank you
Russ, Excelent work