Open both Excel spreadsheets
Decide whether to combine sheets into one workbook or merge data into one sheet
Copy the data from the first spreadsheet
Paste it into a new or existing worksheet in the destination workbook
Copy the data from the second spreadsheet
Paste it below the first dataset or into a separate sheet
Make sure column names match exactly if combining rows
Use Excel’s Data tab and remove duplicates if needed
Sort the combined data if necessary
Use Power Query to append tables if you want an automated merge
Save the merged workbook under a new file name