TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Editing: SharePoint 2013: How to Export Excel Sheet to SharePoint List
Wiki
>
TechNet Articles
>
SharePoint 2013: How to Export Excel Sheet to SharePoint List
Article
History
Title
<html> <body> <h2><a name="Introduction"></a></h2> <p>[toc]</p> <h2><a name="Introduction"></a>Introduction</h2> <span style="font-family:'Segoe UI',sans-serif">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.</span> <h2><a name="Problem"></a><br> Problem</h2> <span style="font-family:'Segoe UI',sans-serif">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 </span><span style="font-size:9pt; font-family:Wingdings; color:#333333">J</span><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333"> ) 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?</span> <br> <h2><a name="Solution"></a><br> Solutions</h2> <strong> <h3><a name="From_Excel_Sheet"></a>1. From Excel Sheet</h3> </strong><span style="font-family:'Segoe UI',sans-serif">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.</span> <p><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333">Steps:</span></p> <ol> <li style="color:#333333"><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333">Open the Excel 2010 application.</span> </li><li style="color:#333333"><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333">Insert/create the table. </span> </li></ol> <p style="color:#333333"><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333"> <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></span></p> <p style="color:#333333"><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333"></span><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333">I have created this table as an example here. You can have it ready made.</span></p> <span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333"> 3. Now click on any cell of table and go to the ‘Table Tools’.<br> 4. </span><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333">Click on the Export and then ‘Export table to SharePoint List’.<br> </span><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333"> 5. You will see a popup where you need to provide the URL of SharePoint site, list name and description.<br> <br> <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><br> <br> </span><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333"> 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.<br> <br> <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><br> <br> </span><span style="font-size:9pt; font-family:'Segoe UI',sans-serif; color:#333333"> 7. Now click finish and wait until the operation gets finished. You will see that list gets created in SharePoint site with the records.<br> </span><span style="font-family:'Segoe UI',sans-serif"> </span><br> <span style="font-family:'Segoe UI',sans-serif"> </span><span style="font-family:'Segoe UI',sans-serif; font-size:9pt; color:#333333"><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></span><br> <br> <h3><a name="Using_Import_SpreadSheet_App"></a>2. Using Import SpreadSheet App</h3> <span style="font-family:'Segoe UI',sans-serif">SharePoint 2013 provides 'Import SpreadSheet App' to do the same thing. Follow below steps to import SpreadSheet.</span><br> <br> <span style="font-family:'Segoe UI',sans-serif">1. Go to Site Contents -> add an app, and search for 'Import SpreadSheet' app.</span><br> <br> <span style="font-family:'Segoe UI',sans-serif"> </span><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><span style="font-family:'Segoe UI',sans-serif"><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> </span><br> <br> <span style="font-family:'Segoe UI',sans-serif">2. Add 'Import SpreadSheet' app and provide information as shown in below screen. You need to select the excel file.</span><br> <br> <span style="font-family:'Segoe UI',sans-serif"> </span><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><span style="font-family:'Segoe UI',sans-serif"><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></span><br> <br> <span style="font-family:'Segoe UI',sans-serif">3. Click on the import, wait for few seconds and your spreadsheet gets imported in list.</span><br> <br> <span style="font-family:'Segoe UI',sans-serif"> </span><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><br> <br> <br> <span style="font-family:'Segoe UI',sans-serif">Either is the time saving approach to create SharePoint list from the Excel sheet.</span> </body> </html>
Comment
Tags
Please add 5 and 6 and type the answer here: