show face tag XMP and exif in spreadsheet

Started by adgorn, March 13, 2018, 02:08:07 PM

Previous topic - Next topic

adgorn

I've used good old Picasa to write face tag info into the XMP metadata of my thousands of photos.  I'd like to prepare a spreadsheet that shows a column of the XMP face tag descriptions against a column of the exif tags of the names of the people I loaded in.  My goal is to verify that the XMP names are there and correct.  Make sense?  How would this newbie do this? THANKS.

Phil Harvey

First, you need to determine the names of the tags you are interested in.  Run this command on a file

exiftool -s FILE

Then run this command to generate a CSV file you can import into your spreadsheet:

exiftool -TAG1 -TAG2 ... -csv FILE

where TAG1, TAG2, etc are the tags you are interested in.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).