Free Model Train Inventory Spreadsheet Template
Sixteen columns covering everything that matters for insurance, resale, and simply knowing what you own. Works in Excel, Google Sheets, and Numbers.
Every column, and why it earns its place
Most homemade inventories fail because they track too little, not too much. These are the fields collectors wish they'd captured from the start.
| Column | Why it matters |
|---|---|
| Brand & catalog number | The two fields that uniquely identify a piece. Without them, a buyer, appraiser, or insurance adjuster is guessing. |
| Road name & road number | How you'll actually search your own list, and the detail that separates near-identical variants. |
| Scale & type | Lets you filter the list the way you store the collection. |
| Condition & original box | The two biggest swing factors in what a piece is worth. Record them while the item is in front of you. |
| Purchase date, price & seller | Your cost basis. Almost nobody can recall this five years later, and it's what tells you whether a sale is a gain or a loss. |
| Current value | The number that makes insurance and resale decisions possible — and the one that goes stale fastest. |
| Storage location | Turns 'I know I have one somewhere' into a thirty-second lookup. |
| Last serviced & notes | A documented service history is worth real money when you sell, and it's invisible if you don't write it down. |
Three habits that make any inventory worth keeping
Record condition while the piece is in your hands. Condition is a fact about a moment, and memory doesn’t preserve it. More on what the box and condition actually do to value.
Start with what you’d hate to lose.Trying to catalog everything at once is why most attempts stall. Twenty pieces is a real start — here’s why the habit compounds.
Keep it somewhere you’ll have it at a show.An inventory that lives on the desktop at home can’t stop you buying a duplicate at a dealer’s table. See how to work a train show without double-buying.
Where a spreadsheet stops working
This template is genuinely useful, and for a small collection it’s all you need. But it’s worth knowing what you’re signing up for, because the same three things break every spreadsheet eventually:
- The typing.Every row is hand-entered — brand, catalog number, road name, specs. A few hundred pieces is dozens of hours, which is why most spreadsheets stop being updated somewhere around item forty.
- The values go stale immediately. Secondary-market prices move constantly. A value you typed in last year is a number you now have to re-research one piece at a time.
- No photos.An adjuster wants to see the item. A spreadsheet cell can’t show them.
That’s the problem Model Train Trackerwas built to remove. You add an item by photographing the end of the box — no typing — and the app identifies it against a reference catalog of over 100,000+ products from 600+ manufacturers, then fills in the specs, image, and a current market value that keeps refreshing on its own. When you need the formal version, you export an itemized PDF or Excel report with photos and total insured value in one click.
The free plan covers 20 items with no credit card, which is enough to compare it against the spreadsheet honestly. See everything it does or compare the plans.
Skip the typing entirely
Photograph a box, get a cataloged and valued item. Free for your first 20 pieces.
Start free