Question: how to import several text files into excel?
Answer: Press F5 to display a dialog, and select a folder which contains text files you want to import. ...  Click OK. ...  Select a cell you want to import the text file, and click Kutools Plus > Import/ Export > Insert File at Cursor.