Save all metadata from your photos to a CSV document with EXIFextracter
Images that you take using your phone's camera or a digital camera often contain useful metadata information. This data lets you see which device was used to take the picture, the settings that were used and other information.
EXIF tags are also useful for managing and organizing your photo gallery. There are many image viewers that you can use to browse photos by tags. But if you want a record of all your photos and their folder locations, there are some tools that fit the bill.
BR's EXIFextractor is a freeware program that can extract the metadata from photos and save them in CSV documents.
It is a straightforward program. Click on the three-dot browse button next to the "Folder to scan" field to add the directory that contains your photos. You can toggle the option to include sub-folders if required.
Before you extract the tags, you will need to set up some options. Click on the button next to the Output filename field and navigate to the folder where you want the spreadsheet to be saved. You will need to give the document a name to save the file, e.g. Vacation.CSV, Party.CSV, etc.
The next set of options allows you select from various metadata that EXIFextracter can pull from the photos. This includes the following tags: Date, Time, Date and Time, Camera manufacturer and model, Camera manufacturer, Camera model, Lens Model, Width X height, Size of the image file, Exposure, Aperture, ISO, Was Flash used, Distance, Focal Length, User Comment. It can also save GPS related information such as Latitude, Longitude, Altitude, Date/Time, Direction. The program supports IPTC and XMP metadata like Headline, Description, Keywords, Comments, Author, Title and Subject.
Now, a lot of cameras don't save all this metadata, so let's say your pictures have 5 or 6 tags in them, there's no point to enable every single option. If you select all the tags, you'll end up with a lot of blank columns. Choose the ones you want by clicking the checkbox next to the option, and leave the rest unmarked. You may want to run a short test to see which tags your camera model saves to only select them in the future.
Click on the setup button in EXIFextracter, to bring up a couple of customization options. This window can be used to set a different date format and month names, you can optionally go for short names like Jan, Feb, or the proper names.
Back on the main screen of the application, there are a couple of other options that you can select. "Add Column Headings" creates a heading label for each column like Date, Time, Exposure, etc.
"Use full file path...." adds the folder location of each file to the file name column. You can disable it to make the document a little cleaner. Click on the drop-down menu and choose from Comma, Colon and semi-colon to set the Separator Character to be used for the output file.
When you are ready, hit the Extract button to generate the CSV file. A confirmation message will pop-up that mentions the number of files the tags were extracted from. The resultant file can be opened in Microsoft Excel or any compatible program.
EXIFextracter is compatible with Windows XP and above. It is in beta, but works well even in its current state.