showing exif date on a directory liisting

[Segref]

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.

[wywh]

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