Question: how to convert text file into excel sheet?
Answer: Click File > Open > Browse. Then in the Open dialog, select Text Files in the drop-down list next to the File name, and select the text file you use. ...  Click Finish, and a new sheet of a new workbook has been created with the texts.