To convert Google Sheets to Excel, open the spreadsheet and select File > Download > Microsoft Excel (.xlsx). Save the downloaded file, then open it in desktop Excel or upload it to Excel for the web through your Microsoft 365 and OneDrive environment.
This creates a separate Excel workbook, not a live link to the Google Sheet. A successful download confirms that a file was created, but it does not confirm that every formula, pivot table, custom function, or formatting rule behaves the same way in Excel.
If the workbook supports financial, operational, or reporting decisions, keep the Google Sheet as the source of truth until the exported copy passes a deliberate review.
Choose the right path: export a workbook or move rows?
Start with the object you need to move. A workbook export creates a file-level artifact. A row-level automation moves selected records and fields. It does not recreate the complete workbook, including its formulas, charts, pivot tables, styles, protection settings, or Apps Script logic.
| Goal | Appropriate path | What it does not guarantee |
|---|---|---|
| One-time workbook handoff | Download as .xlsx from Google Sheets | Equivalent formulas or feature behavior |
| Repeatable or batch file exports | Google Drive API export | Workbook compatibility or correct business results |
| Ongoing movement of selected records | Row-level automation, such as Zapier | Full-workbook conversion or preservation of workbook features |
If the recipient needs the workbook itself, export and validate the .xlsx. If the recipient needs selected records to appear in another system, define the record key, field rules, and failure path before choosing a row sync.
Google documents the manual export in its spreadsheet download guidance. For a system-controlled process, the Drive API export method can return a supported format. Your application still needs to store the file and perform workbook-level checks.
Export the Google Sheet and open the .xlsx
- Open the Google Sheet you are authorized to download.
- Select File > Download > Microsoft Excel (.xlsx).
- Save the downloaded file and confirm that its filename ends in .xlsx.
- Open it with desktop Excel, or upload it to Excel for the web through your Microsoft 365 and OneDrive environment. Interface labels can vary by account and environment.
You can also locate and download files through Google Drive. Its general download guidance supports the Download action, but it does not establish that a context-menu download always produces an .xlsx file. When Excel format matters, open the sheet and choose the format from its Download menu. See Google Drive download guidance.
Validate the workbook before you share or use it
Check business behavior, not only whether Excel opens the file. For important data sheets, compare sheet names and used row and column counts with the Google Sheet. Recalculate representative business-critical formulas and compare totals, such as the sales total for a reporting period.
- Search for formula errors such as
#NAME?,#REF!,#VALUE!, and#N/A. - Inspect pivot filters, grouped dates or numeric intervals, sorting, totals, and layout.
- Check important date, currency, percentage, font, color, chart, conditional-formatting, data-validation, and protected-range behavior.
- Open the workbook in the Excel edition the recipient will actually use, especially when the workbook depends on browser or desktop features.
- Expected sheets and important data ranges are present.
- Representative formulas recalculate and critical totals match the source.
- Important formula errors and custom-function dependencies have been investigated.
- Pivot behavior and critical formatting have been reviewed.
- The intended Excel environment opens and supports the required work.
Microsoft’s spreadsheet compatibility guidance explains why formulas and features from third-party spreadsheet applications may need review. This is an acceptance routine, not proof that the workbooks are fully equivalent.
What may need repair after conversion?
Compatibility depends on the specific formula or feature, the file format, and the Excel edition. Treat the following as targeted review areas.
- Formulas: Recalculate representative formulas and compare their results with the source. Investigate errors or changed totals. Microsoft’s migrated-file formula guidance describes troubleshooting for some compatibility issues, but it does not guarantee that every formula will be repaired.
- Apps Script custom functions: A Google Sheets custom function belongs to the Sheets and Apps Script environment. Its logic is not automatically converted into an Excel-native implementation. Identify affected cells and have an owner rebuild the logic with Excel formulas, VBA, Office Scripts, or another supported approach. See Google’s documentation on custom functions in Sheets.
- Pivot tables: Check filters, sorting, totals, grouped dates or numeric intervals, and layout in the exported workbook. Google documents these controls in its Sheets pivot-table guidance; that documentation does not specify how every setting transfers to Excel.
- Formatting and workbook features: Inspect the styles and number formats that matter to the recipient, along with charts, conditional formatting, data validation, and protection settings.
Treat conversion as a controlled handoff: the file can be delivered automatically, but business meaning is accepted only after the recipient checks the workbook in its working environment.
Automate repeat exports or row-level updates
For repeat file exports, an application can authenticate to Google Drive, identify the spreadsheet, request an Excel export, store the returned file, and record the outcome. A useful export record includes the source file ID, export time, destination filename, and validation status. Include a source revision or timestamp when available. The export result and the validation result should remain separate fields.
For row-level updates, a proposed workflow is: a new or updated Google Sheets row triggers the automation, mapped fields are checked, the destination is searched using a stable key where appropriate, and an Excel row is created or updated. Assign an owner to review missing IDs, rejected values, permission failures, and failed writes. Do not use a visible row number as identity because sorting, insertion, and deletion can change row positions.
For example, suppose one source row represents one customer order. This is an illustrative mapping, not an official Zapier template:
{
"order_id": "ORD-1042",
"customer_id": "C-208",
"order_date": "2026-11-12",
"amount": 125.50,
"currency": "USD"
}Validate required fields and allowed currency values before writing. A proposed row-level key is the source spreadsheet ID, worksheet identifier, and immutable order_id. A search followed by create is not safe against concurrent runs. Where duplicate prevention matters, use a destination-side uniqueness constraint or a transactional upsert. If the destination is only a spreadsheet, serialize writes where possible and retain the proposed key in a dedicated column, without treating that column as equivalent to a database constraint.
Zapier’s Excel integration documents OneDrive for Business-hosted .xlsx workbooks and a Microsoft 365 Business or Enterprise paid account. Local desktop workbooks and .xls files are not supported. The workbook should have headers in the first row and usable data beginning in the second row. Blank rows and structural changes, such as renaming columns or worksheets, can disrupt an automation. Excel row triggers may poll, so timing depends on the selected trigger and account configuration rather than guaranteeing real-time delivery. Review the current details in Zapier’s guides for Google Sheets, Microsoft Excel, Excel workbook structure, and how Zap triggers work.
If you need help choosing between a repeatable export and row-level automation, see Zapier automation design.
A practical acceptance test for the converted workbook
Before promoting the .xlsx to the working version, the workbook owner should record who accepted it and when. Also record whether Google Sheets or Excel is the ongoing system of record. Keep the Google Sheet as the source until the recipient confirms that the Excel copy works in the intended environment.
Successful opening is necessary but not sufficient when the workbook drives operational or financial decisions. Share or promote the file only after expected data is present, critical calculations agree, investigated errors and custom-function dependencies have an owner, and important pivots and formatting have been checked.