robert_hall2 Posted December 24, 2007 Share Posted December 24, 2007 Does anyone know how to pull the metadata out of jpeg or tiff images and exportit into some text-utility like Word or Excel? Link to comment Share on other sites More sharing options...
sam_ellis Posted December 24, 2007 Share Posted December 24, 2007 Use ExifExtractor. It's a free program, do a Google search for it. Now, if someone can tell me a way to break down the data in Excel so I can do a graph showing a range of zoom settings, that would be great. For example, I'd like to do a pie chart showing how many shots were taken between 17-25, 26-55, 56-90, something like that. This way I could evaluate which focal lengths I use most often. Same thing for ISO, shutter speeds, apertures, etc. I'd like to base future purchases on this kind of data. Sorry to hijack the thread, Sam Link to comment Share on other sites More sharing options...
cgo Posted December 24, 2007 Share Posted December 24, 2007 I don't have ExifExtractor but according to what I have read, it creates a CSV (Comma Separated File) file. You can open the file with Excel. Or you can paste the contents of the CSV file into Excel. Depending on the Excel version, your data may automatically get parsed into columns. Or all your data will reside in one column. Highlight the column then, Data -> Text to Columns ... Link to comment Share on other sites More sharing options...
robert_hall2 Posted December 24, 2007 Author Share Posted December 24, 2007 The program "ExifExtractor" does not extract all the data, just some. I need what it does not extract. Suggestions? Link to comment Share on other sites More sharing options...
emre Posted December 24, 2007 Share Posted December 24, 2007 ...and what's that missing part? Link to comment Share on other sites More sharing options...
cgo Posted December 24, 2007 Share Posted December 24, 2007 What's missing? BreezeBrowser ... Link to comment Share on other sites More sharing options...
robert_hall2 Posted December 26, 2007 Author Share Posted December 26, 2007 I probably should have said "IPTC" extractor. I want the file name, title, author, headline/caption, description, keywords, and copyright. Others would be nice. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now