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