Contents
To import your spreadsheet into a custom list:
- Choose Site Actions→View All Site Content.
- Select the Create command and then select the Import Spreadsheet option from the List category and click the Create button.
- In the Name text box, enter a name for your list.
Import Excel Table or Range to SharePoint List
- Click on the settings gear and select ‘Add an app’.
- Search for Excel and select the Import Spreadsheet app.
- Give the app a name and browse to the Excel file you want to import.
- Enter the URL of the SharePoint site to where you want to import the Excel table.
How to add an Excel spreadsheet to a SharePoint page?
Click on the edit link in top right corner of the SharePoint site page. Under Categories, click on the Media and Content. Under Parts, click on the Page Viewer. Click on Add to add the Page viewer web part. Click on the open the tool pane hypertext. Then type/paste the link of your Excel Spreadsheet.
When you will upload the file, it will be saved in the SharePoint documents document library. From a link: You can also provide the excel file link directly. Here, I have save the file in the document library and choose from there.
Follow the below steps to use embed code web part to display excel document in SharePoint. Open SharePoint Modern site page, where you want to display the excel document. Click on the edit link in the top right corner to edit the page. After that, you will see a plus sign on the header part or after each section. Click on the plus sign
How do I upload an Excel spreadsheet to a shared document library?
Click the Documents and Lists button on the toolbar and then, on the Documents and Lists page, click the name of the document library into which you want to upload the spreadsheets. To upload Excel spreadsheets into the generic Shared Documents library, click its hyperlink.