I have thousands of images that I want to construct a database around (in excel), beginning with info about them available in their metadata (e.g. date, camera name) which is viewable in windows when browsing files and their properties. I don't want to enter these individually. My second goal is to automatically create hyperlinks to their file location on my machine where a link in the database could be clicked and the file launched with a default program. Is this easily possible without purchasing specialized software to do this? Perhaps some macros written in excel could do this?
Hi Eric,
Have you tried this:
http://www.br-software.com/extracter.html
?
From the description it looks like it could do what you are looking for.
Please let us know the outcome.
Thanks,
Peter
There are a large number of meta data editors/viewers. One or more might work for you.
https://en.wikipedia.org/wiki/Comparison_of_metadata_editors
Karen's Power Tools- free software. She has a very useful print directory utility at https://www.karenware.com/powertools/ptdirprn. It will make an Excel compatible list of the items and folders on a drive, and I think you can narrow it down to a specific directory, as you will probably want to do.
The above answers were very helpful and sufficient for me to find an appropriate metadata editor. I was able to automatically assemble the database with hyperlinks to the image files and will all the metadata fields as columns. I've been manually coding up camera trap photos a little bit at a time over the past months - still several thousand to go...
- Badges
- Science topic
- Similar topics
- Computer Science and Engineering
- Software