Hence, I started a little experiment in putting together an excel sheet (actually, it's a Google docs document), and seeing how far I can get with listing the figures in my collection. A few years ago, I also started doing this, but if you don't have the discipline to keep up with new additions, it quickly becomes useless.
Anyway, here's a screenshot of my efforts so far - in this case for my 25mm fantasy figures.
As you can see, there are various columns for each type/group of figures:
- Description: a description of the figure(s), useful for me to know what figure is listed. The grouping of figures is something that should make sense to me. E.g. Orc Warriors are all listed as 1 group, irrespective of weapons/shields etc. But I do make a difference between Citadel and Ral Partha Orcs. I realize other people might catalogue their figures in another way - after all this should be useful for me - not someone else ;-)
- Number: how many figures in the group.
- Origin: manufacturer (if known)
- Remarks: some useful remarks for me, e.g. where I bought the figure, how the figures are painted etc. Again, this is something that is useful for me to quickly realize what figure we are talking about.
- Catalogue Reference: I plan to list here any references to the catalogues of the manufacturer. Useful for some unusual or rare figures, or from lesser well-known manufacturers. Saves me time trying to relocate a specific figure again.
- Bloglink: if the figure(s) somehow featured in a blogpost on this very blog.
- Link to picture: the idea is that here links are provided to an image in my Google Photos collection, or a link to an image posted on the blog.