Step 1
Go to your site and click on the Tools icon. Select add an app.
Step 2
Type Import Spreadsheet into the search box. Click on the Import Spreadsheet link. Give your app a name.
Step 3
Browse your computer to locate your spreadsheet.
Step 4
Open the spreadsheet. Select Range of Cells in the popup window, then select the range of cells in your spreadsheet.
Once selected, this information will appear in the app.
Step 5
Now you need to add the app to your portal page. Go to your page and select Edit. Select Add a Web Part. Then select the Spreadsheet app you just created. Then click Add.
Step 6
Select Settings for the App to adjust what columns appear in the app—you may have too many columns for the Zone in which you placed the app. You may want to edit the spreadsheet before importing—you can delete unwanted columns and save a copy to import. You can also delete the columns you do not want.
Step 7
You can then decide what columns you want to appear. You can click on a column to open up the editing menu. Then you can delete the column, change its format, or rename it.
Step 8
You may have rows that are blank. These will have “No Entry” as the default text in the first column. You will want to delete them, and the easiest way to do this is to edit the content of the spreadsheet on your portal page or in the app itself. You sort the first column (either ascending or descending, it doesn’t really matter), and then you find all the “No Entry” rows. You can then easily delete multiple rows at once. 