Copying a SharePoint LIST from a Team to another Team

[Jonny Rowley]

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)?

[#2]

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.

[#3]

Sorry. SharePoint Migration Tool, provides by Microsoft. https://docs.microsoft.com/en-us/sharepointmigration/introducing-the-sharepoint-migration-tool

[#4]

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.

[#5]

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