Forum Discussion
Extracting tables from multiple PDFs
You might want to look into Power Automate Desktop. It will let you run actions with regular expressions on PDFs and extract tables to Excel. The regular expressions are what you use for things like "get this thing wherever you see the word xyz or where the text fits this pattern".
It's usually used for files on your PC, but you could probably sync the library from SharePoint or something to run it local (make sure to check in settings and tell it to pull it all down vs storing in cloud).
Hey Christine,
Thanks for the advice, sounds like a great idea. Something new to learn too!!
Sure! There's all kinds of AI solutions in the cloud too with AI Builder/Syntex, PAD is kind of the budget option. I only mention it because it's got a low barrier to entry because there's no need to request a license for it - usually it's already installed with Windows.