Tony Giangreco
asked on
Extract the text data from 200 PDF files and insert it into an Excel spreadsheet
I have over 300 one page PDF reports relating to information on vehicles. They are all the same format except for the vehicle information. None of them are written on or stamped.
I have Win7, Adobe Acrobat 9.0 and office 2013. How can I extract the data fields from each page and insert it into an excel spreadsheet or CSV file for Excel?
I'm thinking some Visual; basic code may help, but I'm not a VB programmer.
Thanks in advance!
I have Win7, Adobe Acrobat 9.0 and office 2013. How can I extract the data fields from each page and insert it into an excel spreadsheet or CSV file for Excel?
I'm thinking some Visual; basic code may help, but I'm not a VB programmer.
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Let me append my last comment... there may be a tool or method, but I am not aware of one to do exactly what you want.
ASKER
I've been on another project and have not been able to test the suggested solution. I should be able to try it out by Wednesday. I'll let you know what happens.
Sorry for the delay in response.
Sorry for the delay in response.
ASKER
Thanks
There is a tool/software I found that can parse out specific areas of the PDFs pretty quick, with a free-form selection of the area you want to extract the data from. Once you set the "rule" you just upload all the files you want to extract the data from, or if they are inbound emails delivering the attachments, you can just forward them to the software to get the same results. The solution is a pdf parser called docparser.
ASKER
Is this the functionality Acrobat 11 provides? Would I need a specific version?