Data fields

Formatting guidelines for import files

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.

Before you start

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.

Available fields

Name

Column name: Name

Quantity

Column name: Quantity

The number of this item you own.

Locomotive quantity

Column name: Locomotive quantity

The number of locomotives this item has.

Railroad car quantity

Column name: Railroad car quantity

The number of railroad cars this item has.

Item number

Column name: Item no.

Barcode

Column name: Barcode

Release year

Column name: Release Year

Company

Column name: Company name

Company number

Column name: Company no.

Lettering

Column name: Lettering

Color

Column name: Color

---

Note

Use the same format for the fields height, length and width as you have set in your account (more info).

By default your account is set to millimetres.

Height

Column name: Height

Length

Column name: Length

Width

Column name: Width

---

Short description

Column name: Short Description

Long description

Column name: Description

Maximum 50,000 characters

Product description

Column name: Product Description

Maximum 50,000 characters

Decoder Manufacturer

Column name: Decodermanufacturer

Important

You can add new decoder manufacturers yourself.

The following decoder manufacturers are available:

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

Decoder

Column name: Decoder

Decoder address

Column name: Decoder Address

Maintenance date

Column name: Maintenance At

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

Date added

Column name: Creation At

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

Purchase date

Column name: Purchased At

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

Sale date

Column name: Sold At

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

Purchase value

Column name: Purchase Value

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

Current value

Column name: Current Value

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

Sales value

Column name: Sales Value

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

Catalogue value

Column name: Catalogue Value

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

Remarks

Column name: Remarks

Category

Column name: Category

Important

You can add new categories yourself.

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

Manufacturer

Column name: Manufacturer

Important

You can add new manufacturers yourself.

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

Era

Column name: Era

Important

You can add new eras yourself.

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

Country

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

Scale

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

Control

Column name: Control

The following values are allowed:

Analog / Digital

Rail system

Column name: Railsystem

The following values are allowed:

2-rail / 3-rail

Ownership

Column name: Ownership

The following values are allowed:

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

Packaging

Column name: Packaging

The following values are allowed:

Alternative / None / Original

Condition

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

Digital functions: F0 to F31

Fields used for digital functions, F0 to F31.

Column name: F0, F1, etc.