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.