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
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.