ExifTool Forum

ExifTool => ExifTool GUI => Topic started by: Karl on September 07, 2011, 11:48:02 AM

Title: Batch import IPTC information from Excel
Post by: Karl on September 07, 2011, 11:48:02 AM
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
Title: Re: Batch import IPTC information from Excel
Post by: Phil Harvey on September 07, 2011, 12:13:21 PM
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 (https://exiftool.org/exiftool_pod.html#inputoutput_text_formatting) for the -csv and -j options.  Also, here is a recent post (https://exiftool.org/forum/index.php/topic,3544) which discusses CSV import.

- Phil
Title: Re: Batch import IPTC information from Excel
Post by: Karl on September 07, 2011, 02:10:56 PM
Hi Phil,
thank you for the quick reply.
I will get myself educated on exiftool and report back. It might take some time.
Karl