How to export excel table to SharePoint List

by
Leave request management and approval

In this SharePoint Tutorial, we will discuss how to export excel table data to the SharePoint Online list? The same way we can export excel table data to SharePoint 2016/2013/2010 list.

Complete SharePoint Training Course Just for $199 (Just for Today)

You may also like:

Table of Contents show

How to format Excel File into Tabular Format?

We have to first format the Excel File into Table before exporting to SharePoint online list. Open your Excel File which you want to format as Table. The excel has few columns as:

  • Employee
  • ID
  • Salary
  • Department
  • Joining Date

And the list has some data which we need to format as a table.

So I have selected the data part which I want to make as a table. Then I went to the File option which is present at the top of the Excel File. Then clicked on to the Format as Table option to select the table style like as below screenshot.

How to format the Excel File into Table
How to format the Excel File into Table

Then it will ask the range for which you want to make to the table like below, Just click on OK.

import excel spreadsheet into sharepoint online list
import excel spreadsheet into a sharepoint online list

Export Excel Table Data to SharePoint Online List

After formatting the Excel File to a table, You can see the table design of that Excel File like below screenshot.

Now go to the “Design” option which is present at the Top of the Excel File. Then click on to “Export” for exporting the table to SharePoint List. Select the “Export Table to SharePoint List” option from the “Export” drop down.

import excel spreadsheet into sharepoint list
import excel spreadsheet into SharePoint list

Here in this screenshot, It is representing the Export Table to SharePoint List. So for publishing that Excel Table provide the below details:

  • Address: SharePoint site URL where you want to export this excel data.
  • Name: Name of the table, it will create a list with the same name
  • Description: Description of the table.
export excel data to sharepoint list office 365
export excel data to sharepoint list office 365

It will load the SharePoint Online Site, It will ask you for signing in to your SharePoint Site. So give your User account name which will help for opening the SharePoint site.

Then click on to “Next”. After clicking “Next”, It will ask you for giving the Password of that SharePoint Site. Just give that “Password” and click on to “Sign in” for opening the SharePoint Site.

import excel into existing sharepoint 2013 list
import excel into existing SharePoint 2013 list

Now in this screenshot, It is displaying that all the Column which you created in that Excel File, That all the column, will be showing here with their specific “Data Type”.

For Example, I have created a column in the Excel File as “Employee”. So it is displaying that Employee Column is a “text”(single line) data type. Then click on to “Finish” for finishing the process of Excel table in SharePoint Online.

export excel data to sharepoint online list office 365
export excel data to SharePoint online list office 365

Once you click on Finish, you can see it will display the successful message like “The table was successfully published and may be viewed on: https://SiteURL”.

export excel data to sharepoint online
export excel data to SharePoint online

Now when you will open SharePoint site and go to Site Contents page, you can see it already created a list.

export sharepoint list to excel automatically
export SharePoint list to Excel automatically

If you will open the list, you can see the list data as well. Here below you can see the column name as ID1, because already ID is an out of box column exists. so it created a column as ID1.

push data from excel to sharepoint list
push data from excel to SharePoint list

You may like following SharePoint tutorials:

In this SharePoint tutorial, we learned how to export the Excel table data into the SharePoint Online list. The same way we can export excel list data to SharePoint 2016, SharePoint 2013, etc.

>