How to Export Excel File Data to a SharePoint List

The other day I was working in an Excel file in which I created a few rows of data. I realized that I wanted to put the data into a SharePoint list without having to deal with copying and pasting into datasheet mode. Luckily, there is a feature built into Excel 2010 and Excel 2013 that makes exporting information easy. It should be noted that this is a one time push of information. If you are looking for something that is connected with Excel and a SharePoint list that allows data changes, I’ll be posting about how to make this happen in the next few days.

  • Open up Excel (I’m using Excel 2013 but this should work Excel 2010 as well)
  • Create a header row of data
  • Create a few rows of data


  • Highlight the rows of data including the header then click the Insert tab


  • A pop up window will display like the image below, click OK


  • The data will now be in a Pivot Table


  • Under the Design tab in Excel, Click Export and select Export Table to SharePoint List


  • Next, run through the wizard that displays


  • Provide the URL to the SharePoint site and provide a name for the list then click Next
  • On the next step of the wizard, the columns and data types will be listed, verify and then click Finish


  • A success window will display


  • A new list is created that connects with this Excel Sheet (Check SharePoint)


  • Click into the list to view the same records in the Excel sheet


Tagged with: , ,
Posted in Excel, SharePoint
One comment on “How to Export Excel File Data to a SharePoint List
  1. I’ve been surfing on-line greater than three hours as of late, yet I never found any fascinating article like yours.
    It is pretty worth sufficient for me. In my opinion, if all site owners and bloggers made good
    content as you probably did, the web shall be a lot more useful than ever before.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: