Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 24 Jul 2013 9:48 PM
  • Last revision by (eMicrosoft Partne)
  • When: 16 Aug 2013 1:35 AM
  • Revisions: 8
  • Comments: 5
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2013: How to Export Excel Sheet to SharePoint List

SharePoint 2013: How to Export Excel Sheet to SharePoint List

SharePoint 2013: How to Export Excel Sheet to SharePoint List

Table of Contents

Introduction

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.


Problem

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?


Solutions

1. From Excel Sheet

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:

  1. Open the Excel 2010 application.
  2. Insert/create the table. 

    

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.

      

    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.

      

    7. Now click finish and wait until the operation gets finished. You will see that list gets created in SharePoint site with the records.
    
        

2. Using Import SpreadSheet App

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.

              

2.  Add 'Import SpreadSheet' app and provide information as shown in below screen. You need to select the excel file.

        

3. Click on the import, wait for few seconds and your spreadsheet gets imported in list.

        


Either is the time saving approach to create SharePoint list from the Excel sheet.
, , , , , , , , [Edit tags]
Leave a Comment
  • Please add 5 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 16 Aug 2013 1:35 AM

    Gokan Ozcifci edited Revision 6. Comment: toc

  • 16 Aug 2013 12:51 AM

    Rahul A Shinde edited Revision 5. Comment: Updated with new approach

  • 25 Jul 2013 8:29 PM

    Naomi  N edited Revision 1. Comment: Minor edit

  • 25 Jul 2013 8:29 PM

    Naomi  N edited Original. Comment: Some grammar edits, may need more

Page 1 of 1 (4 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 24 Jul 2013 11:45 PM

    This is nice man…….Very helpful……..

    I have done it in SharePoint 2010..It is workingFine ….Good one.

  • Posted by
    on 25 Jul 2013 8:29 PM

    Naomi  N edited Original. Comment: Some grammar edits, may need more

  • Posted by
    on 25 Jul 2013 8:29 PM

    Naomi  N edited Revision 1. Comment: Minor edit

  • Posted by
    on 16 Aug 2013 12:51 AM

    Rahul A Shinde edited Revision 5. Comment: Updated with new approach

  • Posted by
    on 16 Aug 2013 1:35 AM

    Gokan Ozcifci edited Revision 6. Comment: toc

Page 1 of 1 (5 items)