Extracting metadata to a CSV file

Extracting metadata to a CSV file

Some TTP users have requested a way to export their tag info to CSV.  While TTP does not support that natively, there is a method to do that using the free utility from Exiftool (Phil Harvey created and supports this utility).

The way this is done is using the tag info embedded in the image itself, and not the TTP database info.

Here is a link to the article on the exiftool user group about exporting:

And here is an example of the command line:
exiftool -csv >out.csv *.jpg

The above command would extract all embedded metadata tags from all JPG's and write the data in CSV format to a file called "out.csv".  That file could then be opened in a spreadsheet program.

    • Related Articles

    • Exiftool - a great command line utility for photo metadata

      Exiftool is a command line utility created by Phil Harvey (a fellow Canadian).  Available from;       https://exiftool.org/  It is a super powerful tool for reporting on metadata, extracting it, modifying it, and in some case repairing it.  It has ...
    • What metadata is displayed from the local File system

      On Windows Explorer, the basic metadata you will be able to see is under the Properties / Details tab: On a Mac, via the Finder utility and Get Info, you will see the basic keyword data: There are a couple of free utilities we mention in other ...
    • Exporting faces

      We currently offer the ability to export photos selected via a complex search.  Those can be used for slideshows, books or other purposes. But, some users would like to export just the face thumbnails themselves.  So this would be feature added to ...
    • Sharing and/or Synchronizing images with other TTP users

      This is a very powerful feature of TTP that allows you to share tagging efforts on a subset of your photo library (or even all of your photos if you choose). By updating the metadata on shared images, all people with shared access receive the XMP tag ...
    • Removing the Win Explorer TTP menu

      We install the TTP menu in Windows Explorer by default.  However, a couple of users have requested that this menu be removed. Here is how you can do that: - Backup the Registry file to avoid any issue – Inside Registry Editor, File > Export - Save ...