locked
Webpart for Exporting Excel Sheet Data into SharePoint 2007 Custom List RRS feed

  • Question

  • Hi,

    am trying to create a webpart to export the excel data into the custom list.  Please suggest if we have any inbuild functionality for the same or ways to implement it.

    Thanks in advance.

    UshaP

    Thursday, July 4, 2013 5:48 PM

Answers

  • Hi Usha,

    If it is one time import, You can use 'Datasheet View'. Open your custom list in datasheet view then copy and paste your excel rows directly into the browser. If there is no column/data type mismatch, rows will be imported successfully.

    http://www.sumitrawat.net/2009/09/tips-and-tricks-importing-excel-sheet.html

    • Marked as answer by Emir Liu Thursday, July 11, 2013 8:34 AM
    Thursday, July 4, 2013 8:54 PM
  • Hello,

    In addition to Kalai reply, You can try with belwo codeplex tool:

    http://exportdatatosplist.codeplex.com/

    Let us know in case any doubt


    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Please feel free to unmark answer if does not resolves your problem.

    • Marked as answer by Emir Liu Thursday, July 11, 2013 8:34 AM
    Friday, July 5, 2013 6:57 AM
    Moderator

All replies

  • Hi Usha,

    If it is one time import, You can use 'Datasheet View'. Open your custom list in datasheet view then copy and paste your excel rows directly into the browser. If there is no column/data type mismatch, rows will be imported successfully.

    http://www.sumitrawat.net/2009/09/tips-and-tricks-importing-excel-sheet.html

    • Marked as answer by Emir Liu Thursday, July 11, 2013 8:34 AM
    Thursday, July 4, 2013 8:54 PM
  • Hello,

    In addition to Kalai reply, You can try with belwo codeplex tool:

    http://exportdatatosplist.codeplex.com/

    Let us know in case any doubt


    Hemendra: "Yesterday is just a memory,Tomorrow we may never see"

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Please feel free to unmark answer if does not resolves your problem.

    • Marked as answer by Emir Liu Thursday, July 11, 2013 8:34 AM
    Friday, July 5, 2013 6:57 AM
    Moderator