up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
84% accept rate
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
feedback

2 Answers

up vote 1 down vote

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...

link|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
feedback
up vote 0 down vote

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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