How to Import Excel spreadsheet to SharePoint Online Library

4. In the Find an app search box, write Import Spreadsheet. It will find the app you need.

5. Click on the Import Spreadsheet app.

6. At the New app page, provide details of the new list and choose the excel spreadsheet to import. Click Import button to import the spreadsheet.

7. SharePoint may ask you to enter account credentials at this stage. If you get errors, please make sure you have read the pre-requisites.

8. You would need to select the range to import the data. In this example, I have selected Range of Cells and in cells I have included all the cells with the data. This will make the first row as name of the fields.

9. You can go to the List Settings to change the settings of the list including column/field names.

10. use Quick Edit option on list menu to quickly edit data on the spreadsheet, just like excel spreadsheet.