Microsoft Excel supports two ways to import data from a text file. You can open the file in Excel, or you can import the data using an Excel wizard.

An option in Excel allows users to import all the texts into the spreadsheet (convert text file into Excel ) so that users can do the job quickly. ... It will open the Power Query Editor window.

One way to turn a CSV file into a Microsoft Excel spreadsheet is to open the document in Excel, but with this method you won't see the text-import wizard that allows you to specify how Excel ...

So, scroll down the All Files list and select ODT (Open Document Text) from the drop-down list of files. 9. ... Double-click anywhere on the inserted spreadsheet to open and edit the Excel file. g.