none
Import Excel spread sheet to Sharepoint list

    Question

  • I have a Sharepoint list that should be updated daily with information will be coming in an Excel spread sheet. First I tried using the import option, but a new list was created. I didn't want this. I want to update the list, just adding new items.

    How Could I do that?

    Thank you.
    Tuesday, September 16, 2008 9:07 PM

Answers

  •  

    Hello,

     

               There are a few methods available for your case:

        

    1.       Click actions->”Export to spreadsheet” of the list to copy the original content of the list to a new Excel file. Then copy the content of newly gotten Excel file to the former one. Import this integrated file to a new sharepoint list. Delete the original list and rename the new list as the former one.

    2.       Import the content from the newly gotten Excel file to a new sharepoint list. Create a workflow in sharepoint designer to copy all items in the new list to the original list then delete the new list.

    3.       Try to transfer the Excel data into a table in database, and create a dataview in sharepoint designer to connect to the database table.

    4.       Import the content from the newly gotten Excel file to a new sharepoint list. Using object model(programming), SPSiteitem class to copy all items in the new list into the original list and delete the new list.

     

               Hope it can help you.

     

               Jerry


    Xing-Bing Yu
    Thursday, September 18, 2008 7:31 AM

All replies

  • Are you on WSS3.0, MOSS2007 or a different version??  If you are on MOSS2007 have you considered using Excel Services?

    Rob Fleming
    Wednesday, September 17, 2008 2:29 AM
  • Note that Excel Services is not included in the standard edition of MOSS 2007 - only in the Enterprise edition.
    Wednesday, September 17, 2008 4:57 AM
  • I'm not using MOSS2007 Enterprise. I need to do that in a Server with WSS 3.0.

    Thank you.
    Wednesday, September 17, 2008 7:38 PM
  •  You can install the Office Web Parts 2003

    Download the Office 2003 Web Parts and Components add-in. To do this, visit the following Microsoft Web site:
    they was create to wss 2.0 then use this site to install on wss3.0
    http://support.microsoft.com/kb/929320/en-us


    Hope this help.

    André Lage Microsoft SharePoint and CRM Consultant http://aaclage.blogspot.com
    Thursday, September 18, 2008 3:04 AM
  • One suggestion is the freee add-in from Softfluent that enables you to open a SharePoint list in excel, edit it and synchronize it back to SharePoint. You'll also get version handling etc. I'm using it on WSS 3.0 with Office 2007.

    Information about the add-in:
    http://www.softfluent.com/en-US/news/article_excellist.aspx

    Direct link to the add-in:
    http://www.softfluent.com/wsslists.htm

    jennyfi
    Thursday, September 18, 2008 7:14 AM
  •  

    Hello,

     

               There are a few methods available for your case:

        

    1.       Click actions->”Export to spreadsheet” of the list to copy the original content of the list to a new Excel file. Then copy the content of newly gotten Excel file to the former one. Import this integrated file to a new sharepoint list. Delete the original list and rename the new list as the former one.

    2.       Import the content from the newly gotten Excel file to a new sharepoint list. Create a workflow in sharepoint designer to copy all items in the new list to the original list then delete the new list.

    3.       Try to transfer the Excel data into a table in database, and create a dataview in sharepoint designer to connect to the database table.

    4.       Import the content from the newly gotten Excel file to a new sharepoint list. Using object model(programming), SPSiteitem class to copy all items in the new list into the original list and delete the new list.

     

               Hope it can help you.

     

               Jerry


    Xing-Bing Yu
    Thursday, September 18, 2008 7:31 AM
  • You can try this simple and efficient solution here. Which is available in codeplex.


    ASP.NET and SharePoint developer Company: http://www.rampgroup.com/ Blog: http://praveenbattula.blogspot.com
    Wednesday, October 07, 2009 11:58 AM