Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

I have over 500 pictures that I need to watermark with text that will be differe

ID: 661464 • Letter: I

Question

I have over 500 pictures that I need to watermark with text that will be different for every image. For example, if I have a picture of a building I want to watermark the Name or Address of this building. I have the unique information saved in an excel file with the image file name. Now after searching for the past three days I have not come across a tool that can batch watermark unique text for each picture. I am primarily running on a Windows, and I am comfortable using Command Line to complete this process. I am also willing to spend some money on a tool to do this so it doesn't need to be free and/or open source.

Explanation / Answer

You could do this with the ImageMagick convert command from a batch file it will allow you to apply text to a file, convert the type, rescale, etc., all in a single operation - it is also free.

e.g. convert rose.jpg -draw "text 25,60 'By Any Other Name'" outdir/rose.jpg

Alternatively you could use python, PIL (the python image library) or Pillow (a fork of PIL) and xlrd to do the whole job automatically including reading from the excel files. These are also free tools but will take a little more learning on your part. I would strongly recommend taking a backup of all your images before trying any operations on them.
Updated:

Just to add - seeing some of the comments on the original question that all the tools that I mention in the answer above are:

Free (Gratis)
Free (Open Source)
Cross platform, specifically:
ImageMagik command line graphics manipulation:
Binary downloads for Unix, Mac OS(X), Windows & Linux
Source available so you can probably build it for just about anything else.
Python Programming Language:
Windows binaries available
Usually already installed on OS(S), Linux, Unix & many others
Ditto the source source
PIL/Pillow Image Manipulation Library:
Binaries available for Windows
Installed from source if you have Python/PIP on other platforms
XLRD Python Excel Reader Library
Source distribution works on any python platform