Question: how to copy an excel sheet into sharepoint?
Answer: Open your Excel workbook and navigate to the sheet from which you wish to copy data. ... 
Select the cells you wish to copy into your SharePoint list and press Control-C to copy the cells. ... 
Log into your SPO tenant and navigate to the list into which you want to paste data. ... 
Above the list, click edit this list.