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

Question

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!

Russ · Accepted Answer

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

venkat1926 · Answer

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 · Answer

Use this online site to convert pdf documents into excel


http://www.pdftoexcelonline.com/

best regards

venkat1926 · Answer

carlos cuervo 

thanks I shall try that

venkat1926 · Answer

Russ thanks I shall try.

Sunil · Answer

Russ, Excelent work

pdf_guru · Answer

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.

Possible to import pdf data onlin into excel?

7 responses

Similar discussions

Subscribe To Our Newsletter!