• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

Add different metadata from an excel file to 10.000 photos

Participant ,
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

Hi,

I am looking for a way to add metadata to a large number of files. Each photo will have different keywords etc.

Is there a way to match an Excel sheet with the photos and add the metadata to the respective photos automatically rather than copy it manually for 10.000 photos?

Thank you!

TOPICS
Actions and scripting

Views

2.0K

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

Sounds like this may take some Scripting, maybe you should ask for advice over on

Photoshop Scripting

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

thank you!

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

Hi

I'll move the thread for you

Moving to Photoshop Scripting from Photoshop

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

There are a few methods to do this:

Use a D.A.M. (digital asset management program)

ExifTool by Phil Harvey

VRA Panel Export-Import Tool

DIY Metadata.jsx

or write a program to do it.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

thank you!

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

Some methods for importing are listed at the foot of my blogpost here (as mentioned by SuperMerlin):

Extracting Metadata to .CSV

 

You can also fast-track your task by searching in the Bridge & Bridge Scripting forums...

Update image metadata from CSV --- urgent help

Need a script to update keywords for 20000 images in Bridge

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

Custom data in a Custom File Info Panel

Action that can read and put metadata from CSV file?

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

thanks a lot!

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 08, 2019 Apr 08, 2019

Copy link to clipboard

Copied

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
Apr 15, 2019 Apr 15, 2019

Copy link to clipboard

Copied

I have a script that does it. Something I had kicking around, just had to finish it up. Free to download. This incarnation of an earlier script is a new release so please holler if something doesn't work right. And always make a backup of your files first, please!

 

Keywords From CSV

keywords-from-csv-01

William Campbell

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 14, 2021 Nov 14, 2021

Copy link to clipboard

Copied

Thank you for nice information
UHAMKA Journal 
Neuro Sains 
UHAMKA 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Nov 16, 2021 Nov 16, 2021

Copy link to clipboard

Copied

LATEST

Hi, I marked your post as spam, but now I see it's back. Are you real user?

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines