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
| Method | Data leaves your computer? | Notes |
|---|---|---|
| Excel Power Query (From Folder) | No | Local folders; SharePoint folders stay in your tenant |
| Move or Copy, copy-paste | No | Manual |
| Python or command line | No | Needs some setup |
| Typical online merger | Yes — the file is uploaded | Processed on the provider's servers |
| Browser-local tool (e.g. Analistable) | No | Files 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
- Open the tool in Chrome, Edge or Firefox.
- Press F12 (Cmd+Option+I on a Mac) and open the Network tab.
- Drop a test file into the tool.
- Look for a request whose size is roughly your file size, usually a POST or PUT. If there is one, the file was uploaded.
- 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.
- Tick Preserve log so requests aren't cleared if the page navigates.
- Clear the list just before you drop the file, so only new requests show.
- Filter to Fetch/XHR. Uploads are almost always sent this way.
- 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.
- 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
| The tool says | What 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 all | Assume 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
| Method | Setup | Repeatable | Handles very large files | Skills needed |
|---|---|---|---|---|
| Power Query in Excel | Minutes | Yes, with Refresh | Via the Data Model (Windows) | Basic |
| Move or Copy, copy-paste | None | No | No | None |
| VBA macro | Some | Yes | Up to sheet limits | Coding |
| Python (pandas) | Install Python | Yes | Yes | Coding |
| Browser-local tool | None | Re-drop files | Limited by memory | None |
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.
- Copy the three exports into a folder on the encrypted work laptop, not a personal or synced folder.
- In Excel, run Data → Get Data → From File → From Folder on that folder and click Transform Data rather than loading straight away.
- 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.
- Close & Load, then build the pivot table of overtime by site.
- 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.