We have a list in sharepoint 2007 that we need to move to another site which is based on sharepoint 2010.

what's the best and fastest method?

thanks in advance

  • I tried exporting the list and importing it in 2010 but didn't work because 2007 export an "STP" file while 2010 is "WSP" and they're not compatible. Oct 31, 2010 at 9:04

4 Answers 4


If you read this article by Thao Nguyen at Bamboo Solutions you will find 4 different methods for migrating a list from SharePoint 2007 to SharePoint 2010. My preferred method is number 1:

Method 1 - Migrate a single list from SharePoint 2007 to 2010 using a list template

  1. Save the list as a list template (".stp" file).
  2. Download the list template
  3. Change the extension to ".cab" and extract the contents
  4. Edit the manifest.xml file changing ProductVersion element from 3 to 4
  5. Repackage the STP file.
  6. Upload the STP file to your SharePoint 2010 site
  7. Create a new list using the template.

This works well for me becacuse I can write a bit of powershell to automate most of the process.

  • Where exactly is the list supposed to be updated to?
    – Rick
    Dec 7, 2012 at 13:12
  • if like rick your confused about repackaging than you need to look at makecan.exe , you would do the changes as noted but when repackaging get the new manifest plus the other files... put in a folder and follow blogs.msdn.com/b/sekharevani/archive/2012/08/31/… now you can rename the cab file back to stp and follow this techgrowingpains.com/2010/01/…
    – Ali Jafer
    Mar 20, 2014 at 10:56
  • Just to let everyone know, I followed these instructions way back in the day. However, we are now trying to upgrade document libraries from SP2010 --> SP2013 that were created by such a template, and the upgrade process isn't working.
    – Eli
    Nov 13, 2014 at 19:14

found it.

the best way is to export the list to a spreadsheet in 2007 and then import that xslx file in 2010. I found this article very useful:


by the way, I faced a problem when exporting to excel if the site is using forms based authentication with the error message: "Excel Cannot access sharepoint list"

one more thing, Make sure you have the fields visible in the view before you export to spreadsheet since non-visible fields will NOT be included.


I just had good success using Microsoft Access to move a list from a SharePoint 2007 site to a SharePoint 2010 site.


  1. I opened Access 2010, and created a blank database.

  2. Under the External Data tab on the ribbon, under the More drop down, I selected Import or link to a SharePoint list.

  3. In the Get External Data pop-up, I entered the URL of the SP 2007 site that held the list and selected the "Import the source data into a new table in the current database" and pressed Next.

  4. On the next screen I selected my list, and selected "All Columns" for Items to import.

  5. Now the list is in a table in the database. The table has the same title as the list.

  6. Right-click on the new table, select Export, select SharePoint list, and enter the destination site (SP 2010)


For upgrading the list templates (being migrated from MOSS 2007 to SharePoint 2010) either you have to manually upgrade them by hand or using some PowerShell to upgrade them. Even if you upgrade them using PowerShell, there is no way to automatically upload (the upgraded template) them back to the site collections where they belong to:

I have done the PowerShell which performs the following 4 tasks:

  1. Get a URL to a certain Web application in SharePoint environment (Specify the URL in Config.xml)
  2. The code tries to find all List Templates within all site collections and download them all on the disk (in their separate folders i.e. for each site collection a separate folder is created)
  3. Upgrade the List templates using the PowerShell
  4. Upload them back to their original site collections
  5. I assume the PowerShell code will be run on 2010 upgraded SharePoint sites.

Full code can be downloaded from CodePlex: https://upgradelisttemplates.codeplex.com/

Technet Gallery: http://gallery.technet.microsoft.com/Upgrade-List-Templates-0b86f443

Blog: http://falakmahmood.blogspot.se/2013/02/upgrade-list-templates-from-sharepoint.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.