Merge multiple Excel files into one — in seconds
Pick a folder of spreadsheets, click Run, and get one combined sheet. Columns line up by name, even when every file orders them differently.
Every week the same thing: 20 reports from 20 people, all in separate files, and somebody always moved a column. You open each one, copy the rows, paste them into a master sheet, and hope you didn't miss one. Kita does that whole job in one click — the same way every time.
or download the installer directly
No subscription. The files your tools process stay on your computer.
How it works
-
Get Kita and the tool
Free download, one-click install from the store.
-
Pick a folder, or select the files
Or both — a file chosen twice is merged once.
-
Run
Get one combined sheet in a new file. Your original files are never changed.
What it handles
- .xlsx, .xlsm and older .xls files
- Columns matched by header name, ignoring capitalisation and extra spaces — a column missing from one file just stays blank for its rows
- Every sheet that holds a table is merged; title rows above the header and total rows at the bottom are skipped
- Header colours, fonts, number formats and column widths are kept from the source files
- Nothing extra is added to your data — no helper columns, no labels
- A file that can't be opened is skipped and listed; the rest still merge
Why not Power Query or a macro?
Power Query works, but you have to learn it and rebuild it when the files change. Macros need VBA and often get blocked by IT. Online mergers ask you to upload company data and usually lose the formatting. Kita runs on your PC and you set it up once.
Questions
Do I need to know Excel formulas or VBA?
No. You pick files and click Run.
What if my files have columns in a different order?
Columns are matched by header name, not position, so the order doesn't matter.
Will it merge every sheet in each file?
Yes — every sheet that contains a table. Empty sheets are skipped and listed.
Does it look inside subfolders?
No, only files directly in the folder you pick. You can also select files from different places.
Can I see which file each row came from?
Not in this version — it adds nothing to your data. If you need a source-file column, describe it in Kita and it will build that version for you.
Are my files uploaded?
No. Everything is processed on your computer.
Related tools
-
Split Excel by column
Choose a column like Region or Department, click Run, and get one sheet (or one file) per value, with your formatting intact.
Open tool → -
Compare Excel files
Pick the old file and the new one. Kita lists every new row, every removed row, and every value that changed — old and new side by side.
Open tool →
Stop doing it by hand.
Get Kita, install this tool from the store, and run it on your own files.