Forum Discussion
Solved
Importing data from excel to multiple pdf files
I have a scenario here, hope someone can help: 1) 5 columns of data from excel 2) 100 individual pdf files I would need to import the 5 column data into the individual pdf forms, it is possib...
Hi WISM
Power Query is not a right tool to do that job. You could try other tools or methods, for example:
Automatically fill and send 1,000 PDF forms with Excel data [Step-by-step Guide 2021] - YouTube
How to AUTOMATICALLY Fill PDF Forms Using Microsoft Excel in 1 CLICK - YouTube
Fill a PDF Form with Microsoft Power Automate — Encodian
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
there is a new option in 2023, much simpler, no coding required - Power PDF Filler Add-in for Microsoft Excel
https://appsource.microsoft.com/pl-pl/product/office/wa200005545?tab=overview&exp=kyyw
5-min video walkthrough: https://www.youtube.com/watch?v=w6h7s8COkXA
Hope this helps!