Importing Data from PDF Files

Excel Help for Importing Data From Pdf Files in Developing Business Administration Solutions

Importing Data From Pdf Files

Rate this: (4.2/5 from 24 votes)

	Business Spreadsheets has developed a free Excel program to extract and import PDF data into Excel which can be downloaded and used without restriction. There is a common need to extract and import specific data from PDF files into Excel. Since Excel does not natively support the reading of PDF content, utilities are needed to convert the PDF file content for the Excel format. Several commercial applications accomplish this; however it is often the case where only specific data is required to be imported from multiple PDF files into one structured format. We created such an application by using VBA code in conjunction with an open source PDF to Text conversion utility, which can be found at Foolabs. [Download the free PDF data import Excel program here] The program relies on the conversion utility (included in the download) and all PDF files to reside in the same directory as the Excel application. Text or data to extract are defined in the Control sheet by specifying start text, end text and multiple replacements routines with wildcard support. This enables flexibility to obtain comparable data from multiple PDF files based on patterns independent of different PDF file structures. As many extraction rules as required can be set in order to create a table of information imported by extraction rule and PDF file name. Information on how to set up rules is available within the Excel application with a help icon and cell comments. The VBA code is commented and open for modification. Any improvements or new features to the code are welcome to be posted here so that we can update the download version to the benefit of everyone.
	Excel Business Forums Administrator
	Posted by Excel Helper on 17 Jan 2011

Replies - Displaying 21 to 30 of 88

Order Replies By: Most Recent | Chronological | Highest Rated

	Thanks for you help Rate this: (3/5 from 1 vote) Thanks again. And yes there is more text on that same line after the %, i.e., the % is not at the end of the line. Could you please elaborate more on where to insert this formula. I appreciate it.
	Posted by bunjaby on 09 May 2014

	Thanks for you help Rate this: (3/5 from 1 vote) Never mind, I see what you're saying. But is there a way to do it without this formula. it will save me a step. Please let me know. Thanks
	Posted by bunjaby on 09 May 2014

Please help - it seems not be able to read my pdf file Rate this: (3/5 from 1 vote) Hi there, Firstlty, I would like to thank you for a really nice tool. I have tried it with your test files successfully but it doesn't work for for my own pdf file - The result is always empty...I already put the pdf file on the same folder like you said. My pdf is here: https://drive.google.com/file/d/0B822d4OBtHm5Mi1hM0dMaW1LMzg/edit?usp=sharing I tried different rules like your instructions but the result is always empty...Could you please review my case and give me your advice? Thanks a lot. Neo.

Posted by neoxman on 14 May 2014

	file name is lower case but still not working... Rate this: (3/5 from 1 vote) Dear admin, I already changed the file name to lowercase but I am sorry...the result is still empty. For your advice. Thank you. neo.
	Posted by neoxman on 15 May 2014

Re.: Personal Details From File Rate this: (3/5 from 1 vote) Dear Admin, I did follow your suggestion but it's still empty. Now I am sharing with you my rule definition: Start Text End Text Replacement Pairs PERSONAL INFORMATION  STRENGTHS AND ABILITIES  PERSONAL INFORMATION,|STRENGTHS AND ABILITIES,   I also share the excel file with you, so you can review: https://drive.google.com/file/d/0B822d4OBtHm5ckN2Z3FzUnNNX2s/edit?usp=sharing For your advice - thanks a lot. neo.

Posted by neoxman on 14 May 2014

Help needed Rate this: (3/5 from 1 vote) Hi, I would need tow help here. 1) For me replacement text is not working fine. For Eg: My start text is :Receiving Office Engagement Number" which is simlier in most of the PDF .but few PDF have as "Receiving office codeblock" or "Engagement Number" SO it is not piking for those PDFs. How do i put the replacements ? 2)My PDF has Number is multiples palce. Eg: Number ;ABC123 is in several place in my PDF si the out put is giving 3 to 4 lines.So i would need it to pick only once. How do i change the code ? Regards, Vijeth

Posted by vijethbangera on 01 Jun 2014

	Multiple Text Rate this: (3/5 from 1 vote) Its Reflecting like this , A B C 1 IE0100110681 Invoice Number IE0100110681 IE0100110681 Invoice Number IE0100110681 Total Due 7,250.00 IE0100120921 Invoice Number: IE0100120921 IE0100120921 Invoice Number: IE0100120921 2 3 So Now what i need to do ? I dont need it to Come in two Line... Could you please aso help me whcih a eg if Input ?
	Posted by vijethbangera on 01 Jun 2014

	nice! Rate this: (3/5 from 1 vote) thats a real nice program! congrats i want to make my own website (something like http://exceltopdf.org/ ) maybe you can give me some tips on how this works :D
	Posted by ShandyLover on 07 Sep 2014

	Multi Colum Extract Rate this: (3/5 from 1 vote) Is it possible to amment the script to allow multiple columns to be extracted from the pdf. e.g. invoice lines?
	Posted by ExcelMaster on 21 Apr 2015

	importing data from pdf which i open Rate this: (3/5 from 1 vote) hi all, This tool works perfectly. Is there a way to import data of only specified pdf in different location. while importing i should have option to select the pdf from a folder in another location other than the activeworkbook "import pdf to excel" sheet included folder.
	munna
	Posted by munna on 03 Nov 2015

Back

Displaying page 3 of 9

Next