Home

Copying a SharePoint LIST from a Team to another Team

%3CLINGO-SUB%20id%3D%22lingo-sub-374044%22%20slang%3D%22en-US%22%3ECopying%20a%20SharePoint%20LIST%20from%20a%20Team%20to%20another%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-374044%22%20slang%3D%22en-US%22%3ESo%20after%20a%20couple%20of%20hours%20trying%20to%20move%20a%20fairly%20simple%20SharePoint%20list%20to%20another%20Team%20-%20I%20did%20some%20research%20and%20it's%20not%20as%20easy%20as%20I%20thought!%20I%20tried%20to%20export%20it%20to%20Excel%20-%20then%20import%20it%20-%20but%20ActiveX%20stopped%20me%20I%20tried%20to%20import%20the%20Structure%20of%20the%20list%20-%20the%20columns%20went%20in%2C%20but%20no%20Data%20I%20can%20see%20from%20research%20that%20the%20%22List%20Template%22%20function%20doesn't%20work%20for%20O365%20SharePoint%20Lists%3F%20I%20tried%20copying%20and%20pasting%20from%20the%20Excel%20into%20a%20List%20with%20the%20same%20columns%20-%20wouldn't%20work%20either.%20So%20-%20in%20simple%20terms%20what%20is%20the%20easiest%20way%20to%20Copy%20a%20list%20from%20one%20SharePoint%20(Team)%20to%20another%20SharePoint%20(Team)%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-374044%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-374063%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20a%20SharePoint%20LIST%20from%20a%20Team%20to%20another%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-374063%22%20slang%3D%22en-US%22%3EAFAIK%2C%20the%20SharePoint%20migration%20tool%20does%20not%20support%20SPO%20as%20migration%20source...it%20only%20supports%20SP%202013%20and%20File%20Share.%20Actually%20Joony's%20approach%20is%20a%20good%20one%20to%20move%20lists%20contents...other%20approaches%3A%3CBR%20%2F%3E1)%20Third%20party%20migration%20tool%3CBR%20%2F%3E2)%20Extract%20list%20definition%20by%20means%20of%20PnP%20%2F%20Site%20Scripts%20%26amp%3B%20Site%20Designs%20and%20deploy%20it%20to%20the%20new%20site.%20Then%2C%20create%20a%20simple%20PS%20scripts%20that%20reads%20list%20items%20in%20the%20source%20list%20and%20copy%20them%20to%20the%20destination%20list%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-374054%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20a%20SharePoint%20LIST%20from%20a%20Team%20to%20another%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-374054%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Chris%2C%20I%20continued%20to%20puzzle%20and%20solved%20it...%20I%20Downloaded%20the%20SharePoint%20List%20as%20Excel%20I%20then%20used%20the%20%22Table%20Design%22%20option%20in%20Excel%20to%20%22Export%22%20-%20then%20%22Export%20Table%20to%20SharePoint%20List%22%20Once%20I%20pointed%20it%20to%20the%20right%20SharePoint%20-%20Teams%20URL%20-%20et%20Voila%20it%20worked...%20Thanks%20for%20picking%20up%20and%20replying%20though...%20Cheers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-374052%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20a%20SharePoint%20LIST%20from%20a%20Team%20to%20another%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-374052%22%20slang%3D%22en-US%22%3ESorry.%20SharePoint%20Migration%20Tool%2C%20provides%20by%20Microsoft.%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepointmigration%2Fintroducing-the-sharepoint-migration-tool%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepointmigration%2Fintroducing-the-sharepoint-migration-tool%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-374051%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20a%20SharePoint%20LIST%20from%20a%20Team%20to%20another%20Team%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-374051%22%20slang%3D%22en-US%22%3EHave%20you%20tried%20the%20SharePoint%20Migration%20wizard%3F%20Pretty%20sure%20it%20can%20do%20lists%20and%20do%20them%20well%20now.%20%3CBR%20%2F%3E%3CBR%20%2F%3EOtherwise%20other%203rd%20party%20toolssonce%20there%20really%20isn%E2%80%99t%20a%20good%20way%20right%20now.%20One%20is%20coming%20with%20the%20list%20revamp%20shown%20at%20ignite.%3C%2FLINGO-BODY%3E
Jonny Rowley
Microsoft
So after a couple of hours trying to move a fairly simple SharePoint list to another Team - I did some research and it's not as easy as I thought! I tried to export it to Excel - then import it - but ActiveX stopped me I tried to import the Structure of the list - the columns went in, but no Data I can see from research that the "List Template" function doesn't work for O365 SharePoint Lists? I tried copying and pasting from the Excel into a List with the same columns - wouldn't work either. So - in simple terms what is the easiest way to Copy a list from one SharePoint (Team) to another SharePoint (Team)?
4 Replies
Have you tried the SharePoint Migration wizard? Pretty sure it can do lists and do them well now.

Otherwise other 3rd party toolssonce there really isn’t a good way right now. One is coming with the list revamp shown at ignite.

Thanks Chris, I continued to puzzle and solved it... I Downloaded the SharePoint List as Excel I then used the "Table Design" option in Excel to "Export" - then "Export Table to SharePoint List" Once I pointed it to the right SharePoint - Teams URL - et Voila it worked... Thanks for picking up and replying though... Cheers.

AFAIK, the SharePoint migration tool does not support SPO as migration source...it only supports SP 2013 and File Share. Actually Joony's approach is a good one to move lists contents...other approaches:
1) Third party migration tool
2) Extract list definition by means of PnP / Site Scripts & Site Designs and deploy it to the new site. Then, create a simple PS scripts that reads list items in the source list and copy them to the destination list
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies