none
How to import the data from excel to sharepoint list? RRS feed

  • Question

  • Hi I have been trying importing the data from excel to sharepoint list...is there any easy way to import data from excel workbook to sharepoint list. Plz give me a solution.

    • Moved by Mike Walsh FIN Thursday, November 12, 2009 11:34 AM Not an Excel Services q (From:SharePoint - Excel Services)
    Thursday, November 12, 2009 10:50 AM

Answers

  • Hi,

    please tell us which version of SharePoint you are using.

    You can import data from excel to SharePoint either using the datasheet(WSS and MOSS) or using Excel Services(MOSS).

    Easiest is to:

  • Site Actions > Create 'Import Spreadsheet' at the 'Custom Lists' section
  • Next you can fill out the name and description and browse to the excel sheet
  • Click on the import button
  • In the dialog window you must choose the range to import
  • Click on import again and the excel with data is imported
  • Cheers,


    Daniel Bugday

    Web: SharePoint Forum Blog: Daniel Bugday's SharePoint Blog

  • Marked as answer by Lily Wu Friday, November 20, 2009 12:44 AM
Thursday, November 12, 2009 2:10 PM

All replies

  • Hi Krs,

    If you want to do it programmatically--- refer this link-
    http://avinashkt.blogspot.com/2009/10/populate-sharepoints-splist-with.html
    Regards, Avinash | avinashkt.blogspot.com
    Thursday, November 12, 2009 1:51 PM
  • Hi,

    please tell us which version of SharePoint you are using.

    You can import data from excel to SharePoint either using the datasheet(WSS and MOSS) or using Excel Services(MOSS).

    Easiest is to:

  • Site Actions > Create 'Import Spreadsheet' at the 'Custom Lists' section
  • Next you can fill out the name and description and browse to the excel sheet
  • Click on the import button
  • In the dialog window you must choose the range to import
  • Click on import again and the excel with data is imported
  • Cheers,


    Daniel Bugday

    Web: SharePoint Forum Blog: Daniel Bugday's SharePoint Blog

  • Marked as answer by Lily Wu Friday, November 20, 2009 12:44 AM
Thursday, November 12, 2009 2:10 PM