firearm inventory spreadsheet?

Status
Not open for further replies.
R

rondog

Member
Joined
Jun 29, 2007
Messages
6,838
Location
Commurado
Does anybody have a nice "form", "template" or "spreadsheet", or blank document file in either Word or Excel for recording the information about your guns?

I'd like to have an electronic copy of a blank form or template for recording make, model, serial number, description, value, etc., and maybe space for photos too. I have something similar in old printed paper forms, but those are pretty rough. I'd like something I could keep e-copies of, and make printed copies too.

I can use Excel and Word, but I'm no good at creating templates. Anybody have something like this they'd share?

Thanks!
 
I could PM you with my Excel template, but I don't have it on this computer. What I need to do is email it to myself, that way it will be saved in that web email account and I could access it anywhere in the world just by logging into my account. A type of off-site archive.
 
I could PM you with my Excel template, but I don't have it on this computer. What I need to do is email it to myself, that way it will be saved in that web email account and I could access it anywhere in the world just by logging into my account. A type of off-site archive.
Click to expand...

That would be great! I'm not looking to buy any software, just an Excel spreadsheet that somebody made is great. Just a fill-in-the-blanks thing.
 
I just started an excel document, no template. Just started with gun #1, model, serial, description, and attached a picture. Then I made a bold border, went onto next gun. Saved it, put copy on a couple of cd's, one in gun safe, one to my brothers for safekeeping. Its eazy to add to or subtract from. Also it can be nearly infinite is size, however not a problem for me. If I get some time, I'll make an empty copy and post it here.
 
Send me a pm then with the email you want it sent to just typed in the body of the pm. I'll send it and it will be there when you get home.
 
I looked for a program, and someone here had one called gunlist or something similar. Software that I thought was overly complicated.

I put mine on a simple Excell spreadsheet with make, model, serial, caliber, price paid, date, and other notes (finish, # or mags). When I make an update I email it to myself so that if I'm victim of theft or fire I have a permanent copy on email.
 
Why would you want records of every firearm you own? Maybe I'm paranoid, but I wouldn't want anyone to know any of that.
Click to expand...

If they are stolen or lost in anyway it's good to at least have a record of the S/N.
 
Why would you want records of every firearm you own? Maybe I'm paranoid, but I wouldn't want anyone to know any of that.
Click to expand...

It only comes into play for insurance purposes or police reports of theft, or to record the disposition. And sometimes I just like to look at my list! :) In my graying years it's a good reference as to where, when and how much my guns were. And emailing it to myself creates a timestamp.
 
Is there a way to attach an excel sheet?
Click to expand...
Attach it to what? If an E-mail there should be an attach button in whatever e-mail program you are using then it's just a matter of selecting the right file.
 
There is an attach button in the advanced reply section, it will accept word docs but not excel. I wanted to attach the sheet I used.
 
it will accept word docs but not excel.
Click to expand...
That's weird, It shouldn't care what type of file you are attaching unless it's trying to insert it into the e-mail instead of attaching it to the e-mail. What E-mail program are you using?
 
Most email servers like Comcast for instance allows several meg of free storage. You don't have to store it in an email. The email service will have instructions on how to access the files.

I have pictures of each of my firearms along with a word document list with serial numbers etc. Any time the list changes I just overwrite the previous edition with a new one. If they are stolen or a fire burns up my house, the firearms will be replaced.

I also take a video of the contents of my home once per year and store the file there as well. The insurance adjuster tells me that it is the number one problem when folks lose their home. Remembering everything they have to list for insurance purposes.
 
Google Docs

I use the Google Docs spreadsheet:

http://docs.google.com

I have one sheet for firearms inventory, one sheet for a shoot log which acts as an odometer for each firearm.

I also keep track of other stuff like my weekly cycling log to log my miles, average speed, time, etc.

sorry no fancy templates, just basic column headings at top.

-obm
 
I made my own in Excel. I use it to keep track of firearms I currently own, ones I have sold, ammo inventory, accessories & money spent, etc.
 
Yes, I built one with excel, I was trying to post a sample someone could use easily. Oh well they aren't that hard to make.
 
Status
Not open for further replies.

Similar threads

D
  • Locked
Spreadsheet for Gun Info
Replies
23
Views
1K
statelineblues
statelineblues
H
  • Locked
"bound book" spreadsheet
Replies
2
Views
646
Hoppy590
H
WestKentucky
  • Locked
Simple, effective, inventory system?
2
Replies
41
Views
2K
Tabequache
Tabequache
R
  • Locked
Where do you keep record of your firearm inventory?
2 3 4
Replies
77
Views
5K
Wolfebyte
W
R
  • Locked
Is a Firearm Inventory Record Part of Your Estate Plan?
Replies
9
Views
615
TRX
TRX
Back
Top