In this post, we will discuss how we can excel file data to a SharePoint 2013 list from the excel itself. Let’s say I have one excel which has few records and I want to upload those data to a SharePoint 2013 list. Remember this will not sync, it will be a one time upload to SharePoint list.
Get SharePoint Online (Office 365 Enterprise E3) Subscription for your Business NOW
You can do the same things by using the Import Spreadsheet app. Check out more: Upload Excel Data to SharePoint using the Import Spreadsheet option in SharePoint 2013
Here before doing anything, Make sure your excel file is ready with a proper header (the header columns will be created as a column name in SharePoint list). And also make sure few records are there.
Now Open the excel file. Select the records including the header row. Then from the INSERT tab in the excel click on Table. It will show a Create Table pop up window. There select the My table has headers check box as shown in the fig below:
Then from the Design tab in Excel, Click Export and select “Export Table to SharePoint List”.
Then it will open the Export Table to SharePoint List wizard. In the First step Enter the Site URL. Name and Description. This will be the Name of the list and description for the list. See fig below:
Next, it will show the Column Names, Data Type. Verify and click on Finish as shown in the fig below:
Once finished it will display the successful message like below:
Now when you open the site you will be able to see the List with data as shown in the fig below:
Hope this will be helpful.