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.