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.

Let’s assume you have a product list in a Notepad or .txt file and need to import it into a column in an Excel spreadsheet. There are two ways to do that.