How to Copy Items Between Microsoft Lists on Different SharePoint Sites
Question details
The user wants to know if it is possible to copy list items from one Microsoft List to another across different SharePoint sites, and how to execute the paste operation.

- Product
- Microsoft Lists / SharePoint
- Device & OS
- not provided
- Scenario
- Transferring or duplicating data records from a Microsoft List on a specific SharePoint site to a matching List on a completely different SharePoint site.
- Observed behavior
- The user is seeking the correct method to cross-copy data, as standard copy-paste operations behave differently in web-based SharePoint lists compared to local spreadsheet software.
Verify that you have Edit permissions for both the source and destination Microsoft Lists. Ensure that the destination list has the exact same column structure and data types as the source list to prevent pasting errors.
Use Grid View to Copy and Paste Items Individually
Leverage the 'Edit in grid view' functionality in your web browser to manually copy data from the source list and paste it into the destination list.
Microsoft Lists allows for cross-site data copying, provided both lists are in an editable grid mode. Because of how browser clipboards and SharePoint database structures work, it is highly recommended to process complex records one item at a time to ensure data integrity.
Open the source Microsoft List on the first SharePoint site in one browser tab, and open the destination List on the second SharePoint site in an adjacent tab.
In both browser tabs, click the 'Edit in grid view' button located on the top command bar. This transforms the list interface into an editable, spreadsheet-like format.
Navigate to the source list, click and drag your cursor to highlight all the cells for the single item you wish to copy, and press Ctrl+C (Windows) or Cmd+C (Mac).
Switch to the destination list tab, select the corresponding empty cells in a new row, and press Ctrl+V (Windows) or Cmd+V (Mac) to paste the copied data. Click 'Exit grid view' when finished to save.
Manage Data More Efficiently with WPS Spreadsheet
If you are struggling with the limitations of moving bulk data between online SharePoint Lists, WPS Spreadsheet offers a robust, free, and lightweight desktop alternative. You can easily export your lists to Excel, manage thousands of rows offline without permission barriers, and enjoy a familiar interface.
- 1. Export your SharePoint List: In your Microsoft List, click 'Export' and select 'Export to Excel' or 'Export to CSV' to download your data locally.
- 2. Open with WPS Spreadsheet: Launch WPS Office, open your downloaded file, and easily copy bulk data across different sheets or workbooks.
- 3. Save and Re-import: Save your meticulously organized data and use it to populate new lists or share directly as a highly compatible spreadsheet file.

Frequently Asked Questions
Can I copy multiple items at once between different SharePoint Lists?
While it is technically possible to highlight multiple rows in grid view, doing so across different SharePoint sites often results in pasting errors due to complex column types (like Date or Person columns). It is best practice to copy one item at a time or export the list to a spreadsheet for bulk transfers.
What happens if the columns in the destination list do not match the source list?
If the destination list is missing columns or uses different data types, the paste operation will either fail completely or insert the data into incorrect fields. Always ensure both lists have identical column structures before attempting to copy and paste.
Is there a faster way to migrate an entire list to another SharePoint site?
Yes. Instead of manually copying and pasting in grid view, you can export the original list to Excel or CSV. Then, go to the new SharePoint site, select 'New List', and choose 'From Excel' or 'From CSV' to create a fully populated list instantly.




