Create a List from Excel for SharePoint 2013

Create a List from Excel


1. Navigate to the site and choose Site Settings > Add an App.

2. Select Import Spreadsheet.

3. Name the List and add a Description.


4. In the Import from Spreadsheet section click on Browse > and select the Excel file, open then Import.
5. Microsoft Excel should open up and you can select the range of information to bring into SharePoint.
Excel may open up behind other programs. Watch the task bar for the flashing Excel icon.
6. In the Range Type select Range of Cells, highlight $A$1 in the Select Range box.
7. Click on Import and when SharePoint refreshes, the spreadsheet information should now be in SharePoint.