Forum Discussion
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 possible?
I try to google for answer for an hour and could not find anything, hope, experts can help here. Many thanks
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.
4 Replies
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
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!
Power Query itself is not designed to write Excel rows into PDF forms.
If the 100 output PDFs use the same form or template, with one Excel row corresponding to one completed PDF, a browser-based PDF mail merge workflow can handle this without VBA or Acrobat:
1. Upload the Excel or CSV file
2. Upload the fillable or non-fillable PDF template
3. Map the spreadsheet columns to the PDF fields or page positions
4. Preview the rows and export one PDF per row or download the batch as a ZIPFull disclosure: I am the developer of Sheets To Labels. The workflow is available here:
If the 100 PDF files all have different layouts, each layout would need its own mapping, or you would need a more customized/API-based automation workflow.
