I have a group of 16000 images that I need to compare the date taken with the date shown in an Excel spreadsheet or Access data base. Is there a way that ExifTtool can output the filename and date taken to a directory list. I have tried the command prompt "dir /tc" but that only gives me the date the file was placed in a folder, not the date the photo was taken.
For images and movies try something like (apps like LibreOffice can open the generated out.csv):
exiftool -a -G1 -s -api QuickTimeUTC=1 -Time:All -e -fileOrder5 FileName -csv . > out.csv
List also generated composite tags that might be useful as an input:
exiftool -a -G1 -s -api QuickTimeUTC=1 -Time:All -fileOrder5 FileName -csv . > out.csv
List more dates:
exiftool -a -G1 -s -api QuickTimeUTC=1 -Time:All -api RequestAll=2 -fileOrder5 FileName -csv . > out.csv
The important date for .jpg is:
-ExifIFD:DateTimeOriginal
The important dates for .mp4, .m4v and .mov movies are:
-QuickTime:CreateDate
-Keys:CreationDate [especially for movies before 1970]
So to see just them, use:
exiftool -a -G1 -s -api QuickTimeUTC=1 -ExifIFD:DateTimeOriginal -QuickTime:CreateDate -Keys:CreationDate -fileOrder5 FileName -csv . > out.csv
- Matti