Microsoft Lists - how to move?

[Andre Siregar]

Is there a way to move a List, e.g. from my personal space to an Office365 Group? There does not seem to be a way to do this other than using workaround of export & import to Excel.

However, if I click "Export to Excel" from Lists, all I get is a file called query.iqy. Does anybody else experience this issue?

[#2]

Same isue here. Anyone?

[#3]

I have this same problem.

@NardKlaass 

[#4]

@kristinholm From what I understand it is possible to copy lists between SP-sites. However if you've made a list in your own work space you're out of luck. Moving/copying isn't possible then.

I've recreated the list in a SP-site.

[#5]

@Andre Siregar 
It seems that you can download the lists as indicated in this post SharePoint lists - How to move them from one site to another - Microsoft Community, but it is unclear to me how you can upload them again to the SharePoint site. What is your Excel workaround?

[#6]

As previously mentioned the 'Export to Excel' seems the only option.

For anyone else, this is how I did it

1. In Microsoft Lists export to Excel (it will be an .iqy file extension)

In Microsoft Lists Export to Excel

2. In Sharepoint site page click new list

In Sharepoint site page click new list

3. Upload your excel file 

Create a new list from excel (and upload your excel file)

To finish

Check the column types and choose a new type if the current selection is incorrect.

Check the column types

-----

I hope this helps

[#7]

@bryandibben I followed your recommendation however when I tried to import the excel file I received the following error message. Help is much appreciated.

[#8]

I think problem with Excel export and import is that it will not Export the comments so its not complete solution.