How Do You Merge Files in Excel?

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.