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.

We have 3000 photos that we want to quickly flip through and tag into different categories, and export that information into a spreadsheet. The software can be very simple (I am not doing any editing, post processing, etc.)

I know software like iPhoto can do tagging, but I want to produce a final spreadsheet that has one column with the photo filenames, and columns to the right of it representing each tag. If a particular photo (row) is tagged in a category, it will be indicated in the corresponding cell.

FLOSS preferred but not absolutely necessary.

Does anyone have suggestions? Thanks.

share|improve this question

closed as off-topic by Sathya Aug 3 '14 at 15:47

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Sathya
If this question can be reworded to fit the rules in the help center, please edit the question.

1  
Any decent photo manager should allow you to tag. It is the information export that may cause problems. What sort of information do you want included in the spreadsheet report? –  music2myear Aug 24 '11 at 17:56
    
@music2myear I edited my question to be more specific. Thanks. –  hpy Aug 24 '11 at 17:58
    
What operating system are you running? –  wizlog Aug 24 '11 at 18:28
    
@wizlog Windows XP and Mac OS X. I hope the software will at least work in Windows, but preferably in Mac OS X, too. –  hpy Aug 24 '11 at 18:32

3 Answers 3

  • Use Picasa to flip through the photo's and tag them.
  • Use exiftool to extract the information.
  • You can even create buttons inside Picasa to execute a batch script using exiftool.
share|improve this answer

FileMaker is great for what you're describing, but it's expensive. Bento, the life-oriented version, is a bit cheaper, but not much.

share|improve this answer
    
Sounds a little too heavy duty for my needs. But would I be able to flip through the photos very quickly and tag them quickly with Bento? –  hpy Aug 24 '11 at 18:33
    
@penyuan That's what it advertises. I'm pretty sure they have a trial, so you don't have to drop the money now. –  digitxp Aug 24 '11 at 18:34
    
What did I do to deserve a downvote? :'-( –  digitxp Aug 24 '11 at 19:21

Look... Putting file names and tags into an Excel Spreadsheet is very doable and easy with C#. You could use software like Picasa... or you could just:

If you can use a computer with Windows 7 or Windows Vista, then you can easily sort by tags, just as you would by date.

In Windows Vista and 7... To add a tag, I simply opened my Pictures folder, clicked a photo of my mom, and then clicked the area next to Tags in the Details pane at the bottom of the folder window. (If the Details pane isn’t visible, click Organize, click Layout, and then click Details Pane.) In this case, I'll type the tag “mom” into the Tags (you can add more than one tag, and separate them using a semicolon in the Tags box) box, and then press ENTER.

To then sort by tag...

share|improve this answer
    
However, Windows stores this information with the file and is generally not very good at exporting the information. –  digitxp Aug 24 '11 at 19:00
    
@digitxp please A) give a specific example; B) if all you want to do is sort, then put each tag group into its own folder –  wizlog Aug 24 '11 at 19:04
    
A) en.wikipedia.org/wiki/Windows_explorer#cite_ref-12 B) The OP wants to be able to consolidate this information into a table. –  digitxp Aug 24 '11 at 19:12
    
This is nice, but I don't see how I can tabulate the information into a spreadsheet... –  hpy Aug 24 '11 at 20:44
    
Why would you want to? –  wizlog Aug 25 '11 at 2:08

Not the answer you're looking for? Browse other questions tagged or ask your own question.