Question: how to open multiple csv files in one excel spreadsheet?
Answer: You click File > Open and select Text Files (*. prn, *. ...  To select adjacent files, click the 1st file, hold down the Shift key, and then click the last file. ...  With multiple CSV files selected, click the Open button.