I got a Certificate design as a PSD file. I have to add 1000 names to these Certificate! I have the Excel file of the names. Is there anyway that we can automate it using Photoshop? Maybe using Action or Batch?!

New contributor
ali jahromi is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Obligatory suggestion: You could also do this (data driven graphics / data merge) in Illustrator or even Indesign, both of which might be better for print and make your life easier but the benefit could also be negligible depending on things... Adobe documentation is pretty good, but to grasp the general idea youtube tutorials are probably better: Illustrator, Photoshop, Indesign (Skimmed through them without audio. Seemed to hit the main points)
    – Joonas
    Jan 14 at 7:06

Make a mailmerge document that is essentially blank but position the name field so that if the certificate image were placed there the name would be aligned correctly. Make the merge, export to PDF.

Open the PDF and apply the PSD as a watermark "100%" "behind text". If PSD cannot be placed, "save as copy" the PSD to e.g. TIF

Your Answer

ali jahromi is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.