Forum Discussion
Andre Siregar
Sep 22, 2020Brass Contributor
Microsoft Lists - how to move?
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?
- spepper2165Copper Contributor
Garbage program that ties one into MS365 forever (unlike excel files). One can work via export for simple files but when one has attached a pile of documents to the list as the program is intended, there is no way to move to a non-sharepoint site (i.e one's personal harddrive) etc. Very frustrating and lack of disclosure.
- jb_r3dCopper Contributor
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?- M365SpecialistBrass Contributor
Hi jb_r3d
When I need to upload a list to SPO from an excel spreadsheet, I use the 'Export to SharePoint' feature in Excel. Here's how:- Download the list and open it in Excel.
- Select the entire table.
- Click the 'Table Design' tab.
- In the Export section of the tab, select 'Export Table to SharePoint'
- Enter a name for your list and provide the URL of the SPO site contents you want to send the list to.
If you don't have the Export section in the Table properties yet, you'll need to customise your Excel ribbon. This information from Microsoft should help with that. Video: Customize the ribbon - Microsoft Support
This is the best solutions I've found so far, I hope it helps you too.- TxikitingCopper Contributor
M365Specialist , if the list has any customization like controlling when a field is hidden or shown, with your process you'll lose it, all custom's will be gone.
This is mentioned above many times.
But thanks anyway.
- bryandibbenCopper Contributor
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
- KatjavKCopper Contributor
bryandibben I followed your recommendation however when I tried to import the excel file I received the following error message. Help is much appreciated.
- NardKlaassCopper Contributor
Same isue here. Anyone?
- kristinholmCopper Contributor
I have this same problem.
- NardKlaassCopper Contributor
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.