Skip to content

Data fields

When you import items into Yard Tower, each column in your import file must correspond to a field in Yard Tower. Some fields such as scale, manufacturer, era, country, category, packaging, condition and dates must adhere to a specific format to import them correctly.

On this page you’ll learn how to format each column correctly so you get the best results when importing.

  1. The only field that Yard Tower requires is Name. Other fields are optional but will make your collection complete.
  2. Column names must be in English as described for each field.
  3. You can place the columns in any order in your file.
  4. Place a decimal number always between quotation marks, for example : “1,200.99”
  5. If you don’t add the Ownership column, it will be set to owned by default.

Column name: Name

Column name: Quantity

The number of this item you own.

Column name: Locomotive quantity

The number of locomotives this item has.

Column name: Railroad car quantity

The number of railroad cars this item has.

Column name: Item no.

Column name: Barcode

Column name: Release Year

Column name: Company name

Column name: Company no.

Column name: Lettering

Column name: Color


Column name: Height

Column name: Length

Column name: Width


Column name: Short Description

Column name: Description

Maximum 50,000 characters

Column name: Product Description

Maximum 50,000 characters

Column name: Decodermanufacturer

The following decoder manufacturers are available:

Bachmann / ESU / Fleischmann / Hornby / Kato / Kuehn / Lenz / MTH / Märklin / NCE / PIKO / Tams / Uhlenbrock / Viessmann / ZIMO

Column name: Decoder

Column name: Decoder Address

Column name: Maintenance At

Use the ISO standard year-month-day format (YYYY-MM-DD) for this field.

Column name: Creation At

Use the ISO standard year-month-day format (YYYY-MM-DD) for this field.

Column name: Purchased At

Use the ISO standard year-month-day format (YYYY-MM-DD) for this field.

Column name: Sold At

Use the ISO standard year-month-day format (YYYY-MM-DD) for this field.

Column name: Purchase Value

Use the following format for this field: 1,234.56 or 88

Column name: Current Value

Use the following format for this field: 1,234.56 or 88

Column name: Sales Value

Use the following format for this field: 1,234.56 or 88

Column name: Catalogue Value

Use the following format for this field: 1,234.56 or 88

Column name: Remarks

Column name: Category

The following categories are allowed:

Accessories / Analog control / Auto Transport Car / Baggage Car / Ballast Car / Bilevel car / Books / Boosters / Boxcar / Cargo box trolley / Cars / Catalog / Christmas wagons / Coach car / Coal wagon / Commuter Car / Container car / Covered Wagon / Crane car / Decoders / Depressed Center Flat Car / Diesel locomotives / Digital control / Dining car / Electric locomotives / Elektronics / Figures / Flat Car / Gondola / Hinged Roof Car / Hopper car / Landscape / Lighting / Livestock Car / Low Side Car / Manual / Observation car / Occupancy Detection / Other / Other / Other / Other / Other / Overhead catenary / Passenger cars / Power Supply / Rail Car Diesel / Rail Car Electric / Rail Car Petrol / Rail Car Steam / Railway Post Office Car / Refrigerator Car / Signals / Silo wagon / Sleeping car / Sliding Wall Boxcar / Stake Car / Start Sets / Steam locomotives / Tankcar / Track Cleaning Car / Tracks / Train Sets / Tram vehicle / Type Rails Sliding Tarp Car / Workshop Equipment Car

Column name: Manufacturer

The following manufacturers are available:

