In this post we will discuss how we can excel file data to a SharePoint 2013 list from the excel itself. Lets 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.
You can do the same things by using the Import Spreadsheet app. Check out more: Upload Excel Data to SharePoint using Import Spreadsheet option in SharePoint 2013
– Import Spreadsheet adding column name as column1 column 2 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 names 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 successfully 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.