Importing data from excel to multiple pdf files

[WISM]

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 possible?  

I try to google for answer for an hour and could not find anything, hope, experts can help here.  Many thanks

[Anonymous]

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!

[v-jingzhang · Accepted solution]

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

Populating a pdf form with from a table in excel or power bi using desktop power automate - Power Pl...

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[mahoneypat]

This sounds like a job for Power Automate Desktop.  I haven't done what you are asking, but just pointing you to the right tool for the job IMO.

Pat