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

Image

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

Image

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

Image

  • The data will now be in a Pivot Table

Image

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

Image

  • Next, run through the wizard that displays

Image

  • 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

Image

  • A success window will display

Image

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

Image

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

Image

Advertisements
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: