Quick summary
This tutorial shows how to combine multiple Microsoft Excel spreadsheets into a single workbook using the Get Data and Power Query workflow. Follow the step-by-step process to import, transform, and merge Excel files without copying and pasting data manually.
Steps
- Select the files you want to combine.
- Click "Data" in the ribbon, then select "Get Data."
- Choose "From File," then click "From Excel Workbook."
- Select the specific Excel file you want to merge with the current one, then press "Import."
- Choose the workbook sheet you want to load, then press "Transform Data."
- Click the "Close and Load" button to bring the data into your spreadsheet.
- Your two Excel files are now successfully combined into one.
