Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

Need a tree taken down or milled?

Tool inventory software or spreadsheet?

Posts

Tool inventory software or spreadsheet?

#1

JL

Tool inventory software or spreadsheet?

JL

I have a few tools (Hi, I'm JL and I'm a toolaholic). Some I've purchased, some I've inherited and some I've been given.

Sometimes I wonder if I really know what (or all) that I have. Is anyone aware of a relatively decent inventory program or does anyone have a decent spreadsheet that they would care to share?

I could keep the inventory out in the "cloud" for insurance purposes.

Re: Tool inventory software or spreadsheet?

#2

Ellis Walentine

Easy enough to create from scratch

Ellis Walentine

When my shop burned down, I had to list everything I had lost for the insurance company. I just opened a new Excel Spreadsheet and started listing things. I divided the sheet up into separate categories -- hand tools, machinery, portable power tools, supplies, materials, miscellaneous. I assigned a replacement cost value to each item.

Ellis

Re: Tool inventory software or spreadsheet?

#3

Moses Yoder

Re: Tool inventory software or spreadsheet?

Moses Yoder

I always thought if I did a tool inventory, I would take a picture of each tool and then set up a simple Excel spread sheet with a column for what the tool is called, what I think it's value is (not replacment cost but street value; replacement cost could be determined later for insurance purposes if necessary), and a link to the picture of the tool. If all the tool values are in one column it's very easy to get a sum of the column at the bottom. So it would have 3 columns, pretty simple. This spreadsheet would be invaluable for your children to dispose of your tools when you die.

Re: Tool inventory software or spreadsheet?

#4

The picture is important even if

Gary Smyth

it only shows a bunch of them in a drawer. (As you can see I find it almost impossible to pass up a well maintained 50 cent plier.) My insurance guy wants the photo to be sure I actually have the tool as opposed to "upgrading", or "imagining" if something goes wrong. If all you can do is a video sweep of the room that is almost better than a listing. Keep photos elsewhere on a jump drive. That said, I'm also in favor of a winter project inventory list. I use Excel. Only five columns. Type of tool/size, brand, model, serial number. I fill in only what I can find on the tool. I don't bother with value or description unless I bought the item at a house sale or flea market and then it is only for me. Like Ellis I broke my list down into category - woodworking, engineering, drafting, auto, metalworking, household (like specialized plumbing, electrical) and garden. Given the new forum list I'm adding photographic equipment.

It is a royal pain in the rear to start this project as it will eat time like crazy as you won't believe all that is there. But after the initial start it gets easier and becomes second nature. If it gets too cold or you hate to stand in front of a drawer writing stuff down you can use the photos while at your desk to describe what is added to the list. In an emergency you won't regret it and if your coverage is good and paid, the insurance people won't play as many games. Oh! BACK UP YOUR LIST AND DATE IT EACH TIME YOU ADD A TOOL!

Re: Tool inventory software or spreadsheet?

#5

Re: Tool inventory software or spreadsheet?

Roger Myers

If you have an IPad, there is a terrific app called Itemizer that I use to inventory. It is easily customizable, prints a PDF...searchable...ability to add notes and pictures...multiple inventories, i.e., shop tools, material, wines, etc....

It is very inexpensive and works perfect for this type of application....

Also handy to have the iPad with you when you are out tool hunting as you will know how many of the plane you can't pass up, that you already own!

Roger

Re: Tool inventory software or spreadsheet?

#6

I would add a column

Nathan

I would add a column stating where the tool lives.

Before I got organized, I used to have to search for lesser-used tools. Now I never have to do that, no sir.