Video: Merge Excel Workbooks

This video shows how to merge Excel Workbooks with Withdata ExcelDataTransformer, or with the free Merge Excel online tool.

Merge multiple Excel files: what this does

This shows how to combine many Excel workbooks into one — for example a month's worth of regional spreadsheets, or per-branch exports with the same columns. The video above is the full flow.

Steps

1. Open Withdata ExcelDataTransformer and add the workbooks to merge.
2. Confirm that the sheets share the same columns (header row).
3. Choose whether to stack the rows into one sheet or keep one sheet per file.
4. Decide how to handle the header row — usually keep it once.
5. Run the merge and write the combined workbook.

Merging Excel workbooks: details worth knowing

• Same structure. The files should share the same columns; if headers differ, map or rename them first so rows line up.
• Duplicate headers. Keep the header only once in the output, otherwise repeated header rows end up in the middle of the data.
• One sheet or many. Stacking into a single sheet is best for analysis; one sheet per source file keeps provenance.
• Adding a source column. Add a column with the file name so you can tell which workbook each row came from.
• Dates and text. Merging reads the cell values, so make sure date and numeric columns use the same format across files.
• Scale. A worksheet holds 1,048,576 rows — very large merges should be split, or output to CSV.

FAQ

The workbooks have different sheet names — does it matter?

Only the column headers need to match; sheet names can differ.

Can I tell which file a row came from?

Yes — add a source column during the merge.

Can it handle hundreds of files?

Yes; for very large totals watch the 1,048,576-row worksheet limit.

See the tool page Merge Excel files, or the app overview Withdata ExcelDataTransformer.

More: all ExcelDataTransformer videos · free browser-based converters · online data tools