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,...
M365Specialist
Mar 05, 2023Brass 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. https://support.microsoft.com/en-us/office/video-customize-the-ribbon-9ce81e05-ecc1-4142-a3e3-1298b37a59c6
This is the best solutions I've found so far, I hope it helps you too.
Txikiting
Mar 13, 2023Copper 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.