Many model train collectors start by inventorying model trains with Excel to keep track of their collection. Understandably: it is flexible, you probably already have it, and you can get started quickly. But which columns do you really need, how do you maintain an overview, and how do you keep your file tidy and manageable?
In this guide you will find a ready-to-use column list, guidance on filters and value calculation, and practical tips for keeping your file organised. You will also learn when Excel becomes too limited and a specialist solution is a smarter choice.
Why inventorying model trains matters
An inventory is more than "a list". It is your memory. Especially as your collection grows, good record-keeping helps you collect with confidence and find what you have more quickly.
With a good inventory you can:
- prevent duplicate purchases (handy at exhibitions)
- track the total value of your collection
- insure more easily (with proof and an overview)
- search and filter by scale, brand, era, and type
- track locations (box, showcase, drawer, cupboard)
How do you create a good Excel inventory for model trains?
Excel works well, as long as you set it up sensibly from the start. The goal is not "as many fields as possible", but as little hassle as possible in the future.
Step 1: Choose your columns
Start with a fixed column structure. This way you always know exactly what goes where. Below is a practical basis that is sufficient for most collectors.
Essential columns (recommended for everyone)
- Name (name of the model, e.g. "BR 01.10")
- Brand (e.g. Märklin, Roco, Fleischmann)
- Article number
- Scale (HO, N, Z, O)
- Type (locomotive, wagon, set, accessories)
- Era (I to VI)
- Railway company (BR, DB, DR, SNCF, etc.)
- Country (UK, Germany, France, etc.)
- Condition (mint, near mint, used, damaged)
- Storage location (cupboard, drawer, box number)
- Notes (special features, missing parts)
Additional columns (useful for larger collections)
- Purchase date (if you still know it)
- Purchase price
- Current value (estimate or market value)
- Insured value (if you want to track this separately)
- Decoder (analogue, DCC, mfx, Selectrix)
- Sound (yes/no)
- Serial number (if present)
- Packaging (yes/no)
- Maintenance (date of last service)
- Photo link (hyperlink to folder or cloud storage)
Step 2: Turn your list into a proper Excel table
Once your column headings are in place, convert your data into an official Excel table. This automatically gives you filters, consistent formatting, and handy totals.
- Select your columns (including the header row) and choose Insert → Table.
Step 3: Calculate values and summaries in Excel
One of the great advantages of Excel is that you can quickly create totals and overviews. This is useful for insurance, selling, or simply satisfying your curiosity.
- Total purchase amount: use a SUM on your Purchase Price column.
- Total current value: sum the Current Value column.
- Overview by brand or scale: create a pivot table (in Excel: Insert → PivotTable).
- Filter: select, for example, only HO + Märklin + era III.
Would you like to explore valuation further? See our guide on determining the value of model trains.
Practical tips for keeping your Excel file tidy
An Excel inventory works best when you keep data entry strict. That may sound tedious, but it saves you a great deal of searching later.
- Use consistent values: always use "HO", for example, and not sometimes "H0" or "HO scale".
- Use drop-down lists (Data Validation) for scale, type, and condition.
- Make backups: store your file in OneDrive/iCloud or make a copy regularly.
- Note locations clearly: use box numbers such as "Box 12" and put those numbers on your boxes too.
When does Excel become impractical?
A tidy Excel inventory is perfectly manageable. With larger collections, however, an Excel inventory does require more attention. You will notice this, for example, when you need many extra worksheets, or when searching and filtering becomes increasingly complex.
Common warning signs:
- Your file grows and the overview diminishes
- You want to attach multiple photographs to your models, but this requires extra steps in Excel
- You are building ever more complex formulae to gain insight
- You frequently search on combinations (brand + scale + era + decoder)
- You are worried about "breaking" something in your spreadsheet
- You want to look things up quickly on your phone or tablet
Excel or specialist software for your model train collection?
Excel is a good starting point. However, Yard Tower's cataloguing software is built for years of collection management: with photographs, fast search filters, automatic backups, and clear overviews.
In our guide on a model train database you can read how to set up your administration professionally.
When switching becomes the logical choice
Switching is often a smart move when:
- your collection is growing quickly
- value insight becomes more important (also for insurance)
- you want to save time on administration
- you want to store photographs and documents alongside your items
Yard Tower is developed for collectors like you. You can record your data in a structured way, find everything quickly, and store your data securely in the cloud. Curious about what is possible? See all features of Yard Tower.
Would you like to keep your collection more professionally (even if you are still working with Excel)? Start with Yard Tower and build at your own pace.
Frequently asked questions
Is Excel suitable for a small model train collection?
Yes. For around 30 to 50 models, Excel is often sufficient, particularly if you use a consistent column structure and keep your file tidy. Beyond that, the maintenance tends to become more trouble than it is worth. Tip: Yard Tower is free for up to 50 models.
Can I add photographs in Excel?
Yes, but it quickly becomes complicated. It often works better to use a hyperlink to a folder (such as iCloud or OneDrive) rather than pasting photographs directly into the file.
Is Excel sufficient for insurance purposes?
For a small collection, often yes, provided you keep purchase prices and current values neatly recorded. For larger collections, a structured database is more convenient, especially if you also want to store photographs and invoices alongside your items.
What is a good alternative to Excel?
A model train database is built for collectors: fast search filters, photographs per item, value overviews, and automatic backups. It becomes handy once your collection grows and Excel requires too much upkeep.
Conclusion
Inventorying model trains with Excel is a practical first step. Start with the right columns and a proper Excel table, and you will maintain a good overview for a long time, with easy filtering and total calculations.
As your collection grows and you want to spend less time on administration, software developed specifically for model train collectors is often more convenient. Also read our guide on storing and organising model trains to get your entire model train administration in order.