# How to Combine Microsoft Excel Spreadsheets

> To combine spreadsheets in Microsoft, select your files, go to Date and Get Data, choose From File and From Excel Workbook, select the file to merge and click Import. Next, choose the workbook sheet, click Transform Data, and then select the Close and Load button to finish.

Canonical: https://livedemo.ai/tutorials/how-to-combine-microsoft-excel-spreadsheets/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3306ab56e05a00fd6e87/preview?step=1

## Steps

1. Select the files which you want to combine.
2. Click "Date," and then select "Get Data."
3. Choose "From File," and hit "From Excel Workbook."
4. Select the specific file you would like to merge with the current one and press "Import."
5. Choose the workbook sheet and then press "Transform Data."
6. Then click the "Close and Load" button.
7. You have now combined the two files in one.