People cleaning up large workbooks
If you import and check survey data using Excel or Power Query, consider file size, your workflow and the software available together. Microsoft Support sets a limit of 1,048,576 rows per Excel worksheet.
Choose your laptop based first on the analysis software you need and the kind of data work you do, then on the ports available at your shared desk. If you need to run Power BI Desktop locally, a Windows laptop is the obvious choice. A MacBook Air could work if your Excel and Power Query tasks are compatible with macOS and the dock and peripherals are suitable. If you spend long periods working at a screen or handle personal data, you should also check workplace ergonomics and data protection requirements separately.
If you import and check survey data using Excel or Power Query, consider file size, your workflow and the software available together. Microsoft Support sets a limit of 1,048,576 rows per Excel worksheet.
If you take your laptop between workstations, make sure it has the right connections for your monitor, input devices and power. For fixed-location screen work, the Federal Institute for Occupational Safety and Health’s ASR A6 specifies a separate keyboard and, depending on the task, a separate mouse.
If your workflow depends on particular programmes or data sources, check they’re compatible before choosing an operating system. Microsoft describes Power BI Desktop as a Windows application; the Power Query features available depend on your version of Excel.
A good fit if: you use Power BI Desktop locally or regularly move between workstations with a fully equipped shared desk.
Things to weigh up: Windows takes care of the operating system requirement for Power BI Desktop, but RAM and USB-C alone don’t guarantee performance with your files or compatibility with every dock.
A good fit if: your required programmes and data sources work with macOS and your version of Excel, and you want a compact device.
Things to weigh up: Power Query is available for Excel on Mac, but supported data sources and features vary by version. Microsoft describes Power BI Desktop as a Windows application.
| Criterion | What to check before buying | Who it matters most to |
|---|---|---|
| Workbooks and data cleaning | Test a representative file and your import process. Microsoft Support sets a limit of 1,048,576 rows per Excel worksheet; more RAM won’t change this. | If you clean large survey files and run several tasks at once, processing power comes first. Around 26% of consumers prioritise data work. |
| Required software | Check your programmes, existing queries and data sources against the intended operating system and specific software version. Microsoft describes Power BI Desktop as a Windows application. | If your workflow depends on specific analysis programmes or existing queries, compatibility matters more than a general preference for a particular brand. Around 21% of consumers prioritise software compatibility. |
| Connecting at a shared desk | Check the monitor connection, display output, charging power, dock and peripherals for the exact model. For fixed-location screen work, ASR A6 from the Federal Institute for Occupational Safety and Health specifies a separate keyboard and, depending on the task, a separate mouse. | If you often connect your laptop at a shared desk, make sure it works with the specific monitor and input devices. Around 21% of consumers prioritise shared-desk connectivity. |
| Moving between workstations | Compare the dimensions, weight and power supply of the exact variant. A manufacturer’s battery-life figure isn’t a test of your own data workflow. | If you often take your device between workstations, a manageable size and weight are essential. Around 16% of consumers put portability first. |
| Personal data | If your files contain personal data, check your organisation’s requirements and the technical and organisational measures you need. The Federal Commissioner for Data Protection and Freedom of Information explains that these measures must be appropriate to the level of risk. | If your survey data is subject to specific protection requirements, your device and workflow need to meet them. Around 16% of consumers prioritise data protection requirements. |
Microsoft distinguishes the fixed row limit of a worksheet from restrictions caused by available memory and system resources. More RAM won’t remove the row limit.
Check the file format, row count and actual import process before choosing a device solely because it has more RAM.
A matching connector alone doesn’t tell you whether the video signal, power supply and connected devices will work with your dock.
Check your monitor, dock and charging requirements against the exact laptop configuration.
Depending on the equipment you already have, you may need a suitable dock, adapter or power supply. For the Pro 14 PC14250 configuration shown, Dell specifically states that no power supply is included.
Power Query is available for Excel on Mac, but supported data sources and features vary by version. Microsoft describes Power BI Desktop as a Windows application.
Check the queries, connectors and programmes you need before choosing an operating system.
The ThinkPad E14 Gen 7 (AMD) is a configurable family of business laptops for data work and connecting external monitors.
The Dell Pro 14 PC14250 is a 14-inch Windows business laptop for use at a shared workstation.
The ProBook 4 G1i 14 is a Windows business laptop with ports for a fully equipped desk.
The 13-inch MacBook Air with M5 is an option if your data tools work with macOS and you’re looking for a compact device.
This selection includes laptops for data work at a shared desk. For each model, check that the operating system, ports and specific configuration suit your workflow.
No image available
Could be worth considering if you’re looking for a Windows business laptop with specified monitor ports for a shared desk.
The product details list an AMD Ryzen 3 PRO 7335U, a 16-inch WUXGA IPS display, AMD Radeon 660M and Windows 11 Pro Education.
Listed features include 16 GB DDR5, a 512 GB SSD, USB4, HDMI 2.1, RJ-45 and an included 65 W USB-C power supply. Check compatibility with your specific dock.
No image available
Could suit you if you’re looking for a configuration with 32 GB of RAM and 1 TB of storage for data work, as well as ports for a fully equipped workstation.
The product details list an AMD Ryzen 7 250, Windows 11 Pro, 32 GB DDR5 and a 1 TB SSD.
Listed ports include HDMI 2.1, USB4-C, USB-A and RJ-45, plus an included 65 W USB-C power supply. Check that the ports work with your monitor and dock.
No image available
Could be an option for desk-based data entry if the listed specifications and ports suit your workflow.
The product name lists 16 GB DDR4 and a 512 GB SSD. The description specifies an AMD 3050e processor and an FHD IPS display.
Listed ports include USB-C and an HDMI output; the description also mentions a keyboard with a number pad. Check it’s suitable for the programmes you need and your shared desk setup.
No image available
Could be worth considering if you’re looking for a 16-inch laptop with a German keyboard for your data work.
The product name lists an AMD Ryzen 5 6600H, 16 GB of RAM, a 512 GB SSD and a German keyboard. Check the ports and software compatibility for your workplace.
No image available
Could suit a mobile macOS workflow if the programmes and data sources you need work with the Mac and your version of Excel.
The product details list a 10-core CPU, an 8-core GPU, 16 GB of memory, a 512 GB SSD and a German QWERTZ keyboard.
Specifications include a 13.6-inch display, two Thunderbolt 4 ports, a weight of 1.23 kg and support for up to two external displays. According to the product description, a power supply isn’t included. Check compatibility with your dock and monitor.
According to Microsoft Support, an Excel worksheet can contain a maximum of 1,048,576 rows. If your raw data exceeds this or your queries need a lot of resources, check the actual import and cleaning process; more laptop RAM won’t change the worksheet limit.
For portable screen equipment used at a fixed location, ASR A6 from the Federal Institute for Occupational Safety and Health specifies a separate keyboard and, depending on the task, a separate mouse. Whether these requirements apply to your specific workstation depends on how it’s used; they aren’t a general minimum requirement for every laptop bought for personal use.
Check the monitor connection, display output, power supply and peripherals against the exact laptop model and dock. A matching connector shape alone doesn’t guarantee that your complete workstation will work.
For consumer purchases, statutory rights relating to faulty goods are generally against the seller; a voluntary guarantee is separate. According to the consumer advice centre, online consumer contracts generally come with a 14-day right to cancel, which must be explained to you. If you’re buying for self-employed or business use, check separately whether consumer rules apply.
If you process personal data, controllers and processors must put appropriate technical and organisational measures in place under the GDPR requirements explained by the Federal Commissioner for Data Protection and Freedom of Information. These should also guard against unauthorised access. The appropriate measures depend on the dataset and your organisation’s requirements; don’t assume that data is personal without checking.