Merge multiple CSV files into one Excel workbook To merge multiple CSV files into one Excel sheet, follow these steps: Create a new folder and paste all the CSV files into that. Open the folder.

While there is a way for you to open two Excel workbooks at the same time, you can also open multiple spreadsheets in separate windows. Learn how!