Skip to main content
shashi88
shashi88
New Participant
April 9, 2016
Question

Need a script to update keywords for 20000 images in Bridge

  • April 9, 2016
  • 3 replies
  • 5477 views

I have an excel with filename in column A and keywords in column B. I wish to update the keywords tab in bridge using a script. Please let me know if there is any pre written script available which I can use.

This topic has been closed for replies.

3 replies

Stephen Marsh
Stephen Marsh
Community Expert
April 14, 2016

A similar topic thread here:

Can you import metadata from an excel database to images (JPG, PSD, TIF) in bulk?

Stephen Marsh
Stephen Marsh
Community Expert
April 9, 2016

If you don’t use the Bridge script, then I can help with ExifTool (both methods have their pros/cons).

    shashi88
    shashi88Author
    New Participant
    April 9, 2016

    Hi Stephen. Thanks for the quick reply. I would be more than happy if you could guide me with Exiftool.

    I have downloaded the tool. All I need is to now how to use it.

    Link to the excel file:

    Dropbox - Workbook1.xlsx

    Tanks in advance.

    Stephen Marsh
    Stephen Marsh
    Community Expert
    April 10, 2016

    shashi88, are you on Mac or Windows OS?

    The basic ExifTool commands are the same, however there are some minor formatting differences required in some cases, such as the Mac uses 'single quotes' to wrap around a file path and file name that contains word spaces, while on Windows, "double quotes" are used (they are not really quotes, they are inch and foot marks, straight not curly).

    P.S. Are the images all in a single directory, or are they contained in a main parent/top-level folder and then within subsequent second-level, third-level etc nested folders?

    Do you need to apply the keywords to a single specific file type, multiple file types or do you need to exclude specific file types?

    Finally, are there existing keywords to be overwritten or do you wish to append?

    SuperMerlin
    SuperMerlin
    Inspiring
    April 9, 2016

    If you save the Excel to CSV you could use. DIY Metadata

    Another solution  would be to use Exiftool ExifTool by Phil Harvey

    shashi88
    shashi88Author
    New Participant
    April 9, 2016

    Tried to use DIY Metadata but when it execute it I get an error message saying the file doesnt exist. Is it because of the format in which the data is stored in CSV file?

    SuperMerlin
    SuperMerlin
    Inspiring
    April 9, 2016

    The filename should be in the first column I.E. filename.jpg and the file should exist in the selected folder or a sub folder if the relevant checkbox is ticked.

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