Batch import IPTC information from Excel

[Karl]

I have a huge number of JPG-Files (thousands).
For each JPG-File I created a line in Excel with filename and all the IPTC-Information I want to add to each JPG.
1.Is there a way to use an Import file to add various IPTC-Information to each JPG?
2.If YES what is the structure of this Import-file, e.g. "filename Tag1=xxx Tag2=yyy" etc ("TAG1" here represents the IPTC Tag-name) ?
3.Is this kind of batch import supported by ExiftoolGUI and where can I find more information, like examples, etc.)
Thank you
Karl

[Phil Harvey]

Hi Karl,

I don't think that ExifTool GUI has a feature to import database information to multiple files, except maybe through the exiftool direct feature.

The exiftool application does have this feature, and will import database information in either CSV or JSON format.  See the application documentation for the -csv and -j options.  Also, here is a recent post which discusses CSV import.

- Phil

[Karl]

Hi Phil,
thank you for the quick reply.
I will get myself educated on exiftool and report back. It might take some time.
Karl