extract all info to excel using exiftool

columns.Įasy, and clicking that column heading will sort the files by focal length. Select ' 35mm focal length' to add that column to the usual name, date,type, size. Good info in this thread! here's a windows how-to: You won't get these from the 24-70F4S or many other lenses:ĮXIF data from images into a spreadsheet! We just need a (S or non-S) 70-300F4, but I'd prefer a smaller 50-150F4S DX myself.

It was mostly used on my Z50, and it now makes more sense to use the 14-30F4S instead. It is no 24-70f2.8S, but it is certainly manageable for hiking and all day use. I even let my 85-S go because the isolation I get with 120F4 and not having to switch lenses is worth it to me. However, I find the 24-120F4S SO GOOD that I've given up my favorite/value/compact $500 used 24-70F4S. I have a separate one for '2 or less' images that I use as an archive. Over the past few years I've migrated all of my images from 5 catalogs to one.

Lightroom does this VERY easily, but you'd have to create a catalog with all your images. Did you know that you can 'focal length' to a Windows explorer column? You can use DOS/shell commands to export a directory listing to a text file to get them into excel.

Extract all info to excel using exiftool