jpg files sorted by date (this is NOT the 'Date' displayed by the Faststone Image Viewer). I would trust exiftool more than I'd trust Faststone. I would have thought it would have been either DateTimeOriginal or CreateDate.

That is the sequence I'd like Faststone to sort the files.ĭo any of the column dates in your spreadsheet match those in Faststone?

Then I sorted the photo-files into 'earliest date' order. I then determined which cell in each row contains the earliest date (surprisingly, it wasn't always the DateTimeOriginal, the FileCreateDate or the CreateDate). I used EXIFTOOL to extract this data for all 5,000 photo-files:Īnd I imported that data into my Excel Spreadsheet. The date of the photo should be the date in the photo, ie the exif data, the date the picture was taken. It sounds like something in Excel is jamming you up. The date for the sort is the one in the exif data, that is, the date on which the exposure was made. Don't know what you mean by sorting on the 'date in the Excel folder.' Isn't that the date of the photo? The date in the exif? Or is it artificially applied somehow in Excel?įaststone will sort the files by date.

Fast stone viewer