How do you keep track of your collection?

Dan of Bazz Clazz

Dan of Bazz Clazz

Joined
May 10, 2017
Messages
736
OCD as many of us are, I can't be the only one who has created a means of keeping track of the knives in my collection. So the question is, what do you use? Data base? Spread sheet? Notebook? Knotted pieces of string? (ala the Inca's) Wondering what others use, what works and what doesn't.

As for me, I created a spread spread sheet to keep track of everything. I keep a record of what I bought, when, from whom, how much I paid for it, even have a photo of each knife, all of which would pay off if you have to file an insurance claim.

In case anyone is interested, I have saved the template to the Excel Spreadsheet I use on DropBox and have set it up to share. Follow the link and you can DL a copy of it for yourself. The file also has some pages of steel data, comparisons, Stainless, Carbon Steel, etc. Hope someone will find it helpful and worthwhile. Let me know what you think.

https://www.dropbox.com/s/k3z2wfvouzigp2p/Knife Collection Spreadsheet Template.xlsx?dl=0

Yes I am up at 3:30 am doing stuff like this. I said I was OCD... :confused:
 
That's pretty cool. I use my own spreadsheet but it is quite a bit simpler than yours, however it does keep a good inventory for my very humble collection.

Someone (on this forum I believe) sent me a template of his spreadsheet that is more in depth than mine, but I never got around to using it. Too busy playing with my knifes I reckon.
 
Used to have a spreadsheet but seeing the sum of all the prices wasn't nice haha :D Nowadays I'd probably do an actual database or code something up in Python. Taking a look at yours it looks good though, definetly very detailed.
 
I keep an Excel spreadsheet. You can make it as simple or detailed as you want. I recently sold off a portion of my accumulation of knives:( and the spreadsheet helped keep track of everything. However, as SV-97 said, it's a real eye opener when you total the price of all the knives you've managed to collect!
 
A few years ago, I developed a "knife list" MS Word file to track my Schrade and GEC knives initially and it has spread to a more comprehensive summary of my knives with some photos. I do a detailed listing of firearms on Excel along with a MS Word purchase summary that has more condition details included in that. Still have many knives that are not included on the list at this point as I have no record of what I paid or when I got them. The listing is two fold; one is an annual purchase list and the other is by manufacturer. I don't do it for insurance reasons (more for remembering details) and I suspect if something happened I would not make a claim anyway regarding knives.

One of the reasons I did this was because I noticed I was buying similar knives with in-store impulse purchases with some traditionals. I really don't care if I have duplicates for the most part, but my focus has been with knives that I might use and I have little use for three or four Big Daddy Barlows.
 
Last edited:
My collection is small enough I just snap a picture. If I feel something is missing, I can just refer to the picture and find out what's missing.

It doesn't really help besides inventory tho.
 
Just look at it. Only 9 of em. They just sit on my dresser. Probably never be more than 10 as I sell once I start to go over that. I have zero collector in me. If knife sits it sells. But IF I were a collector I would use Excel spreadsheet with info like maker, name, steel, type, price paid, etc. then I could sort them however I was in the mood.
 
Most of them are sitting in a drawer.
One is in my fishing bag, and at any given time one is on my person.
 
I keep additional tabs that are 1.) a wish list with some notes - I talk myself out of a lot of those, 2.) No longer owned (given away, sold, stolen). I do need to take some more pictures. Thanks for that reminder!
 
You must log in or register to reply here.
Back
Top