Free Hot Wheels Inventory Spreadsheet Template (Excel & Google Sheets)
June 23, 2026 · Updated August 3, 2026
If you search for a Hot Wheels inventory spreadsheet, you mostly find paid Etsy templates and generic “inventory tracker” files that were clearly never touched by a collector. So we made a proper one and we are giving it away, no email signup, no catch.
Download it here:
- Excel template (.xlsx) with dropdowns, filters, and an auto-calculating stats sheet
- Universal CSV version for Google Sheets, Numbers, or anything else
To use it in Google Sheets: open sheets.new, then File, Import, Upload, and pick either file. The xlsx version keeps its dropdowns and stats formulas.
What’s in the template
The columns are the field set that actually survives a real collection, the same structure we use in the Hunt64 app:
| Column | Why it’s there |
|---|---|
| Toy Number | The code on the card bottom and the base (like HTC50). The only unique ID for a release. |
| Model Name | As printed on the card. |
| Brand | Hot Wheels, Matchbox, Majorette, Tomica, Mini GT, and more, as a dropdown. |
| Year | Mainline year. |
| Series + Series # | “HW Flames” and “3/5”, so you can track set completion. |
| Color | The recolor problem is real. This column is your defense. |
| Rarity | Regular, TH, STH, Chase, or Store Exclusive, as a dropdown. |
| Condition | Mint, Near Mint, Good, Poor. Four grades keep you honest. |
| Carded | Yes or No. Massive value difference, one column. |
| Qty | For intentional duplicates (one to open, one to keep). |
| Purchase Price + Date | Future you, selling or insuring, will be grateful. |
| Storage Location | ”Box 3” is enough. Essential past a couple hundred cars. |
| Notes | Variations, damage, provenance. |
The Excel version adds a Stats sheet that updates itself: total cars, Treasure Hunt and Super count, carded vs loose split, and total spent. There are three example rows so you can see how entries should look. Delete them and start.
How to get through your backlog
The template is the easy part. Actually cataloging 300 cars is the project. The short version of our advice, with the long version in the complete cataloging guide:
- Sort physically first (carded vs loose, then by era).
- Work in batches of 25 to 50 cars, not marathons.
- Fill identity fields first; photos and prices can come later.
- Park unidentifiable loose cars in a “mystery” state and keep moving.
- From today onward, every new car gets entered the day it comes home.
Where the spreadsheet stops working
We will be straight with you, since we obviously have a horse in this race: a spreadsheet is a genuinely good system, and for some collectors it is all they will ever need. It is also the system we watched hundreds of collectors abandon, always for the same three reasons:
Everything is typed by hand. Model name, series, year, toy number, for every single car. Thirty seconds each becomes hours across a collection, and typos silently poison your search results later.
Photos do not fit. A spreadsheet row can hold a link to a photo, but maintaining a photo filing system next to a spreadsheet is a second hobby nobody asked for. Collections are visual; grids of text are not.
It is not with you at the pegs. The duplicate-buying problem, the one that actually costs money, happens in a store aisle. Searching a spreadsheet on your phone works only if you spelled the model exactly right and can distinguish this year’s recolor from last year’s by memory. More on that failure mode in our guide to never buying the same car twice.
The app version of this template is Hunt64: point the camera at a package, AI reads it and matches it to a 10,000+ release catalog with year, series, and TH/STH flags filled in, a photo attached, and a warning if you already own that exact release. It is free to start (unlimited AI scans and a 50-car garage, no ads), and everything exports back out to CSV on every tier, so this spreadsheet remains your escape hatch, not a hostage situation. Get Hunt64 for iOS and Android.
Spreadsheet or app, the collectors who are happiest are the ones whose collections are actually cataloged. Grab the template and start tonight.