Free tool inventory template (CSV) — and how to outgrow it

If you just need a tool inventory spreadsheet that works, here it is — no email required:

Download the free tool inventory template (CSV) — opens in Excel, Google Sheets, or Numbers.

What's in the template

The template has one row per tool or supply and eight columns. They're the columns that actually earn their keep in the field — nothing you'll leave blank out of guilt:

• Name — what a crew member would call it, not the catalog title. “Cordless drill 18V” beats “DCD791D2 20V MAX XR Li-Ion Brushless Compact Drill/Driver Kit.”
• Code — a short unique ID (TL-1001). This is what you put on the label; more on that below.
• Description — model, serial number, or anything that distinguishes it. Optional.
• Quantity and Min Level — how many you have, and the count at which you reorder or recall tools.
• Price — replacement cost, so a lost-tools report is one SUM() away.
• Unit — pcs, box, ft.
• Folder — where it lives. Use a Location/Category path like Truck 1/Power Tools or Job Site A/Safety.

The sample rows show a realistic setup for a small trades crew: a truck, a job site, and a shop with consumables. Delete them and add your own.

Three habits that make the spreadsheet actually work

1. Give every tool a code — and put it ON the tool

A spreadsheet nobody can match to physical tools is a list of wishes. Assign each row a short code and label the tool with it — a printed barcode label or QR label on Avery sheets takes minutes and survives a toolbox better than marker.

2. One person owns the sheet

Shared spreadsheets rot when everyone edits and nobody owns. Pick one owner; everyone else reports changes to them (a photo in the group chat works).

3. Count on a schedule, not on a loss

A 15-minute walk-through every Friday catches drift while it's still small. Most teams discover missing tools the morning they need them — a weekly count moves that discovery to a moment when you can do something about it.

When the spreadsheet stops scaling

Spreadsheets handle one location and one editor well. The cracks show when:

• Tools move between trucks and sites, and the sheet is always one move behind reality;
• More than one person needs to update it — from a phone, in a parking lot, with gloves on;
• You want the label on the tool to do something — scan it and see the item, instead of scrolling a 400-row sheet;
• Nobody gets told when consumables dip below the min level.

That's the point of an inventory app. metItem imports this exact CSV — the columns match its Bulk Import — and gives you a separate inventory per truck, site, or store, barcode scanning from any phone, and — on paid plans — low-stock alerts. The free plan covers 100 items, which is plenty to find out whether the app habit sticks for your crew.

Related

• How to track tools across trucks and job sites
• Setting up a barcode inventory system for a small business