Hi,
You can use itextsharp to read pdf files in PowerShell.
http://allthesystems.com/2020/10/read-text-from-a-pdf-with-powershell/
To add contents to an excel spreadsheet you can try the ImportExcel module.
https://www.powershellgallery.com/packages/ImportExcel/
https://adamtheautomator.com/powershell-excel/
Best Regards,
Ian Xue
============================================
If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.