How do you merge files in Excel?

Save the Excel files as CSV files, and merge them using the Windows Command Prompt. You can then open the CSV file in Excel and export it in the Excel format. You only need Windows Excel installed on your Windows-based computer to complete the process.

1. Open Excel

   Open Excel from the Windows desktop, and wait for the program to load. Do not create a new file or workbook.

2. Save the files

   Open each Excel file you want to combine, and save them as CSV files. In the Menu bar, click File, then Save As. Change or keep the name of the file, and change the save format to CSV. Repeat this process for each file, and save them all on the C: drive for quick access.

3. Access Command Prompt

   In Windows 7, click the Start button, and type "cmd" in the search field. Click Command Prompt from the list. In Windows 8, use the shortcut "Win" and "Q" keys to open the search menu. Type "cmd" in the text field, and click Command Prompt.

4. Merge the files

   Type "copy *.csv newfile.csv" without quotes in the Command Prompt to combine the files. Replace "newfile" with any name you prefer.

5. Review in Excel

   Open Excel, and then open the combined CSV file. Review the merged file, and save it as an Excel file.