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.