Combine multiple Excel files into one sheet

Your files never leave your computer: everything runs in your browser.

If every month, quarter or teammate sends their own spreadsheet, stack them here into a master sheet. Columns with the same header are matched even if they're in a different order.

How to use it

Drag in your .xlsx or .xls files; the first in the list goes on top.
Press Consolidate.
CONSOLIDATED.xlsx downloads with every row on the Master sheet.

📘 Full guide with examples

Frequently asked questions

Which sheet of each file is used?

The first one. If your data is on another tab, move it to the first position.

What if the headers don't match?

Different columns are added at the end and left empty for rows without them. Make sure headers are spelled the same.

`º` / `Tab`	SHIFT / ALPHA (luego la tecla: `º7` = CONST)SHIFT / ALPHA (then the key: `º7` = CONST)
cos( sqrt( int(	Escribe el nombre de la función: sin/sen, cos, tan, asin, log, ln, exp, sqrt/raiz, cbrt, abs, int (integral), der (derivada), sum, prod, pol, rec, mcd, mcm, det...Type the function name: sin, cos, tan, asin, log, ln, exp, sqrt, cbrt, abs, int (integral), der (derivative), sum, prod, pol, rec, gcd, lcm, det...
pi e ans x A	π, número e, Ans, variable x; mayúsculas A–F y M son las memoriasπ, number e, Ans, variable x; capitals A–F and M are the memories
`,` `)`	En 2D la coma pasa al siguiente hueco y ")" sale de la plantilla: int(x^2,0,1)In 2D the comma jumps to the next box and ")" leaves the template: int(x^2,0,1)
`-` `~`	El menos es signo negativo al principio o tras un operador (5--3, 2-4); `~` lo fuerzaMinus is a negative sign at the start or after an operator (5--3, 2-4); `~` forces it
`=` `Enter`	`=` escribe el igual (CALC, SOLVE, Verificar); `Enter` calcula; `Shift`+`Enter` en decimal`=` types the equals sign (CALC, SOLVE, Verify); `Enter` calculates; `Shift`+`Enter` as a decimal
`^` `!` `%` `\|`	Potencia, factorial, porcentaje, valor absolutoPower, factorial, percent, absolute value
`Inicio` `Fin`	MENU y OPTN · `Supr`/`Esc` = AC · `⌫` = DELMENU and OPTN · `Del`/`Esc` = AC · `⌫` = DEL

Combine multiple Excel files into one sheet

Unir PDFs

How to use it

Frequently asked questions

More tools