What this tool can do
- Combine many Excel files created in the same format into one file.
- Copy cell values, fonts, fill color, and number formats within the specified range.
- Files cannot be combined if rows or columns have been added or deleted relative to the base file.
How to use
- Select the base file and confirm the target worksheet.
- Select many Excel files to combine (multiple selection is supported).
- Specify the range to compare with the base file.
- Specify the upper-left and lower-right cells of the data range.
- Click “Check Data”; after confirming there are no issues, click “Combine”.
- Review the result and click “Save” to save the file.
1. Base file
Click or drop your file here
2. Files to combine
click or drop your files here
3. Base-file comparison range
Upper left (start)
Lower right (end)
This range is treated as a protected comparison area. Combination stops if an input file differs from the base file. It is used to detect shifts caused by added or deleted rows or columns.
4. Data combination range
Upper left (start)
Lower right (end)
The rectangular area from the start cell to the end cell is combined. Values, fonts, fill color, and number formats are copied.
5. Combine
Run “Check Data” first. “Combine” becomes available only when no issues are found.
Status: Ready
6. Result
Save the combined result using the button below.
0Number of input files
0Number of conflicts
0Number of revise
No result yet
Scope and notes
This tool supports .xlsx files and combines cell values, fonts, fill color, and number formats. Macros, external links, shapes, images, charts, pivot tables, conditional formatting, comments, slicers, and similar features may not be fully preserved. Formulas are loaded as formulas but are not recalculated in the browser. Keep the original files and verify the output before using it for important work.
This website accepts no responsibility for the results produced by this tool. Review and use the output at your own responsibility.
This website accepts no responsibility for the results produced by this tool. Review and use the output at your own responsibility.