Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
Sheet Scan uses a limited sample from each spreadsheet. It first retrieves up to 1,000 grid cells across the spreadsheet's tabs, including blank cells. Within that sample, formula evaluation stops after 100 cells containing incompatible formulas. Multiple incompatible functions in one cell count as one affected cell; repeated formulas in different cells count separately. Embedded links are reported separately, so the total issue count can exceed 100. These limits apply to assessment, not to the number of cells migrated.
Sheet Scan identifies potential formula compatibility issues and embedded Google links to review when migrating Google Sheets to Microsoft Excel files. Migration Manager generates reports of findings from the scanned sample. Embedded-link findings aren't confirmed broken links. The scan doesn't correct formulas or rewrite links.
The sheet scan is turned off by default. Once you enable it in project settings, it automatically runs as part of the general scan process.
Learn more:
- How to run a general scan process in Migration Manager
- How to start a Google Drive migration project in Migration Manager
Prerequisites
You must grant the Microsoft 365 Migration app access to all your Google Sheets spreadsheets in Google Marketplace. Spreadsheet access must be granted before Migration Manager can run a sheet scan on your Google Sheets.
Grant access to Google Sheets
- Sign in with your Google admin credentials to Google Workspace Marketplace.
- Under Drive, verify that See all your Google Sheets spreadsheets shows Granted.
- If access isn't granted, select Grant access at the top of the page.
- After access is granted, Migration Manager can scan Google Sheets spreadsheets.
Enable sheet scan
To enable a Google Sheet scan in a Google Drive migration project:
- Select Project Settings in the top-right toolbar.
- Select the Advanced tab.
- Select the Enable Google Sheet scan setting. Once enabled, the sheet scan is automatically included as part of the general scan.
Sheet scan reports
After a general scan completes, it might take some time to generate the sheet scan reports. To download the reports, select one or more scan tasks, and then select Download reports > Sheet summary or Sheet detailed from the action bar.
| Report type | Download menu | Tasks selection limit | Report name | Report Description |
|---|---|---|---|---|
| Sheet Summary | Download report – Sheet summary | Can select up to 1,000 tasks | SheetSummary.csv | Available sheet scan results for the selected tasks. |
| Sheet detailed | Download report – Sheet detailed | Can select up to 100 tasks | - SheetItem.csv - SheetIssue.csv |
SheetItem.csv: Lists files represented in the available scan results and their reported finding counts. SheetIssue.csv: Lists issue details for the selected tasks. |
SheetSummary.csv
A summary of available sheet scan results for the selected tasks. Each row identifies a task and scan transaction. Incomplete processing can mean some files or tasks aren't yet represented.
| Column name | Description |
|---|---|
| TaskId | ID of the selected task, used for troubleshooting. |
| TransactionId | ID of the scan run, used for troubleshooting. |
| Name | Display name of the selected task in the source. |
| SourcePath | Source path of the selected task. |
| TotalFiles | Number of spreadsheet files represented in the available scan results. |
| FilesWithIssues | Number of files with reported findings, including scan errors. |
| IssueCount | Number of reported formula, link, and scan-error findings. |
| SheetScanStatus | Processing status of the sheet scan. Completion can include files with scan errors. |
SheetItem.csv
Lists files represented in the available scan results and their reported finding counts.
| Column name | Description |
|---|---|
| TaskId | ID of the selected task, used for troubleshooting. |
| TransactionId | ID of the scan run, used for troubleshooting. |
| Name | Display name of the selected task in the source. |
| SourcePath | Source path of the selected task. |
| FullPath | Full path of the item in the source. |
| FileName | Name of the spreadsheet file. |
| LastModified | Last modified time of the Google Sheets file. |
| IssueCount | Number of reported findings for the file, including scan errors. |
SheetIssue.csv
Issue details of selected tasks.
| Column name | Description |
|---|---|
| TaskId | ID of the selected task, used for troubleshooting. |
| TransactionId | ID of the scan run, used for troubleshooting. |
| Name | Display name of the selected task in the source. |
| SourcePath | Source path of the selected task. |
| FullPath | Full path of the item in the source. |
| FileName | Name of the spreadsheet file, when available. |
| LastModified | Last modified time of the Google Sheets file. |
| SubSheetName | Name of the tab containing the finding, when available. |
| CellLocation | Location of the cell containing the finding, when available. |
| CellContent | Reported formula or embedded URL, when available. |
| IssueType | Type of finding: Incompatible formula, Embedded links, or Scan Error. A Scan Error means the file couldn't be assessed. |
| IssueDetail | Details of the issue found. |