Click here to Skip to main content
15,885,032 members
Articles / Productivity Apps and Services / Sharepoint
Tip/Trick

Moving List Items from one list to another list in SharePoint 2010

Rate me:
Please Sign up or sign in to vote.
4.50/5 (4 votes)
25 Jan 2012CPOL2 min read 99.3K   4
Moving List Items from one list to another list in SharePoint 2010
We can move list items from one list to another list using standard SharePoint user interface. Here is the simple way to move items from one list to another in SharePoint 2010.

  1. Browse to the source list, click List tab on the ribbon bar and click List Settings icon.

  2. Click “Save list as template” link that exists under Permission and Management section which will bring up another page where you need to provide template File Name, Template name and Template Description. Make sure you didn’t check “Include Content” checkbox. Then, click the OK button.

  3. Go to Site Actions --> More options --> Click List under Filter By section. You can see the template which has been created in the previous step as part of other templates on the right pane. Choose the template and provide list name.

  4. If there are any workflows associated with the existing list that may still persist on the newly created destination list. Usually when lists are saved as template, all workflows associated to the original list will be saved as part of template except currently running workflows. Make sure all workflows associated with the original list have been removed if it’s not required. To remove workflows associated to list, go to List Settings Click on Workflow Settings Click “Remove a workflow” link, choose Remove option and click OK button.

  5. Open New (destination) List, Go to Site Actions --> Manage Content and Structure, choose the Original List on the left pane.

  6. You can increase the currently showing items up to 1000, sort list items by clicking column header and choose all items by clicking Select All option (displyaed top-left corner on the header) or individual items can be selected by clicking the checkbox displayed on each individual item.

  7. Click “Actions” --> Move and choose the target list (newly created destination list from template) on the popup.

  8. Finally click the OK button and wait until the list items are moved to destination list. If required, follow step 5, 6 & 7 until you moved the required list items to destination list.


Saving a list as template (without content) will make sure the newly list has been created with original list schema and it also saves time for creating a new list manually. This approach requires admin privileges on the site which contains both source and destination lists.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect
United States United States
Currently working as a SharePoint Developer/Architect with US based leading Law Firm. I am responsible for leading large and complex SharePoint engagements for my organization. I have decent knowledge in
SharePoint 2013, SharePoint 2010 and MOSS 2007. I worked more than 9 years in many .NET technologies which helping me to develop SharePoint custom solutions and branding. Involved in few Capacity Management and sizing engagements and built very complex SharePoint farms successfully.

Comments and Discussions

 
QuestionVersion History not maintained Pin
Rashmi Kotian25-Jul-14 3:08
Rashmi Kotian25-Jul-14 3:08 
QuestionThis works within one site collection Pin
ginni sharma9-Oct-13 20:40
ginni sharma9-Oct-13 20:40 
Questionmake link for list item Pin
Jey-india2-Nov-12 0:53
Jey-india2-Nov-12 0:53 
GeneralReason for my vote of 5 Nicely Explined !!! Pin
karthik-ind25-Jan-12 6:24
karthik-ind25-Jan-12 6:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.