Knowledge Base

How to bulk move documents between SharePoint libraries?

Documents are the essential part of SharePoint. Although SharePoint enables end users to create, edit and delete documents in a library, it doesn’t have functions like moving them between SharePoint libraries.

List Transfer enables end users to move documents in bulk between SharePoint libraries, which make it possible to reuse documents among multiple SharePoint libraries. In this article we will demonstrate how to move document between SharePoint libraries.

WHAT YOU'LL GET

The documents have been moved from Product Brochures library to Reviewed Brochures library. The columns were mapped automatically.

The documents have been moved from Product Brochures library to Brochures waiting for review library. The columns were mapped manually.

WHAT YOU'LL NEED

The sample data we use for this case

Then, let’s create another library named as Brochures waiting for the review with columns as following. In this library, we don’t create any documents for it either. We will copy documents from Product Brochures for it as well. Notice that columns in Brochures waiting for the review are not the same as that in the Product Brochures.

Bulk move documents between SharePoint libraries and Map columns automatically

  1. Download the trial version of List Transfer, and install it to your SharePoint server.

  2. Navigate to the Product Brochures library prepared above.

  3. Select documents which you want to bulk copy to Reviewed Brochures library. Here we selected the two documents showing below (the Batch Check In Brochure and the Document Number Generator Brochure).

  4. Click FILES tab, in the Copy & Move group, click Move Documents.

  5. Then, you will be redirected to Move Documents page. In Move Documents page. There are 3 main sections:

    Target: In this section, you will specify which target list or folder you want to move 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. Below the Specify destination, you can find an option named as overwriting existing files, with it checked, the existing files in the target library will be overwritten by the copied ones if the copied ones have been in the target library already.

    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, Version History and Authors and Timestamps. The first option is 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.

  6. In the Move Documents 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 Reviewed Brochures list we prepared above. Ignore the Overwrite existing files.

    In the Preserve Information section, select Items Permissions and Version History. It means that the permissions and version history of selected document(s) will be copied along with the document(s) to the destination library. Leave the Erase target version history unchecked.

    In the Column Mapping section, select Map columns automatically option. Note that the values can only be copied if the column names and types are the same in the source list and target list. Because the columns in the Reviewed Brochures are just the same as that in the Product Brochures, so we can use the automatic mapping here.

  7. Click Move. Then, the following window will pop up when the copying process is completed.

  8. Click Go To Target to go to the Reviewed Brochures library, you will find out that the two selected documents have been moved successfully to this library as shown below.

    Also when we check the Product Brochures library, we will see that those two documents disappeared from the library.

Bulk move documents between SharePoint libraries and Map columns manually

  1. Download the trial version of List Transfer, and install it to your SharePoint server.

  2. Navigate to the Product Brochures library prepared above.

  3. Select documents which you want to bulk copy to Brochures waiting for the review library. Here we selected the two documents showing below (AD Self Service Brochure and the Calendar Rollup Brochure).

  4. Click FILES tab, in the Copy & Move group, click move Documents.

  5. In the Move Documents 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 Brochures waiting for the review list we prepared above. Keep other settings as default.

    In the Preserve Information section, select Items Permissions and Version History. It means that the permissions and version history of selected document(s) will be copied along with the document(s) to the destination library. Leave the Erase target version history unchecked.

    In the Column Mapping section, select Map columns manually option. Because the columns in the Brochures waiting for the review are not the same as that in the Product Brochures, so we need to map columns manually this time.

  6. Click Move after configurating the mapping. Then, the following window will pop up when the moving process is completed.

  7. Click Go To Target to go to the Brochures waiting for the review library, you will find out that the two selected documents have been moved successfully to this library as shown below.

    Also when we check the Product Brochures library, we will see that those two documents disappeared from the library.

Login