Who is this guide for?

Work with large files

You import large survey files and want to take account of available memory and the limits of the software you use. Microsoft Support outlines what to consider when working with large data sets and Excel worksheets.

Rely on specific analysis software

Your choice depends on the programmes, versions and data connectors you need. Microsoft documents Power BI Desktop for Windows and Power Query features in Excel for Mac.

Handle responses that can identify people

When choosing a computer, you also consider the security of your home-working set-up. The Dutch Data Protection Authority stresses that organisations must protect personal data properly.

What should you look for?

First, check that your software and data sources work with the operating system you’ve chosen. Then compare the configuration with your files and the connections available at your home workspace.

What to consider What should you check? Who is this for?
Memory and files Check the file size, number of rows, Excel version and memory of the exact configuration. Also check whether the memory can be upgraded. If I clean up large workbooks, I want to consider both the available memory and the limits of my software. Around 36% of consumers say large files and memory are their main concern.
Software compatibility Make a note of your programmes, versions, file formats and connectors, then check whether they work on Windows or macOS. If my work depends on specific programmes or connectors, I check these before choosing an operating system. Around 29% of consumers say software compatibility is their top priority.
Protecting responses Establish whether responses can identify people, then make sure your device settings and working practices meet the requirements of the organisation responsible for the data. If I handle responses that can be linked to individuals, I want my computer to fit into an appropriately secure working set-up. Around 21% of consumers say this protection is their main concern.
Workspace and what’s included Check which display connections you need, what’s included, whether there’s an adapter and whether a software licence is required. If space on my desk or my budget is limited, I want to know in advance what else I’ll need to get started. Around 14% of consumers put their workspace set-up and total purchase cost first.

Buying pitfalls

  • Opening a large CSV and saving an incomplete view

    Microsoft warns that data beyond the Excel worksheet limit won’t be loaded if you open the file directly.

    Keep the source file intact and check during import that all the source data has been included.

  • Choosing based on the processor alone

    Power BI Desktop has a Windows installation route, while Excel for Mac features may depend on the version and data source.

    Check your programmes, versions and connectors before comparing hardware options.

  • Comparing a barebone model as if all the components were included

    The MINISFORUM Slim series includes barebone and fully equipped models as separate options.

    Check the component list and adapter for the exact model before assuming the computer is ready to use straight out of the box.

    A barebone model may require additional memory, an SSD, an operating system or a suitable adapter.

Brands to compare

ASUS

The ExpertCenter PN55 is described as a Windows 11 Pro mini PC; the listed configuration includes 16 GB DDR5 memory and a 512 GB SSD.

  • ASUS says the memory in this model can be upgraded.
  • Specifications and availability may vary by model and market.

HP

The HP Pro Mini 400 G9 model 6D494EA#ABH is listed with Windows 11 Pro, an Intel Core i5-12500T, 16 GB RAM and a 512 GB SSD.

  • HP lists business security and management features for this product range.
  • Check the configuration and availability of the exact model.

Lenovo

The ThinkCentre M70q Gen 5 Tiny range is designed for compact business workspaces and configurations that are easy to maintain.

  • Lenovo lists tool-free access to the memory and storage.
  • Some features are optional; according to Lenovo, the display, wireless keyboard and mouse are sold separately.

Apple

The Mac mini is an option if the software and data sources you need work on macOS.

  • Apple lists a range of display connection options; configurations may vary in memory and SSD capacity.
  • Microsoft describes Power BI Desktop as a Windows installation, so check first that your analysis software works on macOS.

MINISFORUM

The Slim series includes models such as the UM760 Slim with Ryzen 5 7640HS, available as barebone or fully equipped configurations.

  • The different configuration options may be useful if you want to choose your own components.
  • Check which components and adapter are included with each model.

Joybuy products for this workflow

Here you’ll find both Windows mini PCs and Mac mini configurations. Before buying, check that the software you use to clean your data works with your chosen operating system.

SOYO Y5Pro Mini PC with Intel Core i5-8250U/8350U, 8 GB DDR4 and 256 GB SATA SSD

SOYO Y5Pro Mini PC, Intel Core i5-8250U/8350U, 8 GB DDR4, 256 GB SATA SSD

A Windows 11 configuration to consider if your data-cleaning software runs on Windows; check whether 8 GB of memory is enough for your file sizes.

The product name lists Bluetooth 5.2 and Wi-Fi 5.

Joybuy
Mac mini with Apple M6 chip, 16 GB memory and 256 GB SSD

Mac mini, Apple M6 chip, 16 GB, 256 GB SSD

An option if your data-cleaning software and data sources work on macOS. Check that your exact version of Excel and your connectors are compatible beforehand.

The product name lists a 12-core CPU and a 12-core GPU. This isn’t the direct Windows route for Power BI Desktop.

Joybuy
Mac mini with Apple M6 chip, 16 GB memory and 512 GB SSD

Mac mini, Apple M6 chip, 16 GB, 512 GB SSD

An option if your data-cleaning software and data sources work on macOS. Check that your exact version of Excel and your connectors are compatible beforehand.

The product name lists a 12-core CPU and a 12-core GPU. This isn’t the direct Windows route for Power BI Desktop.

Joybuy
Mac mini with Apple M6 chip, 24 GB memory and 512 GB SSD

Mac mini, Apple M6 chip, 24 GB, 512 GB SSD

An option if your data-cleaning software and data sources work on macOS. Check that your exact version of Excel and your connectors are compatible beforehand.

The product name lists a 12-core CPU and a 12-core GPU. This isn’t the direct Windows route for Power BI Desktop.

Joybuy
SOYO M5 Mini PC with AMD Ryzen 4300U, 16 GB LPDDR4 and 512 GB SSD

SOYO M5 Mini PC, AMD Ryzen 4300U, 16 GB LPDDR4, 512 GB SSD

A Windows 11 Pro configuration to consider if your data-cleaning software requires a Windows environment.

The product name lists HDMI 2.0, Type-C video, DisplayPort 1.4, Wi-Fi 5 and Bluetooth 4.2. Check that the connections suit your displays and peripherals.

Joybuy

Frequently asked questions

Can a faster mini PC open any survey file directly in an Excel worksheet?

No. Microsoft Support lists a maximum of 1,048,576 rows and 16,384 columns per Excel worksheet. More memory won’t change that limit. If you have a larger data set, use the appropriate import method and check that all the source data has been included.

Which mini PC should I choose if I use Power BI Desktop?

Choose a Windows mini PC if you need Power BI Desktop locally. Microsoft describes how to install Power BI Desktop on Windows; also check that the other programmes and connectors in your workflow are compatible.

When can I choose a Mac mini to clean up Excel data?

A Mac mini may be suitable if your exact version of Excel and the connectors you need work on macOS. Microsoft Support documents Power Query features in Excel for Mac; check that they support your data sources and workflow.

Should I install 64-bit Office for large data sets?

Microsoft Support says 64-bit Office may be suitable for large files and data sets on a compatible 64-bit Windows system. Check your add-ins beforehand, as 32-bit and 64-bit add-ins aren’t necessarily interchangeable.

Can I process survey responses that identify people on a home PC without taking any extra steps?

First, assess the relevant agreements and security measures. The Dutch Data Protection Authority says organisations must protect personal data properly, and that pseudonymised data may still be personal data. Whether your specific home-working set-up is suitable depends on the data and who is responsible for processing it.