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.

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

You have a table on paper but need the data listed in Excel? There's a simple trick for importing.