A.C. Gilbert Company / A.C.M.E. / ADE / AR Kits / AVT Products / AWM / Accurail / Accurascale / Airfix / Albedo / Alfred Riess / American Flyer / Amintiri Feroviare / Aristo-Craft Trains / Arnold / Artitec / Athearn / Atlas / Atlas Model Railroad / Auhagen / Ausicison Models / Austrains / Austrains NEO / B-T Models / B-models / BEC-KITS / BEMO / Bachmann Branchline / Bachmann Industries / Bassett-Lowke / Bavaria / BeKa / Berliner TT Bahnen / Bilger Modelleisenbahn / Bing / Bisschop Modelbouw / Bob's Hobbies and Models / Bowser / Bowser Manufacturing / Brawa / Brekina / Brimalm Engineering / Broadway Limited Imports / Busch / Busch / Con-Cor / Corgi / Crafftiq / Custom Build / DC-Car / DJH Model Loco / DMV / Dahmer / Dapol / Dekas / Del Prado / Digikeijs / Digirails / Dingler / Dolischo / Edward Exley Limited / Egger-Bahn / Eisenbahn Canada / Electrotren / Elotrains / Emek Trucks / Emtepe HAB / Entec / Esu / Etecmo / Eureka Models / EuroTankCar / Eurotrain / Exact-Train / ExactRail / FERRO-TRAIN / Fairfield / Faller / Ferivan Modelbouw / Fine Art Models / Fine Models / Fleischmann / Frateschi / Fulgurex / G & R Wrenn / GM&S / GPP / Golden Age Models Limited / Golden Oldies / Graham Farish / Great West Models / Grell / Günther / Gützold / Gützold / HAG / HAMO / HEMA / HNoll / Haber & Koenig Electronics / Halling / Hamann / Hartlan Locomotive Works / Haskell / Heinzl / Heljan / Heris / Herpa / Hobbex / Hobby Teknik / Hobby Trade / Hobbytrain / Holland Rail DKM / Hornby Railways / Hufing Tronic / Hädl / Hödl Linie-8 / Hübner / Ibertren / Igra Model / Imperial Hobby Productions / Intermountain / International Hobby Corp. / Irish Railway Models / Italeri / Ives Manufacturing Company / Jaegerndorfer / Janstramo / Jatt / Jeco / Jouef / K-Line / KM-1 / KRES / KTM / Kadee / Kader / Kato Precision Railroad Models / Kato Unitrack / Key Imports / Keyser Modell Kits / Kibri / Kiss-Modellbahnen / Klein Modellbahn / Kleinbahn / Kleinspoor / Kombimodell / Kuehn-modell / L.S. Models / LGB / Leeds Model Company / Lemaco / Lematec / Lemke / Lenz / Lesney / Life-Like / Liliput / Lima / Lion Toys / Lionel Corporation / Lionel LCC / Littfinski DatenTechnik / Lledo Models / Lucky Life / Luetke Modellbahn / Lux Modellbau / M&L / M+D / M+F / MBW / MDS Modell / MSE / MTB / MTE / MTH Electric Trains / MTR-Exclusive / Mabar Tren / Mafen / Mainline / Mantua / Marklin 4MFOR / Marx / Mastica / McK / Mehano / Merten / MiNis / Miber / Micro Metakit / Micro-Trains Line / Miniart / Minitrains / Minitrix / Mistral Train Models / Model Power / Modellbahn Union / Modellbau Wolfgang Baumann / Modellelectronic Fritzsch / Modellproduktion / Modemo / Murphy Models / Märklin / NME / NMJ / NOCH / NPE / Navemo / Nigel Lawton 009 / Norsk Modelljernbane / OcCre / Olaerts / One87 / Ortwein / Os.Kar / Other / Overland Models / Oxford / Oxford Rail / PB Models / PECO / PIKO / PMT / Technomodell / PSK Modelbouw / Peco / Pein / Penn Line Manufacturing / Perl Modell / Perlmodell / Phildie / Philotrain / Pocher / Pola / Powerline model railway / Precision Scale Co. / Prefo / Preiser / Primex / Proform Spur1 / REE Modèles / RK Modell / ROBO Modele / Rai-Mo / Rail-Kees / RailAd / RailTop / Railex / Rapido / Rapido Trains / Regner / Rietze / Rimbo Grande / Rio Grande Models / Rivarossi / Rocky-Rail / Roco / Rokal / Rokuhan / Roozen / Roskopf / Rosoft / Roundhouse / Ruco / Röwa / SDS Models / SES Berlin / SOWA-N / STL-Models / Sachsen Modelle / Sachsenmodelle / Scaletrains / Schicht / Schirmer / Schuco / Schönlau / Skanex / Slater's Plastikard / Southern Rail Models / Spectrum / Spur-1 / Spur1-Exklusiv / Stewart Hobbies / Stralis / Streetsystem / Stängl / Sudexpress / TACO Models / TACO-MESU / TDS / THS / THS-Realix / THS-TACO / Tams Elektronik / Tekno / Tekno-Bygg / Temsi / Tenmille / Tenshodo / Ti-H0 / Tichy-Train / Tillig / Tilly Models / Tomix / TouchRail / Trainman / Tri-ang Railways / Trix / Trix Express / Tyco Toys / UGJ / USA Trains / Uhlenbrock / VanBiervliet / Varney Scale Models / Verbeck / ViTrain / ViTrains / Viessmann / Vollmer / WSI Models / Walthers / WeKra / Weinert-Modellbau / Westmodel / Wiking / Williams Electric Trains / Woodland Scenics / Worsley Works / Wunder Präzisionsmodelle / Wörner / YaMoRC / Zeuke

Column name: Era

The following eras are allowed:

I / II / III / IIIa / IIIb / IIIc / IIa / IIb / IIb / IIc / IV / IVa / IVb / IVc / Ia / Ia/b / Ib / Ib/c / Ic / Id / Ie / If / V / VI / VII / Va / Vb / Vc

Column name: Country

The following countries are allowed:

Algeria / Argentina / Australia / Austria / Azerbaijan / Bangladesh / Belarus / Belgium / Brazil / Cameroon / Canada / Chile / China / Colombia / Croatia / Czech / Czech / Denmark / Egypt / Estonia / Finland / France / Germany / Greece / Hungary / India / Indonesia / Iran / Ireland / Israel / Italy / Japan / Kazakhstan / Kenya / Latvia / Lithuania / Luxembourg / Malaysia / Mauritania / Mexico / Morocco / Netherlands / New Zealand / Nigeria / Norway / Pakistan / Poland / Portugal / Romania / Russia / Saudi Arabia / Serbia / Slovakia / South Korea / South Africa / Spain / Sudan / Sweden / Switzerland / Thailand / Tunisia / Turkey / Turkmenistan / Ukraine / United Kingdom / United States of America / Uzbekistan / Vietnam

Column name: Scale

The following scales are allowed:

0 / 00 / 0e / F / Fn3 / H0 / H0e / H0e / H0n3 / HO / HOm / HOn2 / HOn3 / HOn30 / I / II / III / LS / LSn3 / N / N / Nn2 / Nn3 / O / OO / On2 / On3 / On30 / S / S / Sn3 / TT / TTn3 / TTn42 / V / VII / X / Z / Z

Column name: Control

The following values are allowed:

Analog / Digital

Column name: Railsystem

The following values are allowed:

2-rail / 3-rail

Column name: Ownership

The following values are allowed:

for sale / no longer in possession / on wishlist / owned

Column name: Packaging

The following values are allowed:

Alternative / None / Original

Field used to indicate the quality of an item.

Column name: Condition

The following values are allowed:

Excellent / Fair / Good / Mint / Near mint / Poor / Very good

Fields used for digital functions, F0 to F31.

Column name: F0, F1, etc.