How to bulk move items between SharePoint lists | SharePoint List Transfer - BoostSolutions App, Saas & Software for Microsoft 365, Microsoft Teams, SharePoint

How to bulk move items between SharePoint lists?

Items are the essential part of SharePoint list. Although SharePoint enables end users to create, edit and delete items in a list, it doesn’t have functions like copying/moving items or documents between SharePoint lists or libraries.

List Transfer enables end users to copy/move items or documents in bulk between SharePoint lists or libraries which makes it possible to reuse items or documents among multiple SharePoint lists or libraries. In this article we will demonstrate how to move items between SharePoint lists.

WHAT YOU'LL GET

Two items (Mexican branch and Canada branch) have been moved from Branches list to North America Branches list. The columns were mapped automatically.

The items have been moved from Branches list to Asia Branches list. The columns were mapped manually.

WHAT YOU'LL NEED

List Transfer

The sample data we use for this case

Then, let’s create another list named as Asia Branches with columns as following. You will find out that columns in Asia Branches are not the same as that in the Branches list. In this list, we don’t create any items either. We will move items from Branches list for it as well.

Bulk move items between SharePoint lists and Map columns automatically

Download the trial version of List Transfer, and install it to your SharePoint server.
Navigate to the Branches list prepared above.
Select items which you want to bulk move to North America Branches list. Here we selected the two items showing below (the Mexican branch and the Canada branch).
Click ITEMS tab, in the Copy & Move group, click Move Items.
Then, you will be redirected to Move Items page. In Move Items page. There are 3 main sections:

Target: In this section, you will specify which target list or folder you want to copy selected items to. You can click Click to browse (or click the small downward triangular arrow on the right to expand the drop-down list) to choose a target list or you can enter destination URL.

Preserve Information: In this section, you can select which information you want to preserve for items in the destination. There are 3 kinds of information you can preserve: Item Permissions, Attachments and Authors and Timestamps. The first two options are checked by default.

Column Mapping: In this section, it enables you to map columns between source list and target list. You can choose to Map columns automatically (with this option checked, it only copies values with same column name and type) or Map columns manually.
In the Move Items page, let’s configure settings as following.

In the Target section, click Click to browse (or click the small downward triangular arrow on the right to expand the drop-down list) to select the North America Branches list we prepared above.

In the Preserve Information section, keep settings as default (with Items Permissions and Attachments selected). It means that the permissions and attachments of selected item(s) will be moved along with the item(s) to the destination list. Note that the permissions will be preserved only if the item has unique permissions, otherwise it will inherit permissions from its parent, the target list.

In the Column Mapping section, select Map columns automatically option. Note that the values can only be moved if the column names and types are the same in the source list and target list. Because the column names and types in the North America Branches are just the same as that in the Branches list, so we can use the automatic mapping here.
Then, click Move. Then, the following window will pop up when the moving process is completed.
Click Go To Target to go to the North America Branches list, you will find out that the two selected items have been moved successfully to this list as shown below. And the attachment has been also copied to the destination list all along.
Now, let’s navigate back to the Branches list, you will find out that the two moved items have been disappeared from Branches list as following. That's what Move Items means, it moves items from the source list to the target list, and deletes the moved items from the source list.

Bulk move items between SharePoint lists and Map columns manually

Download the trial version of List Transfer, and install it to your SharePoint server.
Navigate to the Branches list prepared above.
Select items which you want to bulk move to Asia Branches list. Here we selected six items as showing below.
Click ITEMS tab, in the Copy & Move group, click Move Items.
In the Move Items page, let’s configure settings as following.

In the Target section, click Click to browse (or click the small downward triangular arrow on the right to expand the drop-down list) to select the Asia Branches list we prepared above.

In the Preserve Information section, keep settings as default (with Items Permissions and Attachments selected).

In the Column Mapping section, select Map columns manually option. Then map the columns manually according to your need. Because the column names in Asis Branches are not the same as that in the Branches list, so we need to map the columns manually here. Map columns from the Branches list to Asia Branches list as shown below.
Click Move. Then, the following window will pop up when the moving process is completed.
Click Go To Target to go to the Asia Branches list, you will find out that the six selected items have been moved successfully to this list as shown below. And the attachments of items have also been moved to the destination list all along.
Now, let’s navigate back to the Branches list, you will find out that the moved items have been disappeared from Branches list as following.