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.
- Open Excel
Open Excel from the Windows desktop, and wait for the program to load. Do not create a new file or workbook.
- 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.
- 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.
- 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.
- Review in Excel
Open Excel, and then open the combined CSV file. Review the merged file, and save it as an Excel file.