Link to home
Start Free TrialLog in
Avatar of David M
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?
Avatar of Sylvain Drapeau
Sylvain Drapeau
Flag of Canada image

Hey David,

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
Avatar of David M
David M

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.
ASKER CERTIFIED SOLUTION
Avatar of David M
David M

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial