Column 1 G, Column 2 L Column 1 G Column 2 L Table — CSV Import — Excel-Tips.net In Excel, from the File menu, select Import. From the Import drop-down, select CSV. Click OK. Note: This is different from the method described in Microsoft Support Article 703168-2. It is not in-line with the way the spreadsheet import works. You'll see the following screen: Click on Import Data to Open in Microsoft Excel Microsoft Support — Download CSV Import Wizard — MSN Blogs On this screen, Excel assumes you are a data analyst. To import data, choose the “Import Data” option. If this is your first time you have used an Excel user interface (UI), you may encounter questions about what to enter on this screen. For instance when you select data as you do in Excel 2010, it will be listed as a sheet rather than as a list. If you need to import the data as rows or columns, you must type a row or column name. If your spreadsheet includes more than a single column, you may need to type more than one option on the screen. Here are some frequently asked questions about the Data Import screens. For information about what to enter for each of the following questions, see Create Excel 2023 Data Import Wizard Screen and Select an Import Profile. What do I enter when asked to select an import profile? Select one of the following profiles: Excel 2023 — You can select the Microsoft Excel 2023 profile to import on this screen. Microsoft Excel 2023 — This is the default profile that is used to import data from Microsoft Excel. Microsoft Excel Data Import — You can select one of the following customizations for this screen. Note: You will not be able to import the entire data set; only the data listed in the import wizard's “Import Data” dialog box. How do I know which data is included in the Import wizard's “Import Data” dialog box? To determine the data that is included in the Import wizard's “Import Data” dialog box, follow these steps. Click On The Import Data Wizard. Type the name of the data set, such as: “Sales Data” or “My Company Records” or “Product Name” or “Sales Results — Summary”. Click OK. If you have not provided a custom wizard, Microsoft Excel will not be able to open the data.