How to Export from Google Sheets to Excel

What this does

Both directions work and both lose things. Google Sheets opens .xlsx directly, either in Office-compatibility mode (the file stays .xlsx) or converted to native Sheets format via File ▸ Save as Google Sheets, which is the mode where Sheets features actually work. What does not survive the round trip is predictable: VBA macros are dropped entirely, Power Query connections do not exist in Sheets, PivotTables are rebuilt as Sheets pivot tables with different options, conditional formatting with complex rules is simplified, and some newer Excel functions have no equivalent. Going the other way, File ▸ Download ▸ Microsoft Excel converts Sheets formulas back where an equivalent exists and leaves #NAME? where one does not — ARRAYFORMULA, QUERY, IMPORTRANGE and GOOGLEFINANCE have no Excel counterpart. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. Treat “export from google sheets to excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected sheet shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a data step that keeps your analysis trustworthy into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

Upload budget.xlsx to Drive and double-click it: Sheets opens it in compatibility mode with the .xlsx badge in the title. Its SUMIFS and XLOOKUP formulas keep working; its macro-driven refresh button does nothing. Choose File ▸ Save as Google Sheets to get a native copy where collaboration and version history behave properly. Coming back, File ▸ Download ▸ Microsoft Excel (.xlsx) produces a file Excel opens cleanly — but any cell using =QUERY() lands as #NAME?. Files cross between the two constantly — a client sends .xlsx, a team collaborates in Sheets — and knowing exactly what does not survive is what stops a silently broken formula reaching a report. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

This is a conversion between two products, so "identical" is the wrong expectation: most cell values and common formulas survive, but macros are dropped, Power Query and some PivotTable options do not transfer, links to other workbooks break, and functions that exist in only one product return errors after the move. Check those parts after converting. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. Here is the takeaway for “export from google sheets to excel”: follow the steps at the top, check the result on the sheet itself, and keep undo in mind while you experiment. Done once deliberately, it becomes something you do from memory in Excel rather than something you search for again.

Common mistakes

• Expecting macros to come across; VBA is dropped without warning in either direction.
• Working in compatibility mode long-term and wondering why some Sheets features are greyed out.
• Converting a workbook with linked external files, which breaks every link.
• Downloading from Sheets and shipping the file without searching for #NAME?.
• Round-tripping repeatedly — each pass loses a little more formatting, so pick one system as the source of truth.

Frequently asked questions