To export a Google Sheets spreadsheet for Excel, open it in a browser and choose File > Download > Microsoft Excel (.xlsx). Sheets downloads an Excel workbook while leaving the original in Google Drive; the best format and workflow depend on whether you need every tab, just one tab, or a non-editable copy.
What exporting from Google Sheets means
Google Sheets is a browser-based spreadsheet, while Microsoft Excel is a separate spreadsheet application. Exporting creates a file in a format Excel can open; it does not turn the live Google Sheet into an Excel document that stays synchronized. After downloading, changes made to the local .xlsx file will not automatically appear in the Google Sheet, and edits made to the Google Sheet will not update that downloaded file.
The usual choice is the .xlsx format, the current Excel workbook format. It can contain multiple worksheets, formulas, formatting, and other workbook elements. It is generally a better option than older .xls files for sharing with current versions of Excel. Google Sheets’ download menu offers Microsoft Excel (.xlsx); if a recipient specifically needs an older format, they can open the workbook in Excel and use Excel’s Save As options, checking for compatibility warnings.
How to download an Excel workbook
- Open the spreadsheet in Google Sheets in a web browser and confirm you are viewing the right file.
- Select File > Download > Microsoft Excel (.xlsx).
- Choose where to save the downloaded file if your browser asks. Otherwise, look in the browser’s default downloads folder.
- Open the .xlsx file in Excel and review the important sheets, formulas, and formatting before sharing or relying on it.
This downloads the spreadsheet as a separate file; it does not remove or replace the Google Drive original. The same Sheets menu path is used in a browser on Windows or Mac. The operating system may affect where the browser saves the download, but not the export choice. Excel for Windows and Excel for Mac can open .xlsx files; the Excel menus for later editing or saving may differ by platform.
For a spreadsheet you do not own, your ability to download can depend on the owner’s sharing settings. If the download option is unavailable, ask the owner for access or an exported copy rather than trying to bypass the restriction.
Other Google Sheets download formats
Excel is not the only export option. In Sheets, open File > Download to see the formats available for the current spreadsheet. Choose based on what the recipient needs to do with the data:
- Microsoft Excel (.xlsx): Best for an editable workbook that may have several tabs, formulas, and formatting.
- OpenDocument (.ods): Useful when the recipient works in a spreadsheet application that supports the OpenDocument format.
- Comma-separated values (.csv): A plain-text data format suited to importing or processing a single tab. It does not preserve a workbook’s multiple tabs, formulas as working formulas, or visual formatting.
- Tab-separated values (.tsv): Similar to CSV, but uses tabs between fields. Like CSV, it represents the current sheet rather than the whole multi-tab workbook.
- PDF (.pdf): Better for viewing or printing a report than for spreadsheet editing. Page layout and print settings affect how it looks.
- Web page (.html, zipped): Provides a web-oriented representation, not a replacement for a fully editable Excel workbook.
CSV and TSV are often misunderstood as Excel workbook formats because Excel can open them. They are text files, not complete workbooks: opening one in Excel does not restore the other tabs or the original cell formatting. Use .xlsx when retaining workbook structure matters.
What usually transfers—and what to check
An .xlsx export is intended to carry spreadsheet content into Excel, including worksheets, cell values, many formulas, and much of the formatting. However, Google Sheets and Excel do not implement every feature identically. Do not assume that a workbook will look or calculate exactly the same in both applications simply because it opens without an error.
Check features that are especially likely to need attention: complex charts, conditional formatting, data validation, named ranges, pivot tables, protected ranges, and formulas that use Google Sheets-specific functions. Excel may not support a Sheets-only function, and a formula can behave differently or show an error after conversion. Inspect important totals and sample formulas in Excel rather than judging the export only by its appearance.
Also look at dates, times, and numbers. A value that appears as a date in Sheets can display differently if the workbook’s regional settings or cell format differ in Excel. Formatting may change the display without changing the underlying value. For critical reports, compare a few known dates, decimal values, and totals on both sides. Charts and print layouts can also shift because fonts, page sizes, and rendering differ.
Google Sheets features that rely on Google services do not become equivalent Excel services just by exporting. For example, a formula that retrieves data from an external Google source may need a different data source or process in Excel. Similarly, a Google Sheets macro is based on Apps Script; it does not become an Excel VBA macro. Treat export as a file conversion, not as a full migration of every connected tool or automation.
Exporting only one tab
The .xlsx download normally represents the spreadsheet workbook, including its tabs. If you need just one tab as a separate Excel workbook, a practical method is to copy that sheet into a new Google spreadsheet and download the new spreadsheet as .xlsx. Use the sheet tab’s menu, choose Copy to, then New spreadsheet. Open the new spreadsheet and select File > Download > Microsoft Excel (.xlsx).
If you only need the tab’s cell data and not its formulas, formatting, or workbook structure, downloading CSV or TSV from the tab you are viewing may be enough. These formats export the current sheet, so make sure the correct tab is active first. They are not suitable when you need a chart, multiple tabs, or Excel formulas to remain editable.
Another option is to copy the relevant range into a fresh spreadsheet before exporting. This gives you a chance to remove unrelated content and check what will be included. If the values should be fixed rather than recalculated, copy and paste values in Sheets before export; otherwise formulas may continue to calculate in Excel, provided they are supported.
Choosing the right option for the job
Think first about the recipient’s intended use, not just the file extension. For ongoing analysis in Excel, use .xlsx and ask the recipient to review formulas and formatting. For importing a clean data table into another system, CSV or TSV may be easier, but confirm the expected delimiter and remember that these formats hold only one tab. For a report that should look consistent and not be edited, PDF is usually a better fit.
- Collaborative editing in Google Sheets: Share the Google Sheet with the right permissions instead of emailing repeated exports.
- Editing in Excel: Download .xlsx and treat it as a separate working copy.
- Moving one table into a database or another tool: Use CSV or TSV and check how that tool interprets dates, commas, and text.
- Sending a finished snapshot: Export a PDF and inspect the page breaks before sending.
If the recipient only asks for an Excel file, .xlsx is the straightforward answer. Ask for clarification when they mention a system import, a fixed layout, or a single worksheet; those requirements can change the best format.
Editing the file again in Google Sheets
An exported workbook can be uploaded to Google Drive and opened with Sheets, but this creates another point in the workflow rather than linking the downloaded file to the original. Depending on the file and account settings, Sheets can work with Office files or convert an Office file into Google Sheets format. When an Office file is open in Sheets, File > Save as Google Sheets creates a converted Google Sheets copy. Keep the original .xlsx if you need to preserve it unchanged.
Repeatedly moving a complex workbook between Sheets and Excel can introduce differences in formulas, formatting, or features. If the file is intended to live in Excel, make Excel the main editing copy and avoid treating the Google version as a perfectly synchronized twin. If the spreadsheet is meant for collaboration in Sheets, keep that as the source of truth and export only when someone needs a snapshot or an Excel copy.
Common export problems and checks
If you cannot find the downloaded file, check the browser’s downloads list and its configured download folder. If the export is missing a tab, confirm whether you chose .xlsx or a text format such as CSV; CSV and TSV cover the active sheet only. If the downloaded file will not open, confirm that the download finished and that the file has an .xlsx extension, then download it again if needed.
When a workbook opens but shows formula errors, identify whether the affected formulas use a function or data connection specific to Sheets. The export itself cannot guarantee an Excel equivalent for every such feature. For a simple handoff, you may choose to replace formulas with their current values in a copy, but do this only if the recipient does not need recalculation. Preserve the original before making that change.
For appearance problems, inspect the affected cells or chart in both applications and adjust the Excel copy if necessary. Check hidden rows, columns, and sheets too: a hidden item may still be present in the workbook even though it was not visible in the Google Sheet. A quick review of each tab, key totals, and print preview can catch many surprises before the file is sent.
Sharing and data safety
Exporting makes a separate file that can be copied, attached, or stored outside Google Drive. Drive sharing permissions do not automatically govern that downloaded copy. Before sending it, check for confidential tabs, hidden data, comments, or information that the recipient should not receive. If you remove content, confirm that it is actually removed from the exported copy rather than merely hidden.
For sensitive information, use an approved sharing method and limit access to the people who need it. A PDF may reduce accidental editing, but it should not be treated as a security control that prevents copying or disclosure. Likewise, an .xlsx file is editable and may contain more workbook structure than is visible at first glance.
Frequently Asked Questions
How do I export Google Sheets to Excel?
Open the spreadsheet and choose File > Download > Microsoft Excel (.xlsx). The file downloads to your computer, while the Google Sheets original remains in Drive.
Does Google Sheets export all tabs to Excel?
The .xlsx option exports a workbook with its tabs. CSV and TSV downloads represent the current sheet only. Check the downloaded workbook before sharing if you need a particular set of tabs.
Can I export just one Google Sheets tab as an Excel file?
Copy the tab to a new spreadsheet using its tab menu and Copy to > New spreadsheet, then download that spreadsheet as .xlsx. For data only, CSV or TSV can export the active tab.
Will formulas work after exporting to Excel?
Many formulas can carry over, but Sheets-specific functions and connected data features may not have an Excel equivalent. Open the file in Excel and check important formulas and results before relying on them.
Does exporting change the Google Sheets original?
No. Downloading creates a separate file and does not replace the original. Edits to either copy do not automatically synchronize with the other.
Should I choose XLSX, CSV, or PDF?
Choose XLSX for an editable multi-sheet workbook, CSV for a plain-text table from the active sheet, and PDF for a layout intended mainly for viewing or printing.
Related
- Extract Data from Google Maps to Excel: Practical Options
- Export Excel to Word: Methods and Formatting Tips
- Expand Data Validation Lists in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Freeze the Bottom Row in Excel While ScrollingExcel does not have a built-in command to freeze the bottom row of a worksheet. In Excel for…
- Archive Outlook Emails to a Local Folder as a PST FileYes. In classic Outlook for Microsoft 365 on Windows, export the messages to an Outlook Data File (.pst)…
- How to Delete a Tab in Excel Without Losing Your DataTo delete a worksheet tab in Excel for Microsoft 365 on Windows, right-click the sheet tab at the…
- Undo in Excel: Reverse Your Last ActionTo undo the last action in Excel for Microsoft 365 on Windows, press Ctrl+Z. Press it again to…
- Excel Keyboard Shortcut to Insert a NoteIn Excel for Microsoft 365 on Windows, select a cell and press Shift+F2 to insert a note. If…
- Page Break in Excel Shortcut: Insert and Adjust BreaksIn Excel for Microsoft 365 on Windows, select the row, column, or cell where the printed page should…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.