Question: how do i import multiple csv files into one sheet in excel?
Answer: Enable a blank worksheet and press Alt + F11 keys to open Microsoft Visual Basic for Applications window.
Click box> Module and paste under VBA in the new Module window. ... 
Press F5 key or click run to run the VBA, and a dialog box appears to select a folder from which you want to import all the csv files.