ExifTool Forum

General => Metadata => Topic started by: Paul175 on March 26, 2020, 02:35:16 PM

Title: export exif data to excel
Post by: Paul175 on March 26, 2020, 02:35:16 PM
I am looking for a way to take a group of photos and create an excel spreadsheet with exif data (the file name and the date/time the photos were taken). I've tried looking at previous questions, but while I found similar questions, nothing seemed to really answer what I'm looking for. Would something like this be possible with exiftool?
Title: Re: export exif data to excel
Post by: Paul175 on March 26, 2020, 04:24:41 PM
Just to add on to this (in case it can help someone provide the code I would need), I was trying to follow along the directions described here: https://medium.com/@hunchly/bulk-extracting-exif-metadata-with-hunchly-and-exiftool-164d67c8d7e2
But whenever I would try to put the code into the command prompt it comes back as saying "...is not recognized as an internal or external command, operable program, or batch file"

I have zero experience with exiftool, all I need to do is this one particular task of getting a spreadsheet with filenames and date/time for photos, so any help would be appreciated
Title: Re: export exif data to excel
Post by: StarGeek on March 26, 2020, 09:29:18 PM
But whenever I would try to put the code into the command prompt it comes back as saying "...is not recognized as an internal or external command, operable program, or batch file"

Assuming Windows by that response, that's an error returned by CMD/Powershell.  It means that CMD can't find where you put exiftool or maybe you didn't rename it from exiftool(-k).exe to just exiftool.exe.

As the very simplest, your command would be something like
exiftool -DateTimeOriginal -csv >/path/to/file.csv /path/to/files/

Exiftool will automatically put in a path/filename in the first column called "SourceFile" and a column called "DateTimeOriginal" which is the most common tag that Windows uses for its "Date Taken" property.  PNGs or video files would have different tags you would have to use. See FAQ #3 (https://exiftool.org/faq.html#Q3) to see how to view all the tags in a file.
Title: Re: export exif data to excel
Post by: Paul175 on March 26, 2020, 09:35:22 PM
I realized what my problem was, I didn't realize that "photos" in the code was meant to be the name of the folder with the pictures (so I was trying the code with just photos while the folder had a different name). Simple mistake

Thanks for the help
Title: Re: export exif data to excel
Post by: exifacou on April 16, 2020, 11:29:33 AM
I recently did something similar and used exiftool export into csv file ...

exiftool -G -FileName -ModifyDate -ISO -Fnumber -ExposureTime -ExposureCompensation -csv . > ../tl-session-metadata.csv

I'm on MacOS and first used MS Excel for import.

Experience wasn't great since I had to use the excel csv wizard especially to configure the f-stop. Excel simply converted it automatically to a format although it shouldn't. I then tried Apple Numbers. Just loaded the file and everything was as it should. So - if you're a MacOS user I'd recommend using Apple Numbers for the task.