Editing: SharePoint 2013: How to Export Excel Sheet to SharePoint List

Title
<html> <body> <h2><a name="Introduction"></a></h2> [toc] <h2><a name="Introduction"></a>Introduction</h2> In many organizations the management people in any department use Excel to maintain their records, data, history etc. And nowadays SharePoint based applications are often used to share and collaborate these files. Many organizations use SharePoint sites as their portal sites for the purpose of sharing information, data within department or organization. <h2><a name="Problem"></a> Problem</h2> So now let’s say your manager or client has an Excel sheet with valuable records and now he/she wants to put it on the SharePoint as a list, and asked you to do that. Now what will you do? You cannot use Excel services nor upload excel sheet as it is (even though you can J ) because manager wants SharePoint list only. As a SharePoint developer you will think: first create a SharePoint List and then write one tool which will read Excel sheet records one by one and add it to the SharePoint list. Right? But is it really needed if SharePoint and Office provides it itself? <h2><a name="Solution"></a> Solutions</h2> <h3><a name="From_Excel_Sheet"></a>1. From Excel Sheet</h3> Yes you can quickly create SharePoint List out of Excel sheet without writing any single line of code. Let's see how we can do. Note: I have performed these steps on SharePoint 2013 with Microsoft office 2010. Steps: <ol> <li style="color:#333333">Open the Excel 2010 application. </li><li style="color:#333333">Insert/create the table.  </li></ol>      <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/7343.ExcelToSharePoint1.png"> <img alt="" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x100/__key/communityserver-wikis-components-files/00-00-00-00-05/7343.ExcelToSharePoint1.png" width="449" height="100" style="border:0px solid; width:413px; height:135px"></a> I have created this table as an example here. You can have it ready made.     3. Now click on any cell of table and go to the ‘Table Tools’.     4. Click on the Export and then ‘Export table to SharePoint List’.     5. You will see a popup where you need to provide the URL of SharePoint site, list name and description.        <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/2677.ExcelToSharePoint2.png"> <img alt="" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x150/__key/communityserver-wikis-components-files/00-00-00-00-05/2677.ExcelToSharePoint2.png" width="400" height="149" style="border:0px solid; width:403px; height:190px"></a>     6. Then click on next, it will ask for credentials. On the next screen you will see columns with data types which are going to create in SharePoint list.        <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/4621.ExcelToSharePoint3.png"> <img alt="" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x150/__key/communityserver-wikis-components-files/00-00-00-00-05/4621.ExcelToSharePoint3.png" width="405" height="149" style="border:0px solid; width:403px; height:193px"></a>     7. Now click finish and wait until the operation gets finished. You will see that list gets created in SharePoint site with the records.              <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/1854.ExcelToSharePoint4.png"><img alt="" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x200/__key/communityserver-wikis-components-files/00-00-00-00-05/1854.ExcelToSharePoint4.png" style="border:0px solid"></a> <h3><a name="Using_Import_SpreadSheet_App"></a>2. Using Import SpreadSheet App</h3> SharePoint 2013 provides 'Import SpreadSheet App' to do the same thing. Follow below steps to import SpreadSheet. 1. Go to Site Contents -> add an app, and search for 'Import SpreadSheet' app.             <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/1033.ImportSpredsheet_5F00_0.png" style="font-family:'Segoe UI',sans-serif"><img alt="" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x200/__key/communityserver-wikis-components-files/00-00-00-00-05/1033.ImportSpredsheet_5F00_0.png" style="border:0px solid"></a><a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/5383.ImportSpredsheet_5F00_1.png"></a>  2.  Add 'Import SpreadSheet' app and provide information as shown in below screen. You need to select the excel file.         <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/2148.ImportSpredsheet_5F00_2.png" style="font-family:'Segoe UI',sans-serif"><img alt="" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x200/__key/communityserver-wikis-components-files/00-00-00-00-05/2148.ImportSpredsheet_5F00_2.png" style="border:0px solid"></a><a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/6445.ImportSpredsheet_5F00_2.png"></a> 3. Click on the import, wait for few seconds and your spreadsheet gets imported in list.         <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/5773.ImportSpredsheet_5F00_3.PNG" style="font-family:'Segoe UI',sans-serif"><img alt="" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x200/__key/communityserver-wikis-components-files/00-00-00-00-05/5773.ImportSpredsheet_5F00_3.PNG" style="border:0px solid"></a> Either is the time saving approach to create SharePoint list from the Excel sheet. </body> </html>
Comment
Tags
Please add 5 and 6 and type the answer here:

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?