Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have over 1000 jpg files and one excel file with all the properties(metadata) for them - title, subject and tags.

The excel looks like this:

Number ......Title ....... ...... Subject .. ...... Tags

1... ................title1 .............. subject1 ......... tag1,tag2,etc

2.... ...............title2 ...............subject2 ..........tagx,tagy,etc

"Tag1,tag2,etc" is one cell.

For number 1 I need to : go to the folder with JPGs, find picture named "1.jpg", copy from excel into jpg properties - Details tab - Description area - title to title(title1), subject to subject(subject1) and tags to tags(tag1,tag2,etc). And so on for next files. As you can see, excel "Number" is the same with JPG name - for identification. JPGs are named 1.jpg to 1000.jpg

Is there any way to automate this? Formula, macro, anything.

Thank you very much!

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.