Home › Excel tools › Merge Excel files
Runs in your browserMerge Excel files
Monthly exports, one workbook per branch, a folder of returns that has to become a single file. Add the workbooks and choose whether each keeps its own tab or everything stacks into one table. If two tabs share a name, the second gets its filename added, so nothing is overwritten.
Your file stays on this computer. There’s no upload button here, because there’s nowhere to send it. This tool runs inside the page you opened — like a calculator on a web page, it keeps working once it has loaded. How this works, and how to check it →
How to use it
- Choose two or more .xlsx files. They're merged in the order listed.
- Decide whether to keep every tab separate or stack all the rows into one.
- Click Merge and download the combined workbook.
Questions
Is my file uploaded anywhere?
No. The whole tool is inside this page, so the work happens on your computer. There is no server to send it to. If you'd rather check than take our word for it: use the tool once, on a sample file, with the settings you want. Then turn off your wi-fi and do exactly the same thing again in that tab, without reloading. It still works, because everything it needs is already here.
What happens when two sheets have the same name?
Excel refuses duplicate sheet names, so the second one is renamed using the file it came from. Nothing is dropped or silently overwritten.
Which should I pick — separate tabs or stacked?
Keep tabs separate when the files hold different kinds of data. Stack them when every tab has the same column headings in the same order. If the headings don't match, the merge stops and names the file it found, so nothing ends up under the wrong heading. You can add a column naming the source file when stacking.
Do formulas and formatting survive?
Values do. Formulas become their last calculated result, and colours, widths and conditional formatting do not carry over. A formula referring to a sheet that moved would break anyway, so the value is the safer thing to keep.