File Sharing Problems

How to Copy Items Between Microsoft Lists on Different SharePoint Sites

Emma BrownEmma Brown Oct 28, 2026 871 views

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.

How to Copy Items Between Microsoft Lists on Different SharePoint Sites
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.
Before you start

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.

Solution 1Recommended

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.

1
Open both Microsoft Lists

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.

2
Enable Grid View

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.

3
Copy the source item

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).

4
Paste into the destination list

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.

Bulk Copying Limitations: While standard text cells copy easily, copying multiple items at once may result in errors depending on your column types (e.g., Choice, Person, or Lookup columns). Pasting one row at a time yields the most reliable results.
Free Microsoft Office alternative

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. 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. 2. Open with WPS Spreadsheet: Launch WPS Office, open your downloaded file, and easily copy bulk data across different sheets or workbooks.
  3. 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.
Seamlessly copy, paste, and manipulate bulk data without browser restrictions100% format compatibility with Microsoft Excel (.xlsx and .csv) filesLightweight application that runs smoothly even on older devicesFree to use with a highly intuitive, familiar user interface
microsoft office alternative - wps office

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.