File Setup To build a CSV file to open in Microsoft Excel, you'll need to decide how many columns you'll use in Microsoft Excel for the categories of information you're preparing in Notepad.

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.