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.