SharePoint Document Issues

How to Move Microsoft Lists from My Lists to a SharePoint Site

Tauseeq Magsi Sep 25, 2026 870 views

Question details

The user needs to transfer a Microsoft List from their personal My Lists space to a company SharePoint site, but there is no direct move command available in the interface.

How to Move Microsoft Lists from My Lists to a SharePoint Site

Product: Microsoft Lists
Device & OS: not provided
Scenario: Migrating a personal list to a shared company workspace.
Observed behavior: Microsoft Lists does not offer a native move option to transfer personal lists directly to SharePoint sites.

Before you start

Ensure you have the necessary permissions to create lists on the destination SharePoint site and review your current list columns, as custom views or complex formulas might need manual adjustments after the migration.

Solution 1Recommended

Create a New List Using the Existing List Feature

This is the most straightforward method to duplicate your list structure and content into a SharePoint site directly within Microsoft Lists.

Since a direct move button does not exist, creating a new list based on the existing one effectively copies your data over to the desired location.

Open Microsoft Lists

Navigate to Microsoft Lists and click on the '+ New list' button at the top of the screen.

Select List Source

Click on 'From existing list' in the create list menu options.

Choose the Original List

Select the specific list you want to transfer from your 'My Lists' section.

Select Destination

Under the 'Save to' dropdown menu, select the destination SharePoint site where you want the list to reside.

Verify Data

Open the newly created list on the SharePoint site to ensure all columns and items have transferred correctly.

Create a New List Using the Existing List Feature

Post-Migration Check: You will need to manually verify permissions, recreate custom views, and check column formulas after the new list is created.

Solution 2

Export to Excel and Re-import to SharePoint

Use this alternative method if the direct list duplication fails or if you want to clean up data in Excel before moving it to SharePoint.

Free Microsoft Office alternative

Manage Exported List Data Efficiently with WPS Office

While migrating your Microsoft Lists, you may need to export data to Excel for restructuring. WPS Office provides a lightweight, highly compatible, and free alternative to manage and clean your spreadsheets seamlessly before importing them into SharePoint.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Exported Data: Open the list data you exported from Microsoft Lists (.csv or .xlsx) using WPS Spreadsheet.
3. Clean and Prepare: Format your data as a table, adjust column types, and save the file ready for your SharePoint import.

Fully compatible with Microsoft Excel (.xlsx) formatsLightweight application that runs smoothly on any deviceAdvanced data filtering and formatting tools for list cleanupFree to use with a familiar tabbed user interface

microsoft office alternative - wps office

Frequently Asked Questions

Will my custom views and permissions transfer when I create a list from an existing one?

No, custom views, item-level permissions, and specific column formatting or formulas often do not carry over automatically. You will need to recreate these settings manually on the new SharePoint site.

Can I move a list if I don't have Full Control permissions on the SharePoint site?

You need at least 'Edit' or 'Contribute' permissions (specifically the ability to 'Manage Lists') on the destination SharePoint site to create a new list or import data from an existing one.

What happens to the original list in My Lists after I duplicate it to SharePoint?

The original list remains intact in your My Lists space. Duplicating or exporting does not delete the source data. Once you verify the new SharePoint list is working correctly, you can safely delete the original one.

Document & File Issues