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. Right-click on an empty space and select the Open ...

Launch Microsoft Office Excel 2007 and open the spreadsheet that you wish to save in CSV format. Use the "Ctrl-O" keyboard shortcut to open the file faster.

Save your file in XLSX or XLS format, depending on whether you only work with other users of Excel 2010 or you send files to people who use older versions of the software. Advertisement Article ...