While you can review your migration report within ShareGate Migrate, you can also export it as an XLSX or CSV file to analyze your results with more control in Excel.
For more info about the migration report, see Migration report overview.
Index
How to export your migration report to a drive
Select Tasks from the sidebar in ShareGate Migrate.
Open your desired migration task.
You can use filters to help you find your migration task.
Click Export.
Select where you want to save and rename your migration report as needed.
If you want to save your report as a CSV instead of an XLSX, select CSV files in the Save as type dropdown.
Click Save.
Tip: If the report exceeds the maximum number of rows in Excel, you can export it as a CSV file to split the results with your preferred text editor.
How to export multiple migration reports to a single file
Select Tasks from the sidebar in ShareGate Migrate.
Add a checkmark next to all the migration reports you want to export to a single document.
You can use filters to help you find your migration tasks.
Click Export.
Select Merge migration reports.
Select your desired File format from the dropdown.
Click Export.
Select where to save and rename your migration report as needed.
Click Save.
Tip: In the exported report, you can identify your migration jobs by filtering the Session ID column in Excel.
How to export your migration report to a SharePoint library
Start your migration process with Copy structure and content, Copy content only, Import from file share, or Import from Google Drive.
Once connected to your source and destination, click Options on the copy screen.
At the bottom of the General tab, click Setup automatic export.
Select the document library you want to export your report to.
Click Select.
Rename the report as needed.
Select your desired file type from the dropdown (XLSX or CSV).
Click + Advanced formatting to append the date and time to the file name.
Add a checkmark to Overwrite existing file.
If you don't overwrite existing files, a number will be appended to the end of the file name if it is already used.
Click the checkmark at the top right to save and close your copy options and run or schedule your migration.
Your migration report is automatically exported to your selected SharePoint library and preserved in the ShareGate Migrate Tasks screen.
Review your migration report
Once exported, you can use Excel to analyze your migration report and plan your next migration phase.
For more info, see Tips and tricks to review your migration report in Excel.