Need a script to update keywords for 20000 images in Bridge

Forum|Forum|9 years ago
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.

Scripting

This topic has been closed for replies.

Stephen Marsh

Community Expert

A similar topic thread here:

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

Stephen Marsh

Community Expert

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

shashi88Author

Participant

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.

SuperMerlin

Inspiring

I am on windows. As for the images, all are in a single parent directory plus the format is JPG.

DIY Metatada would not work for you as the file in not in the correct format, you do not have the filenames in the first column also your keywords would need to have a seperator of a semicolon not a comma.

SuperMerlin

Inspiring

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

Another solution would be to use Exiftool ExifTool by Phil Harvey

shashi88Author

Participant

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

Inspiring

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded