Preserve the original and review the mapping
Import a Model Train Inventory from CSV or Excel
A safe import begins before upload: preserve the original file, clean the headers, use one item per row, and review how each column maps to the destination.
Keep an untouched source file
Make a copy before changing columns, values, or formatting. The original is your recovery point and evidence of what existed before migration. Work from a duplicate created specifically for import.
Use one row per inventory item
Give each row a stable identifier where possible. Put different facts in separate columns: manufacturer, model number, scale, road name, road number, category, condition, location, acquisition date, purchase cost, value, and notes. Avoid merged cells, decorative headings, formulas that return errors, and multiple tables on one sheet.
Normalize values before mapping
- Use consistent category and condition terms.
- Separate currency symbols from numeric values when required.
- Use unambiguous dates.
- Remove blank trailing rows and hidden scratch columns.
- Identify duplicate rows before import.
- Decide how wishlist and disposed records should be represented.
Preview, test, and correct
Map source columns to TIM fields, review warnings, and begin with a small representative sample. Confirm that categories, dates, values, ownership status, and notes landed correctly before processing the full file. Correct rejected rows in the working copy while preserving the original.
Follow Importing Inventory from CSV or Excel for current formats and product limits.
Handle photographs and related records separately
A flat spreadsheet may contain filenames or links but not the files themselves. Plan how photographs, receipts, manuals, maintenance history, installed components, and valuation evidence will be attached after the core item records are imported.
Validate the result
Compare record counts, spot-check several categories, search for missing manufacturers or road numbers, and review the dashboard for unexpected values. Keep the source file until you have completed a separate export or backup of the imported inventory.
Keep your model railroad records useful
Train Inventory Manager brings collection records, photographs, documents, values, storage, DCC information, maintenance, and reports together in one private web application.