Who is this guide for?

Collector with duplicate entries

You want to establish first whether matching rows are administrative duplicates or represent two genuine items. Microsoft Support warns that Excel can permanently remove selected duplicate values.

Collector with an existing list

You want to transfer or continue managing spreadsheet data while keeping item numbers and other fields intact. Yard Tower Help describes importing and exporting as ways to manage and retain collection data.

Collector with limited desk space

You’re looking for a permanent workspace and weighing up a compact computer against the monitor and connections you need. Manufacturers describe compact desktop models from HP, Lenovo and Apple.

What should you consider when choosing?

Compact Windows desktop with a separate monitor

Choose this option if: you already have a suitable monitor and manage your catalogue in Excel or other Windows software.

Consider: check the connections and which peripherals are included with the exact model; compact computers aren’t always supplied as a complete workspace.

Mac mini with a separate monitor

Choose this option if: your catalogue software works with macOS, such as a web database or Excel for Mac.

Consider: software available only for Windows won’t become compatible just because the Mac mini has plenty of memory or storage.

Larger desktop tower

Choose this option if: you want to use the computer for other tasks too, and compare the configuration and connections of a larger tower.

Consider: the benefits of a larger tower haven’t been established for simply managing a collection, and configurations can vary.

What to consider What should you check? Which consumers is this for?
Check duplicates safely Check whether your software flags matches first. Keep records for each physical item separate, and make a copy before deleting rows. I want to avoid treating two genuine items as one. Around 36% of consumers prioritise safely checking duplicate records when making this choice.
Transfer existing data Check the file format, required field names and whether your chosen software can import your list. If needed, test a small import first. If I want to keep using my existing spreadsheet, the transfer needs to preserve my item numbers and other fields. Around 29% of consumers prioritise data transfer for this reason.
Set up a suitable workspace Make a list of your monitor, cables, keyboard and mouse. Then compare the connections and included components of the exact model. With limited desk space, I want to know whether my computer and monitor will fit together. Around 21% of consumers focus mainly on the workspace as a whole.
Keep your data safe and ensure software support Check your catalogue’s export and backup options, and confirm that the installed operating system is supported. Microsoft says standard support for Windows 10 ended on 14 October 2025. I want to be able to save or move my growing catalogue to another application in future. Around 14% of consumers prioritise export options and a supported computer environment.

Common pitfalls

  • Deleting every matching item number as an incorrect duplicate

    A match in one field doesn’t prove that two physical models are the same item. Excel can permanently remove selected duplicate values.

    Keep a copy and check the details for each individual item before merging or deleting rows.

  • Comparing only the computer tower

    A desktop only becomes a useful cataloguing workspace when paired with a suitable monitor and the peripherals you need.

    Make a list of what you already have for each exact model, then check which other components you’ll need.

    A monitor, cables, input devices or software may need to be bought separately, depending on what you already own and which model you choose.

  • Assuming an older Windows 10 PC will continue to receive standard support

    Microsoft ended standard support for Windows 10 on 14 October 2025. For certain eligible consumer devices, Microsoft describes a separate ESU option.

    Check which version of Windows is installed on the specific device and what support is available for it.

Brands to consider

HP

The Pro Mini 400 G9 is a compact Windows desktop for a workspace with a separate monitor.

  • For model 9H6Z2ET#ABH, HP lists Windows 11 Pro, 16 GB RAM and a 512 GB SSD.
  • These specifications don’t tell you whether your catalogue software needs that much memory or storage.

Lenovo

The ThinkCentre neo 50q Gen 5 is a compact Windows option; check the exact model.

  • For item number 13B9009EEZ, Lenovo lists Windows 11 Pro, 16 GB RAM and a 512 GB SSD.
  • Other configurations are available too, including a model with 8 GB RAM; don’t assume these specifications apply to other models.

Apple

The Mac mini is a compact macOS option if your catalogue software and peripherals are compatible.

  • Apple lists 16 GB of memory and a 256 GB SSD for the base Mac mini M6 model.
  • These specifications don’t confirm that software made exclusively for Windows will work on a Mac.

Dell

The Dell Slim ECS1250 is a larger desktop option with configurable models.

  • Dell describes several configuration options for the Slim desktop.
  • Configuration changes can affect the specifications and delivery date. No benefit has been established for cataloguing alone.

Joybuy desktops for cataloguing

Below are desktops for a model railway catalogue, including Windows all-in-ones, compact Windows desktops and a Mac mini. Choose based on your software, existing peripherals and available workspace.

HP 24-cr0050nd all-in-one desktop with monitor

HP 24-cr0050nd 895R0EA#ABH

Suitable for a permanent workspace where the computer and monitor are combined in one device; the product description also mentions a QWERTY keyboard.

23.8-inch Full HD IPS monitor, 8 GB memory, 512 GB SSD, Windows 11 Home and AMD Ryzen 5 7520U. The power adapter must be purchased separately.

View at Joybuy
SOYO Y5Pro mini PC with Windows 11

SOYO Y5Pro Mini PC

A compact Windows mini PC for a workspace with a separate monitor; check that your current monitor has the connections you need.

Windows 11, Intel Core i5 8250U/8350U, 8 GB DDR4 memory and 256 GB SATA SSD. The description lists HDMI, Gigabit Ethernet and dimensions of 105 × 113 × 45 mm.

View at Joybuy
Apple Mac mini M6 desktop computer

Mac mini Apple M6, 16 GB, 256 GB SSD

Suitable for a Mac-compatible spreadsheet or web-based catalogue workflow and a permanent workspace with a separate monitor. This model runs macOS; software available only for Windows won’t work with it.

Apple M6 chip with 12-core CPU and 12-core GPU, 16 GB memory and 256 GB SSD. The description lists HDMI, USB-C and Ethernet.

View at Joybuy
Lenovo Yoga Mini 01IPH11 compact desktop

Lenovo Yoga Mini 01IPH11 Copilot+ PC

A compact Windows desktop for a workspace with a separate monitor; check which connections your monitor needs in advance.

Windows 11 Home, Intel Core Ultra 5 325, 16 GB LPDDR5X memory and 512 GB SSD. The description lists a 0.65-litre chassis and HDMI 2.1.

View at Joybuy
Lenovo Legion T5 30IAX10 desktop computer

Lenovo Legion T5 30IAX10

A larger desktop tower to consider if you also want to use the computer for other tasks. There’s no evidence that this configuration is necessary for cataloguing alone.

Windows 11 Home, Intel Core Ultra 7, 32 GB DDR5 memory and 1 TB SSD. The product description lists a 30-litre tower case and support for up to four monitors.

View at Joybuy

Frequently asked questions

How can I check for duplicate entries without merging two genuine items?

First flag or filter suspected duplicates, then compare the details in each row, such as the item number and any information about the physical item. Microsoft Support warns that Excel’s ‘Remove Duplicates’ feature permanently deletes data; make a copy of your list first.

Can I import my existing spreadsheet into a model railway database?

It depends on the software you choose and how your file is laid out. Yard Tower Help describes CSV imports of up to 200 items at a time, using specified field names and formats. Check these requirements and test a small import before transferring your entire list.

Do I need to buy a Windows desktop for this task?

Not necessarily: Excel is also available for Mac, and Yard Tower describes a web-based application. However, if you’re considering a Mac, check before buying that your particular catalogue software works with macOS.

What can I do to keep my collection data safe?

Keep a copy of the original list before importing data or removing duplicates. Also check how to export or make another backup from your chosen application; don’t assume the computer itself can automatically restore an earlier version.