Skip to main content
pamelas2243743
pamelas2243743
Participant
November 17, 2016
Question

Exporting Bridge metadata to Excel or CSV

  • November 17, 2016
  • 1 reply
  • 13460 views

How can I extract Bridge (version CS4) metadata to Excel?  I find some guidance here in the Adobe forums about moving metadata from a spreadsheet to Bridge, but I need to export Filename and ITPC Core Description fields from Bridge to a Excel (or CSV) file.  Any advice would be welcome!

This topic has been closed for replies.

1 reply

pamelas2243743
pamelas2243743Author
Participant
November 17, 2016

Correction -- I have Bridge CS6, not CS4.

gregreser
gregreser
Legend
November 17, 2016

If you are comfortable with command line, exiftool might be the fastest way to export to tab or comma separated text.

ExifTool by Phil Harvey

This page has a lot of good examples: exiftool Application Documentation

 

A simple tab-delimited export for a directory of files would look like this:

exiftool -t -filename -creator -title -description -keywords -copyright ./ > export.txt

 

If you want to do this through Bridge, you would use the functions xmpData.getProperty or xmpData.getArrayItem.  Of course, there's more to it than that.  The Bridge SDK has an example script called "SnpInspectMetadata.jsx"

 

This script exports much more than you want, but you could customize it to suit your needs. Metadata Deluxe / VRA Panel Export-Import Tool

I can also share a simple Dublin Core export-import script, if you are interested.

    Stephen Marsh
    Community Expert
    Stephen MarshCommunity Expert
    Community Expert
    November 17, 2016

    Some references to Bridge scripts can be found here:

    Prepression: Extracting Metadata to .CSV

    Just to flesh out the ExifTool info, a source file or directory location is required, in addition to the output file location and name:

    exiftool -r -T -subject '/Users/loggedinusername/Pictures/' > '/Users/loggedinusername/Desktop/exiftool-keyword-dump.txt'

    This command will recursively scan all subfolders and files within the “Pictures” folder of the current logged in user and create a tab delimited text file on the user’s Desktop containing the keyword metadata found in each image. The previous command line code is from the Mac, on Windows simply change the single straight quote/foot mark ' to straight double quote/inch marks " with the correct platform specific path to the top level folder.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices