Anyone cleaning large survey files
If you check many rows, combine sources or repeat tasks, it’s worth comparing file size, software version and available system resources first. Microsoft Support explains both Power Query and Excel’s limitations.
Start by considering the size of your files and the software you use to process them. A larger screen gives you more workspace built in, while a more compact model is easier to carry between shared desks. Also check that your version of Excel and any Power Query workflows are compatible. If responses can be linked to individuals, your security approach should reflect how the data is processed and the organisation’s requirements.
If you check many rows, combine sources or repeat tasks, it’s worth comparing file size, software version and available system resources first. Microsoft Support explains both Power Query and Excel’s limitations.
If responses could be linked to individuals, your workspace and data processing should align with your organisation’s risk assessment. The Dutch Data Protection Authority stresses that appropriate security measures can vary depending on the processing involved.
If you carry your laptop between shared workspaces, you can weigh the built-in screen space against a more compact size. The HP ProBook configuration reviewed has a 16-inch screen, while the Lenovo ThinkPad E14 configuration reviewed has a 14-inch screen.
| What to consider | What to look for | Who is this important for? |
|---|---|---|
| File size and repeatable data cleaning | Test a representative file and check your version of Excel, the tasks you need to perform and the system resources available. | If I combine large files or repeat data-cleaning tasks, I want to know whether my software and configuration are up to the job. Around 33% of consumers prioritise file processing. |
| Protecting responses that can identify people | Ask what access permissions, screen locking, encryption, updates and backups your organisation requires. | If responses can be linked to individuals, I want to set up my workspace in line with my organisation’s security approach. Around 27% of consumers prioritise this protection. |
| Workspace when moving between desks | Compare screen sizes and check that the ports work with an external monitor or dock. | If I work at different desks, I weigh a generous built-in screen against a laptop that’s easier to carry around. Around 20% of consumers consider this workspace trade-off the most important factor. |
| Compatibility with your analysis workflow | Check that your version of Excel, data sources, queries and any additional analysis tools work with the operating system you choose. | If I want to keep using existing queries and programmes, I want to know the whole workflow will work before buying. Around 20% of consumers prioritise this compatibility. |
Worksheet limits and restrictions in the version of Office you use are not the same as the amount of memory in a laptop. Microsoft Support states that each worksheet is limited to 1,048,576 rows, and notes that open workbooks are also limited by the system resources available.
Start by testing a representative file and the tasks you need to perform. Then compare configurations.
Appropriate security depends on the data and the risks involved in processing it. A single laptop feature does not prove that your chosen way of working is appropriate.
Align settings, access and storage with your organisation’s risk assessment and working practices. The Dutch Data Protection Authority lists security measures as examples that should be assessed for each type of processing.
Microsoft documents Power Query for Excel on Mac, but specifies a version requirement for the editor. Existing data sources and additional programmes also need to be checked for compatibility separately.
Test a representative data-cleaning workflow on the platform you’re considering before making a choice.
Adapting queries or arranging a suitable software version may take extra time.
The ProBook 4 G1i configuration reviewed is a business-focused Windows option with a larger built-in workspace.
The ThinkPad E14 Gen 7 configuration reviewed is a more compact business-focused Windows option.
The MacBook Air is a macOS option if it’s compatible with the office workflow you need.
The Dell Pro Essential range is another business-focused Windows option to compare.
This product selection includes Windows laptops with larger or more compact screens, as well as a MacBook Air for workflows that are compatible with macOS. Compare the specifications with your files, software and workspace.
No image available
A 16-inch screen gives you a generous built-in workspace for checking tables.
Intel Core Ultra 5 135H, 16 GB DDR5, a 512 GB SSD and Windows 11 Pro.
The WUXGA screen has an anti-glare IPS finish. Ports include USB-C/Thunderbolt 4, USB-A, HDMI and Gigabit Ethernet.
No image available
A 16-inch screen gives you built-in space for reviewing tables.
32 GB memory, a 1 TB SSD and Windows 11 Pro.
This configuration has a 3K OLED touchscreen with a 16:10 aspect ratio and 120 Hz refresh rate.
No image available
The 14-inch size is a more compact screen option if you move between workspaces.
Intel Core 7 150U, 16 GB DDR4, a 512 GB SSD and Windows 11 Home.
The anti-glare screen is an IPS-Level model. Listed ports include USB-C, USB-A and HDMI.
No image available
This macOS configuration has a 15.3-inch screen. Before buying, check that your queries and other software work with your Mac workflow.
16 GB memory, a 512 GB SSD and two Thunderbolt 4 ports.
Microsoft lists version 16.69 or later for the Power Query editor in Excel for Mac. The adapter is not included; the product description states that a 35 W or higher USB-C adapter is required.
No image available
The 14-inch size is a compact option for changing workspaces.
16 GB RAM, a 512 GB SSD and Windows 11 Home.
This configuration has a WUXGA OLED screen with a 16:10 aspect ratio, USB4 Type-C and HDMI. The product description lists a weight of approximately 0.98 kg. A compatible 65 W USB-C Power Delivery charger is required and not included.
Not simply because of the task name. Test a representative file and check the tasks you need to perform and the software limitations. Microsoft Support states that Excel worksheets are limited to 1,048,576 rows; the system resources available can also affect open workbooks.
If survey responses contain personal data, ask your organisation to assess the risks and decide on appropriate measures. The Dutch Data Protection Authority lists accounts, access permissions, updates, backups and encryption as possible measures. Which measures are suitable depends on the processing involved.
Yes. Microsoft documents Power Query for Excel on Mac. For the Power Query editor, Microsoft specifies Microsoft 365 subscriptions with Excel for Mac version 16.69 (23010700) or later. Also check that your data sources, queries and other programmes work with your own workflow.
For a consumer purchase, Dutch statutory warranty may apply if a product does not meet what the buyer could reasonably expect. ACM ConsuWijzer distinguishes purchases used mainly or exclusively for business purposes. If that applies to you, check the terms of sale and service that apply to your purchase.
No, not if the remaining responses can still be linked to individuals. The Dutch Data Protection Authority notes that pseudonymised data can still be personal data; it must also be protected appropriately.