none
Import data from excel to sharepoint list RRS feed

  • Question

  • Hi

    I want to import excel to sharepoint how can do it? in the sharepoint we can export data in to the excel but i want to have inverce it.

    Saturday, July 4, 2015 11:00 AM

Answers

  • There is no way using just out of the box components to easily add data from excel to a SharePoint list.  It normally requires custom programming.  Or doing a simple cut and paste to the data sheet view of the list to add additional rows.

    Paul Stork SharePoint Server MVP
    Principal Architect: Blue Chip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Sunday, July 5, 2015 3:56 PM
  • Periodically update SharePoint 2010 list with data from Excel: https://social.msdn.microsoft.com/Forums/en-US/0ce9f893-6269-431f-8db8-01de1a11b0df/periodically-update-sharepoint-2010-list-with-data-from-excel

    Connect to (Import) external data: https://support.office.com/en-au/article/Connect-to-Import-external-data-9967afd8-85ee-4df3-aa06-753bcc1a2724

    How to Import an Excel Spreadsheet into a SharePoint 2010 List: http://www.dynamics101.com/2013/07/import-excel-spreadsheet-into-sharepoint-2010-list/

    Hope it helps you!


    Monday, July 6, 2015 7:47 AM
  • As Paul mentioned there are no real OOB ways to do this. The links that Patrick linked I believe are also all manual so you would have to open the excel sheet every time you want to sync.

    This is were PowerShell is your friend. Create a script that looks at a "drop of folder" every X minutes via a scheduled task and get it to upload all the data.

    If you look at this article it will point you in the right direction. Also keep in mind that you would have to do this on the server so you'll need the permissions to do this.


    If this is helpful please mark it so. Also if this solved your problem mark as answer.

    Monday, July 6, 2015 7:55 AM

All replies

  • If you create a custom list you can import an excel spreadsheet during creation to create the list.  Here's a BLOG post that explains how to do it:

    http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=91


    Paul Stork SharePoint Server MVP
    Principal Architect: Blue Chip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    • Marked as answer by Yuzarsiv Sunday, July 5, 2015 6:15 AM
    • Unmarked as answer by Yuzarsiv Sunday, July 5, 2015 10:22 AM
    • Proposed as answer by ryguy72 Thursday, March 3, 2016 4:34 AM
    Saturday, July 4, 2015 12:26 PM
  • Hi

    very thanks

    but there is just one problem.

    I wantto periodicallyadd data from excel to sharepoint! In the case above,Once I am able to publish data!

    what am I do?

    Sunday, July 5, 2015 10:31 AM
  • There is no way using just out of the box components to easily add data from excel to a SharePoint list.  It normally requires custom programming.  Or doing a simple cut and paste to the data sheet view of the list to add additional rows.

    Paul Stork SharePoint Server MVP
    Principal Architect: Blue Chip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Sunday, July 5, 2015 3:56 PM
  • Periodically update SharePoint 2010 list with data from Excel: https://social.msdn.microsoft.com/Forums/en-US/0ce9f893-6269-431f-8db8-01de1a11b0df/periodically-update-sharepoint-2010-list-with-data-from-excel

    Connect to (Import) external data: https://support.office.com/en-au/article/Connect-to-Import-external-data-9967afd8-85ee-4df3-aa06-753bcc1a2724

    How to Import an Excel Spreadsheet into a SharePoint 2010 List: http://www.dynamics101.com/2013/07/import-excel-spreadsheet-into-sharepoint-2010-list/

    Hope it helps you!


    Monday, July 6, 2015 7:47 AM
  • As Paul mentioned there are no real OOB ways to do this. The links that Patrick linked I believe are also all manual so you would have to open the excel sheet every time you want to sync.

    This is were PowerShell is your friend. Create a script that looks at a "drop of folder" every X minutes via a scheduled task and get it to upload all the data.

    If you look at this article it will point you in the right direction. Also keep in mind that you would have to do this on the server so you'll need the permissions to do this.


    If this is helpful please mark it so. Also if this solved your problem mark as answer.

    Monday, July 6, 2015 7:55 AM