Bulk exif data export to Excel

[Delta Skies]

I'd like to export exif details from a folder full of jpg images so that I can look at it in Excel. I'm not needing to edit the information just to read it and export it either directly into Excel or via a txt or csv file. I've found a few Windows exe's but can't see how to do a batch of images rather than a painful one at a time.

Any suggestions would be gratefully received.

 

[itsjosh]

A quick google search threw out this: http://www.br-software.com/extracter.html
Scans a folder and takes the exif from jpgs into a CSV file?

 

[Delta Skies]

Thanks Josh. Whilst it doesn't extract some of the exif data I was after, e.g. lens, it gives me the majority of fields I was after. Just installed it and had a quick play. I'll give it a more serious test tomorrow.

 

[Musicman]

If you're not scared of the command line, you may want to take a look at Phil Harvey's ExifTool

http://www.sno.phy.queensu.ca/~phil/exiftool/

which will allow you to export your choice of fields to a CSV file, which can then be opened in Excel

http://www.sno.phy.queensu.ca/~phil/exiftool/faq.html#Q12

P.S. it does a lot else and it's a dead handy piece of software to have about for when you need to make bulk reads/writes/changes of EXIF data.

 

[Delta Skies]

Apologies for the slow reply Rob. I'd spotted this one but it didn't seem to work on my laptop for some reason. I might try it again.

 

[Jan K.]

If you "only" wants to see some statistics, my favorite program is Ralph Bibinger's Exif Viewer: http://www.amarra.de/englisch.html

 

[Jan K.]

Arg! Forgot to say, it can export all data directly to Excel...

 

[Delta Skies]

Jan - That one is excellent. Just tried it and got all sorts of info into Excel. Many thanks for the link.

 

[Jan K.]

You're most welcome!

The more I work with it, the more impressed I get.
If you click on "Makernote-Auswahl", select camera brand and then "Anpassen", you're able to select exactly which data should be exported.

Haven't ever used these features before, so thank you for post #1


Now, if only the program was in english...