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.