export jpg metadata "date and time"

Started by bbb, November 08, 2017, 11:48:37 AM

Previous topic - Next topic

bbb

Can anyone provide me with an exiftool script that can export jpg date and time metadata of a batch of photos into a csv file?

StarGeek

At the very simplest, your command would be:
exiftool -time:all -g1 -a -s -csv >File.CSV FileOrDir

But that might give you more entries than you want, as there are dozens of possible date and time tags.  My test file currently returns 96 different date and time tags.

Run the above command and then you can look at the data and see if you need to trim down to the actual tags you need.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

bbb

Thanks!
Bear with me, where do I put the photo folder file path and where do I put the csv output path?

Phil Harvey

In this command, "File.CSV" may contain a full path specification for the output CSV file, and "FileOrDir" a full path specification for the input photo folder.

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