Analistable

How to merge Excel files without uploading them

By the Analistable team · Updated · 6 min read

To merge Excel files without sending them anywhere, use Excel itself (Power Query From Folder or Move or Copy) or a browser tool that processes files locally. You can check any online tool in a minute: open your browser's developer tools on the Network tab, drop a file, and see whether it is sent to a server.

Part of our guide: How to merge Excel files: every method compared

Why it matters

Spreadsheets often hold personal data — customer lists, payroll, patient or student records. Uploading them to a free web service means a third party processes that data. Under GDPR and similar laws, your organisation is responsible for that transfer, and many company policies forbid it. Even when a tool deletes files “after an hour”, the copy existed on someone else's server.

Methods that keep data local

Where your data goes with each method
MethodData leaves your computer?Notes
Excel Power Query (From Folder)NoLocal folders; SharePoint folders stay in your tenant
Move or Copy, copy-pasteNoManual
Python or command lineNoNeeds some setup
Typical online mergerYes — the file is uploadedProcessed on the provider's servers
Browser-local tool (e.g. Analistable)NoFiles are read by JavaScript in your tab

Power Query steps are in combining Excel files into one spreadsheet.

How to check whether a tool uploads your file

  1. Open the tool in Chrome, Edge or Firefox.
  2. Press F12 (Cmd+Option+I on a Mac) and open the Network tab.
  3. Drop a test file into the tool.
  4. Look for a request whose size is roughly your file size, usually a POST or PUT. If there is one, the file was uploaded.
  5. A second check: load the page, switch off Wi-Fi, then try the tool. A browser-local tool keeps working offline.

Use a test file with no real data while you check.

Reading the Network tab

A browser-local tool still makes network requests; what matters is what they carry. When the page loads you'll see its scripts, styles, fonts and, for tools with an in-browser database, one or more .wasm files. These are downloads to your computer, not uploads. After the page has loaded, dropping a file should produce no new request whose size grows with your file.

  1. Tick Preserve log so requests aren't cleared if the page navigates.
  2. Clear the list just before you drop the file, so only new requests show.
  3. Filter to Fetch/XHR. Uploads are almost always sent this way.
  4. Click any request made after the drop and open its Payload (or Request) section. A spreadsheet upload shows as form data or a large binary body.
  5. Try a test file of a few megabytes. A request of similar size is an upload, while small analytics pings are not.

Some tools upload only when you click Merge or Download, not when you add the file. Keep watching through the whole job, including the download.

Reading a tool's privacy claims

What common wording usually means
The tool saysWhat it typically means
“Files are processed in your browser”No upload; verify with the Network tab
“Files are deleted after one hour”Files are uploaded and stored on a server for a time
“Secure upload over HTTPS”Files are uploaded; HTTPS protects them in transit only
“We never share your files”Says nothing about whether they are uploaded or retained
No privacy statement at allAssume upload and storage until proven otherwise

Read the privacy policy for what is stored when you sign in: an account may store settings, file names or usage data even when the file contents stay local.

Local methods compared for sensitive files

Choosing a local method
MethodSetupRepeatableHandles very large filesSkills needed
Power Query in ExcelMinutesYes, with RefreshVia the Data Model (Windows)Basic
Move or Copy, copy-pasteNoneNoNoNone
VBA macroSomeYesUp to sheet limitsCoding
Python (pandas)Install PythonYesYesCoding
Browser-local toolNoneRe-drop filesLimited by memoryNone

For a one-off job on a shared or locked-down computer where you can't install anything, a browser-local tool is often the only option that keeps data local. For a monthly job, Power Query is hard to beat; see combining multiple Excel files automatically.

Files already stored in OneDrive, SharePoint or Google Drive

If your organisation already keeps the files in Microsoft 365 or Google Workspace, merging them inside that service (Power Query on a SharePoint folder, Power Automate, or Google Sheets with IMPORTRANGE) doesn't send them to a new party: the data stays with the provider your organisation already uses. The risk is downloading them and then uploading them to an unrelated free website. Keep the merge inside the same boundary where the files already live, or on your own computer.

Reduce the data before you merge

  • Drop columns you don't need. A merge to total sales by region doesn't need names, emails or addresses. Remove them from the copies you merge.
  • Pseudonymise identifiers where you only need to match rows: replace emails with a customer ID that exists in both files.
  • Filter rows to the period or region in question before combining.
  • Delete intermediate copies when the job is done, including files in Downloads.

If your organisation keeps a record of processing activities, note the tool used, where the processing happened (your device, your tenant or a third-party server) and where the output is stored.

Example: merging three payroll exports

An HR administrator needs one list of overtime hours from three site payroll exports, each holding names, National Insurance numbers, bank details and hours.

  1. Copy the three exports into a folder on the encrypted work laptop, not a personal or synced folder.
  2. In Excel, run Data → Get Data → From File → From Folder on that folder and click Transform Data rather than loading straight away.
  3. In Transform Sample File, use Choose Columns to keep only Employee ID, Site, Period and Overtime hours. Bank details and NI numbers never reach the combined table.
  4. Close & Load, then build the pivot table of overtime by site.
  5. Delete the copied exports from the folder when the report is signed off.

Nothing was uploaded, and the merged output holds no more personal data than the question needed. The same principle applies to any tool: keep the columns that answer the question and leave the rest behind.

How browser-local merging works

The page loads a spreadsheet parser (and, in Analistable's case, the DuckDB database compiled to WebAssembly) into your browser tab. When you drop a file, JavaScript reads it from your disk into memory, combines the rows, and builds the download in the tab. Closing the tab clears it. The Analistable combiner works this way, and our privacy policy describes exactly what is and isn't stored.

What still needs care

  • Browser extensions can read page content. Use a clean profile for sensitive work.
  • Downloads are saved in your Downloads folder like any file; store them according to your policy.
  • Signing in to a tool to save settings is different from uploading data. Read what is stored.

Frequently asked questions

Are online Excel mergers safe?
Many upload your files to their servers. That may be acceptable for non-sensitive data, but check before using them with personal or confidential information.
How can I tell if a website uploads my file?
Open developer tools, watch the Network tab while you add the file, and look for a request about the size of your file. Or test whether the tool still works offline.
Can I merge Excel files offline?
Yes. Excel's Power Query works offline on local folders, and a browser-local tool keeps working after the page has loaded even without a connection.
Does a tool that deletes files after an hour count as not uploading?
No. The file was still sent to and stored on the provider's server for that time. Only processing in your browser or in your own software avoids the upload.

Related guides