If you regularly enter item numbers and quantities, a keyboard with a numeric keypad is a natural choice. If space is limited and you rarely enter numbers, a compact model may suit you better. A split keyboard is worth considering for long sessions, although it may take some getting used to. No keyboard can detect duplicate entries on its own: check potential matches in your catalogue software using the relevant fields, and back up your data before deleting any entries.
Who is this keyboard advice for?
Collectors with lots of item numbers
If you regularly record models and quantities, you’ll want to find identifiers quickly and distinguish items you genuinely own more than one of from accidental duplicate entries. Microsoft Support points out that removing duplicate values deletes them permanently.
Collectors with long data-entry sessions
When entering lots of information, the right key layout and enough room for your mouse and arms both matter. The Federal Institute for Occupational Safety and Health highlights the importance of posture, while Perixx notes that split keyboards may take some getting used to.
Collectors with limited desk space
If you mainly type descriptions and rarely use a separate numeric keypad, you could consider a more compact keyboard. CHERRY describes the TKL version of the STREAM KEYBOARD as a model without a numeric keypad.
What should you consider when choosing?
Choose according to the way you actually enter data: how often do you type numbers, how long do you sit at a time, and how much desk space do you have?
| What matters |
What to check before buying |
Who will value this? |
| Entering numbers and checking for duplicates |
Check the German layout, numeric keypad and connection. In your catalogue software, decide which fields identify an entry, then check matches before deleting anything. |
When I enter lots of identifiers and quantities, I want to check potential duplicate entries without deleting models I genuinely own more than one of. Around 36% of consumers put number entry and duplicate checking first. |
| Comfort during long sessions |
Compare the key layout and the space available for your mouse and arms; if you’re considering a split design, bear in mind that it may take some getting used to. |
During longer data-entry sessions, I look at whether the keyboard and workspace suit the way I type. Around 29% of consumers prioritise comfort during long sessions. |
| Desk space |
Consider whether you enter more descriptions or numbers, and check the layout of the specific version. |
If space is limited and I rarely need a separate numeric keypad, I want to keep more room free beside the keyboard. Around 21% of consumers prioritise desk space. |
| Switching between devices and recurring tasks |
Check which devices are supported, the available connection types and whether configuration software is needed. |
If you manage your collection on several computers or want to simplify recurring data-entry tasks, look for suitable connections and software. Around 14% of consumers focus on switching between devices and streamlining these tasks. |
Common mistakes when buying a keyboard
-
Assuming “found twice” means “not needed”
Matching values may point to an input error or to several copies you genuinely own. Microsoft Support explains that removing duplicate values deletes them permanently, and that the result depends on which columns are compared.
First decide which fields identify an item in your collection. Flag and check any matches, and make a copy of the original data before deleting anything.
-
Overlooking the keyboard layout when comparing models
A model range may include versions with different key layouts. The Joybuy product page for the CHERRY STREAM KEYBOARD TKL specifically describes a US layout with a euro sign.
Before buying, check the full model variant and the stated key layout rather than searching by range name alone.
-
Assuming you need a numeric keypad regardless of how you work
A separate numeric keypad can be useful if you regularly enter numbers, but it takes up extra space. The Federal Institute for Occupational Safety and Health identifies actual use of the numeric section as a relevant factor when comparing full-size and compact keyboards.
Think about your data-entry routine: how often do you enter numbers, and how often do you use your mouse or refer to documents? Then choose between a full-size and compact design.
A guide to relevant keyboard brands
CHERRY
The STREAM range includes wired models with and without a numeric keypad.
- According to CHERRY, the STREAM KEYBOARD and STREAM KEYBOARD TKL have the same main key section; the TKL version does away with the numeric keypad.
- Check that the layout and connection of the specific version suit your workspace.
Logitech
The MX Keys S is a wireless keyboard with configurable actions, while the ERGO K860 has a split design and an integrated numeric keypad.
- These features are stated by Logitech. The ERGO K860 combines a split keyboard with a numeric keypad.
- In a review dated 30 October 2025, PC-WELT praised the typing feel of the MX Keys S but described Smart Actions as limited. This assessment applies to this model.
Perixx
The wired PERIBOARD-512 combines a split keyboard with a numeric keypad.
- This design is one option for collectors who would like to try a different key layout.
- Perixx notes that it may take some getting used to. The manufacturer’s claims about health benefits are not independent evidence that it will have the same effect for everyone.
Dell
The KB216 is a wired full-size keyboard for a permanent workstation.
- Dell Germany lists a numeric keypad and USB-A for the black version described.
- These features do not mean that it can detect duplicate collection records.
Keyboards at Joybuy for entering data
This selection includes full-size keyboards with numeric keypads for regular number entry, as well as a split keyboard as a possible option for longer sessions. None of these keyboards can detect duplicate entries on its own; that depends on the catalogue software you use.
No image available
Wired full-size keyboard with numeric keypad, QWERTY
The separate numeric keypad is handy for regular number entry at a permanent workstation.
Full-size design; wired with plug-and-play connection. The product is listed with a QWERTY layout, so check that the key layout suits the way you type.
View at Joybuy
No image available
Wireless keyboard and mouse set, QWERTZ, with detachable wrist rest
The full-size design with separate numeric keypad is made for regular number entry; the wrist rest is an extra feature for longer sessions.
2.4 GHz USB connection; described as compatible with Windows and Mac. The set includes a mouse with a 3-level DPI setting.
View at Joybuy
No image available
CHERRY MX 2.0S, mechanical, full-size, German QWERTZ
The full-size design with German layout is suitable for regular data entry at a permanent workstation.
Wired; listed with MX2A Red switches and RGB lighting. Before buying, check that a mechanical keyboard suits your preferred typing experience.
View at Joybuy
No image available
Logitech ERGO K860, wireless split QWERTZ keyboard
The split key layout is one option for longer data-entry sessions; bear in mind that you may need time to get used to the design.
With integrated numeric keypad and wrist rest; Bluetooth and USB receiver listed as connection options.
View at Joybuy
No image available
AJAZZ AK35I V4, German QWERTZ, three connection types
The full-size design with numeric keypad suits number entry; the different connection types are useful if you want to use the keyboard with several compatible devices.
Bluetooth, 2.4 GHz wireless and USB-C; listed with a 10,000-mAh battery and 1.14-inch TFT colour screen. The product name also specifies hot-swap switches.
View at Joybuy
Frequently asked questions about keyboards for model railway collections
Can a keyboard automatically detect duplicate locomotive or carriage entries?
No, a keyboard cannot detect duplicate entries based on their content. In Excel, you can highlight potential duplicates; according to Microsoft Support, the result depends on which values or columns are compared. Then check whether matching details indicate an input error or several items you own.
How can I avoid accidentally deleting collection data while checking for duplicates?
Make a copy of the original data before removing duplicate values, and check any flagged matches. Microsoft Support points out that removing values deletes them permanently, so first choose the fields that should determine whether an entry is genuinely a duplicate.
What else should I look for in a wireless keyboard?
Check which connection types and devices are supported, and whether the keyboard works with your configuration software. Before choosing a model, also check which accessories are included in the specific set.
How should I dispose of an old keyboard in Germany?
Do not put an old keyboard in your household waste. The German Environment Agency points out that electrical equipment must not go in packaging waste, bulky waste or scrap metal either.