how to copy windows sharepoint services 3.0 list to another site collection list

In running Windows SharePoint Services 3.0 (WSS), you may want to copy a list (Contacts, Calendar, Tasks, Document Library etc.) from one site collection or server to another. Copying lists is done via List Templates, which is an easy, if unintuitive process. To copy WSS lists from one site collection to another, use the following procedure:

  1. While viewing the list, save it as a template by clicking Settings–>List Settings and then Save List as a Template. Name the list and be sure to check the Include Content check box. You should see an Operation Completed Successfully page.
  2. Click the list template gallery link on the Success page, or go to the top level site and click Site Actions–>Site Settings and then List templates.
  3. Click the name of the list template you saved in step 2 to download the .STP template file to your PC.
  4. In the new site collection, click Site Actions–>Site Settings and List templates and click Upload to upload the template file you downloaded in step 3 to the new site.
  5. Go to the location on new site collection where you want to copy the list. Click Site Actions–>Create and click the name of your list template, generally found under the Communications or Libraries heading.
  6. SharePoint should take you directly to the newly copied list.
  7. Once the list has been successfully copied, you can delete the template from both the old and new sites by going to the top level site’s Site Actions–>Site Settings and List templates. Click the Edit icon for the template you want to delete and then the Delete Item button on the next page. Deleting the template will not affect your existing lists.

Notes:

  • You may need Designer or Owner permission to save a list as a template.
  • Edit: According to Brooke in the comments, this method may also be used with Microsoft Office SharePoint Server and it works when moving lists within a site or between subsites in the same site collection.

1 Response to “how to copy windows sharepoint services 3.0 list to another site collection list”


  1. 1 Tissla

    This worked for me when all attempts with Access and Excel failed. The only problem is that the content in the columns “Created by” and “Last modified by” will be the person uploading the files.
    Is there a way to create an exact copy?

Leave a Reply