How to Move a SharePoint List to Another Site Without Losing Data

Navigate to the source SharePoint list, click the Gear icon in the top right corner, and select 'List settings'.

Under the Permissions and Management section, click on 'Save list as template'.

Provide a file name and template name. Crucially, check the 'Include Content' box to ensure the records are saved, then click 'OK'.

Navigate to the List Template Gallery on your target site, upload the newly created template, and then add a new app using this template to generate the migrated list.

Create the list structure on the target site by saving the source list as a template (without checking 'Include Content') and applying it to the new site.

Open the source list in SharePoint, go to the List tab on the ribbon, and select 'Open with Access' to link the data.

Open the newly created empty list on the target site, and similarly link it to the same Microsoft Access database.

Use copy and paste or append queries within Access to move the records from the source linked table to the target linked table, which will automatically sync the data to the new SharePoint site.

Launch your chosen migration tool (such as ShareGate) and connect it to both your source and destination SharePoint environments using administrator credentials.

Navigate to the migration section and select the 'Copy Structure and Content' feature.

Map your users, column properties, and permissions as prompted to ensure metadata accuracy remains intact during the transfer.

Run the migration. Once completed, perform a post-migration check on permissions, version history, and attachment links on the target site to verify success.