ExifTool Forum

General => Metadata => Topic started by: bbb on November 08, 2017, 11:48:37 AM

Title: export jpg metadata "date and time"
Post by: bbb on November 08, 2017, 11:48:37 AM
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?
Title: Re: export jpg metadata "date and time"
Post by: StarGeek on November 08, 2017, 12:49:15 PM
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.
Title: Re: export jpg metadata "date and time"
Post by: bbb on November 08, 2017, 01:34:39 PM
Thanks!
Bear with me, where do I put the photo folder file path and where do I put the csv output path?
Title: Re: export jpg metadata "date and time"
Post by: Phil Harvey on November 08, 2017, 01:51:42 PM
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
Title: Re: export jpg metadata "date and time"
Post by: bbb on November 08, 2017, 05:25:52 PM
Thanks.