• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Download a batch of PDFs and translate them into excel?

pete6032

pete6032

Diamond Member
Multi part question.

I need to do some analysis on some contracts that are all uploaded as single PDFs online. The PDFs list things like name, date, dollar amount etc. They are not in a table in the PDFs but they are on the same spot in each PDF. Is there any way I can download all the PDFs at once and then get the data into excel? Or do I need to manually key everything and get the PDFs one by one. There are about 500 contracts i need to review with each being about 5 pages.
 
Have you read the following link?

http://www.wikihow.com/Create-an-Excel-Spreadsheet-from-a-PDF-File

There are products out there and we've used products from a company called Datawatch to do what you are doing. However we are doing a LOT more than what you describe and it may be expensive overkill in your case.
They do have a 14 day free trial if you want to try out the desktop piece.
You build a model that will "trap" the fields you want to capture and then just apply to the files.

http://www.wikihow.com/Create-an-Excel-Spreadsheet-from-a-PDF-File
 
It would be simpler to just get the originals from the other person/company in Excel format, but the link that pauldun170 posted should work if you can't get the original documents.
 
Parsing PDFs is a tricky thing to do. Depending how the PDF is structured, it might be easy or impossible.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top