Google Sheets field guide
Google Sheets Compatibility and Migration Decisions
Choose an authoritative master, inventory what must survive and test the actual recipient workflow before replacing an Excel file.
The short answer
Editing an Excel file in its original format and converting it to native Sheets are different routes. Keep the original and accept the migration only after required calculations, access and automation have been checked.
Choose the master
Check conversion risks
Define a passing result
Scope: Google Sheets in a desktop browser, a rolling web service. Mobile interfaces and paid Workspace-only capabilities are not assumed.
Choose one authoritative master
Google distinguishes editing an Excel file in its original Office format from creating a native Sheets copy. Conversion leaves the Excel original unchanged and creates a separate Sheets file. A downloaded Excel copy is another deliverable, not a promise of synchronization. Record the master URL or path and the purpose of each copy so collaborators do not update competing versions. Google’s Excel and Sheets guidance
| Need | Trial route | Acceptance boundary |
|---|---|---|
| Keep an Excel-format working file | Edit the Office-format file, if the required workflow supports it | Check the actual recipient application; do not assume native Sheets-only controls are available. |
| Adopt a native collaborative master | Convert an authorized practice copy to Sheets | Confirm ownership, required edits and recalculation in the new master; the Excel original is separate. |
| Send an Excel copy of native Sheets | Download a separate deliverable | Open and change inputs in the receiving program; do not imply ongoing synchronization. |
| Practice importing plain data | Use the existing small CSV fixtures | Check numeric types and exact identifier strings; CSV does not carry workbook formulas or sharing rules. |
Use these questions to choose a trial:
- Must the recipient keep an Excel-format deliverable, or can the team adopt a native Sheets master?
- Does the recipient need to change inputs, run automation, refresh data or only read a dated result?
- Which exact browser or receiving spreadsheet application will be used?
- Who is authorized to access the source data and approve a change of storage location?
Do not upload a real workbook merely to discover whether conversion works. Start with a private synthetic copy in an existing authorized account, and stop if access or permissions are unavailable.
Check size and long text before conversion
Google’s Drive file-size reference, checked October 23, 2026, currently lists a ceiling of 20 million cells or 100 MB for spreadsheets created in or converted to Google Sheets. These are the limits stated by that rolling page, not a measured capacity or a guarantee that an arbitrary Excel workbook will convert. The retrieved page does not specify a separate column maximum; do not infer one from the cell total. Connected Sheets has separate limits and is outside this ordinary conversion workflow.
The same reference warns that, during Excel-to-Sheets conversion, cells containing more than 50,000 characters are removed. Inspect long notes, embedded source text and concatenated fields before conversion, preserve the original, and compare the actual strings afterward. A field exactly 50,000 characters long does not exceed that stated threshold; that observation alone is not a verified import result. A 50,001-character field does exceed it.
For a planning example, three rectangular grids of 40,000 rows by 50 columns account for 3 Ă— 40,000 Ă— 50 = 6,000,000 cells. This is an inventory calculation, not a promise of speed or conversion acceptance. Check the complete workbook, including extra tabs and unused grid extents, rather than counting populated values alone. Do not confuse the spreadsheet-specific limit with Drive’s allowance for unrelated file types.
For slow editing below a size ceiling, use diagnose calculation performance. Reducing calculation work and satisfying a conversion limit are different acceptance checks.
Inventory behavior before moving data
List the critical sheets and output cells, then inventory their dependencies: formulas and named ranges, charts and pivots, imported data, automation, access roles and protected inputs. For each, write the required result, where it will be checked and who will check it. Treat a function that produces a plausible cached value differently from one that recalculates correctly after a changed input.
Automation needs a separate decision. Google describes recreating Excel macros using Apps Script; that is implementation work, not automatic VBA preservation by file conversion. List each macro’s inputs, output changes and external dependencies before estimating migration effort. Do not authorize scripts or install add-ons merely because an imported workbook requests them. Google’s macro migration guidance
For a subsequent authorized implementation, the existing script authorization, triggers and quotas guide helps distinguish the code from the permissions and execution conditions it needs.
Define acceptance without repeating the export exercise
Use the existing file-format compatibility exercise for a small conversion/download test. Its arithmetic checks distinguish an unchanged master from an independently edited copy. A return import into Sheets tests that route only; it does not establish that Excel itself calculated the file correctly.
Extend that exercise with an inventory of your actual requirements. A proposed project checklist might include:
- The designated output formula recalculates after an input changes.
- A named chart still communicates the intended categories and scale.
- The authorized recipient can perform the required edit in the selected master.
- An essential automation has a separately tested replacement, or migration remains blocked.
- The returned deliverable is opened in the recipient’s actual application.
These are proposed checks, not observations. Record each as documented constraint, observed pass, observed failure or untested, with the file identity and environment beside it. Do not collapse the checklist into a single “compatible” label.
Approve or retain the original workflow
Accept the new master only after required behavior and ownership are agreed. Preserve the source and a dated export until the handoff is verified. If recipients only need a report, agree a snapshot explicitly rather than implying that exported values provide the original automation or sharing setup.
When a requirement fails, isolate whether the problem is file identity, calculation, unsupported behavior or permissions. Start with Sheets troubleshooting. If a critical dependency is still untested, retain the original workflow and document the hold instead of silently replacing it with a simpler workbook.
Reuse a small practice download
The starter-file catalogue links the existing four-record queue CSV and separate identifier fixtures. The queue is data only, not a configured Sheets template. With its header at A1, its Hours values in D2:D5 are 3, 5, 8 and 2. A proposed import check is =COUNT(D2:D5) → 4 and =SUM(D2:D5) → 18. Both are needed: a total alone does not verify that every value imported as numeric.
These expected results were calculated independently; no import was executed for this page. Follow the catalogue’s full instructions and preserve its native-testing limitations, particularly for the separate formula workbook. This fixture checks a small data transfer, not the automation or compatibility of your production workbook.
Independent guidance, not affiliated with Sheets. The guide illustrations and icons are original concept artwork, not application screenshots or official logos. Any application screenshot in the article has its own evidence note.