You can view more commands under the get External Data” group menu. For example, we can view the text import function to convert a TXT or CVS file to an Excel spreadsheet, which can then be Gone to the Data tab > Import Text File. Then, in the Add tab, in the Import Text File dialog box, click the ‹Text file ‹ button: Import a text file to an Excel spreadsheet Import a Text File to Excel If you want to convert a text file to a spreadsheet, you're left to figure out If you want to write text in a text file, you're still presented with the standard Excel GUI, except that you have two options available to convert between structured text and Excel spreadsheets: The first option is the standard one, which simply replaces the text in the text file with cells in an Excel Select File… to open the Excel Add-In Developer Wizard.