David M
asked on
PDF to Excel
I have about 200 PDF files with a bunch of data in them.
Sadly the data isn't in a table but it is copy and paste able.
I want to be able to convert these PDF files into a table.
My assumption would be to run a query on the PDF file in String format and say when you see the character: Collect the next several characters and place them into a table/CSV/Excel.
My question is this probably has been done before like 1000 times.
rather than re-inventing the wheel does anyone here have a tool or similar described above that can export PDF filed based upon string query's?
Sadly the data isn't in a table but it is copy and paste able.
I want to be able to convert these PDF files into a table.
My assumption would be to run a query on the PDF file in String format and say when you see the character: Collect the next several characters and place them into a table/CSV/Excel.
My question is this probably has been done before like 1000 times.
rather than re-inventing the wheel does anyone here have a tool or similar described above that can export PDF filed based upon string query's?
ASKER
I have used a feature in Adobe Acrobat X pro to convert the PDF files to TXT.
Now im writing a powershell script to extract the values i need to CSV.
Now im writing a powershell script to extract the values i need to CSV.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would just subscribe to Adobe ExportPDF (it's like 20$/years) which allows you to batch convert PDF to Word/Excel by logging to the cloud service : https://cloud.acrobat.com/exportpdf
In the "Select Files to export" window, you can drag multiple files, convert them all at once, and download the result as a zip file (every PDF file in its own Excel file).
Not sure you can find text in a PDF file the way you intend to do.
Regards,
Sylvain