Export Excel Data to SharePoint 2013 list from Excel itself

Export Excel Data to SharePoint 2013 list from Excel itself
InfoPath alternatives for form designing SharePoint

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

Also read:
– Export list items to Excel using JavaScript object model in SharePoint 2013

– Import Spreadsheet adding column name as column1 column 2 in SharePoint 2013

– Export selected record to excel in SharePoint 2013 using JavaScript client object model

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:

Export Excel Data to SharePoint 2013 list from Excel itself
Export Excel Data to SharePoint 2013 list from Excel itself

Then from the Design tab in Excel, Click Export and select “Export Table to SharePoint List”.

Export Excel Data to SharePoint 2013 list from Excel itself
Export Excel Data to SharePoint 2013 list from Excel itself

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:

Export Excel Data to SharePoint 2013 list from Excel itself
Export Excel Data to SharePoint 2013 list from Excel itself

Next it will show the Column Names, Data Type. Verify and click on Finish as shown in the fig below:

Export Excel Data to SharePoint 2016 list from Excel itself
Export Excel Data to SharePoint 2016 list from Excel itself

Once finished it will display the successfully message like below:

Export Excel Data to SharePoint 2013 list from Excel itself
Export Excel Data to SharePoint 2013 list from Excel itself

Now when you open the site you will be able to see the List with data as shown in the fig below:

Export Excel Data to SharePoint 2013 list from Excel itself
Export Excel Data to SharePoint 2013 list from Excel itself

Hope this will be helpful.

Similar SharePoint 2013 Tutorials

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →

Leave a Reply