- Gather the Excel files to merge.
- Launch the spreadsheet with the files you want to merge.
- In a new sheet, choose the cell you want to start with.
- Go to
Data
and selectFrom other sources
andFrom Microsoft Query.
- Choose the right files from your folders.
- Check the
Append a Copy of the Records to the Existing Table
andFirst Row Contains Column Headers.
- Choose the sheet where the new table is going to be.
- Complete the process by clicking
Finish.
To merge multiple Excel files into one, first collect the Excel files to merge, then launch the spreadsheet with the files to merge. Next, select the cell to start with, then choose Data
and select From other sources
and From Microsoft Query.
Select the right files from your folders, check the Append a Copy of the Records to the Existing Table
and First Row Contains Column Headers.
Choose the sheet for the new table and complete the process by clicking Finish.
