Model Train Inventory Spreadsheet: A Template and the Columns That Work

RosterCheck

Start here: copy this header row

If you just want to get started, paste this into row 1 of a new sheet in Excel, Google Sheets or Numbers. Use one row per car, with a quantity column for identical cars.

Type,Road Name,Reporting Mark,Road Number,Manufacturer,Item #,Scale,Paint Scheme,Quantity,Purchase Date,Price,Where Bought,Box,Condition,Original Box,Notes

The rest of this guide explains what goes in each column, which columns to fill first, how to sort, how to write road numbers so search works, and which things belong on separate tabs.

It’s written by the developer of RosterCheck, an iPhone roster app that can import a CSV exported from your spreadsheet (view on the App Store).

What this guide covers

  • What goes in each column, and which to fill first
  • How to sort
  • Writing road numbers consistently
  • What to put on separate tabs
  • Spreadsheet vs paper
  • Common mistakes

The columns

In HO Collector, George Riley suggests a spreadsheet with category, scale, manufacturer, item number, description, price paid, acquisition date, new or used, assembly, condition, appraised value, a photo log and notes [1]. The template above keeps most of those and adds the fields you search at a train show (road name, reporting mark, road number) and the one your family needs to find things (box).

Column Example Fill first Used for
Type Locomotive, boxcar, hopper, caboose Yes Filtering and sorting
Road Name Full railroad name Sorting
Reporting Mark Two to four letters Yes Searching
Road Number Digits only Yes Searching, spotting duplicates
Manufacturer Model maker Filtering
Item # From the box label Yes Searching, telling runs apart
Scale N, HO, S, O Filtering
Paint Scheme Name of the scheme Telling sister cars apart
Quantity 1 Identical cars
Purchase Date 2024-05-12 Telling runs apart, insurance
Price Number only Totals, insurance
Where Bought Show or shop name Looking back
Box Tub or case number Yes Finding it
Condition New, used, needs repair Insurance, resale
Original Box Yes / No Insurance, resale
Notes DCC, weathered, kitbash Anything else

You don’t need every column on day one. The “fill first” columns are enough for the two jobs that matter most: finding out whether you own a car, and finding where it is. Fill in the rest as you go.

Keep Item # and Purchase Date together. Riley notes that the item number often changes between runs of the same or a similar product, and that the acquisition date helps identify which run you have [1].

How to sort

Sort by Type, then Road Name, then Road Number. In Excel, Google Sheets and Numbers, that’s a three-level sort.

  • Type first keeps engines and freight cars apart
  • Road Name next shows how many cars of each road you have
  • Road Number last puts identical numbers side by side, so duplicates are easy to spot

Format the Road Number column as text. As a number, leading zeros can disappear and long numbers can turn into scientific notation.

Writing road numbers consistently

North American cars carry a reporting mark of two to four letters and a number of one to six digits; together they identify one car [2]. Splitting them into two columns removes most formatting problems.

How it’s written What happens
One cell: “ABC 1234” Rows drift into “ABC1234” and “ABC-1234,” and find misses some of them
Mark “ABC” and number “1234” in separate columns You can search the number column alone, with or without the mark

Decide once how to handle hyphens or spaces inside numbers, and write the rule in a note at the top of the sheet.

What goes on separate tabs

Putting everything on one tab means unrelated rows get in the way when you search at a show.

Tab Contents Why separate
Rolling stock Locomotives, cars, cabooses, MOW: anything with a road number This is what you search
Accessories Track, buildings, power packs, figures No road number, different columns
Want list Cars you’re looking for, with max price and priority Keeps wants out of your owned list
Boxes Box number, location, free space So family can find things

Spreadsheet vs paper

A paper roster opens instantly, needs no battery or signal, and is fast to write in. It can’t sort, total or search. With a small roster that’s fine, but once you find yourself searching the list at shows and shops, a spreadsheet starts to pay off. You can always print it and carry the paper version too.

Common mistakes

  • Too many columns on day one: empty columns are why rosters stall. Start with the “fill first” set
  • Mark and number in one cell: formatting drifts and search misses rows
  • Road numbers stored as numbers: leading zeros vanish
  • Accessories mixed in with rolling stock: different columns, more clutter
  • No Box column: family can’t find anything, and your insurance list has no locations
  • Not updating the day you buy: the next show starts with an old list

To use this roster at a show, see how to avoid buying duplicates at a train show. To turn it into an insurance list, see what to record in a model train insurance inventory.

Moving your spreadsheet into RosterCheck

A sheet built this way imports into RosterCheck. Export it as CSV (UTF-8) from Numbers, Google Sheets or Excel (in Excel, choose “CSV UTF-8”), then go to Settings → Import from a spreadsheet (CSV) and match the columns. You can set the type, scale and box for all rows at once, and skip rows that look like cars already in your roster.

After import, cars are grouped by box, and Check tells you whether you own a car when you type a road number, item number or reporting mark. A car can be saved with just a number, an item number or a photo, and “Missing info” shows what to fill in later.

Every feature is free, and the free version holds up to 20 cars (accessories, want list items, boxes and shows don’t count). In the free version, a CSV import brings in 20 cars and keeps the remaining rows on your iPhone; Check still tells you when a number might be in them. RosterCheck Pro is a one-time purchase that removes the car limit and the watermark on share cards, and imports the rest (view on the App Store).

Summary

  • One row per car. Fill Type, Reporting Mark, Road Number, Item # and Box first
  • Sort by Type, Road Name, Road Number
  • Keep the mark and number in separate columns, and store numbers as text
  • Accessories, want list and boxes go on their own tabs
  • Update the day you buy

Sources

  1. George Riley, “Planning Ahead: Managing Your Collection,” HO Collector Extra Board (October 2018) https://hotraincollector.com/planning-ahead-managing-your-collection/
  2. Wikipedia, “Reporting mark” (last edited June 14, 2026) https://en.wikipedia.org/wiki/Reporting_mark

(All checked November 9, 2026)


About the sources for this article This article is based on information from public agencies, official sites and specialist media, reorganized by the editors from a recording and organizing perspective. Figures and statements about specifications or safety were checked against primary sources where possible.


This article organizes information from a recording and organizing perspective. If you notice an error or outdated information, please contact us. Last verified: November 2026

Copied title and URL