In Google Drive, choose New ▸ File upload, select the .xlsx, then open it with Google Sheets. In the opened workbook, choose File ▸ Save as Google Sheets if you want a native Sheets copy. Alternatively, in a new or existing Google Sheet, choose File ▸ Import ▸ Upload and select the Excel file. To return to Excel, in Google Sheets choose File ▸ Download ▸ Microsoft Excel (.xlsx).
On this page7
In Google Drive, choose New ▸ File upload, select the .xlsx, then open it with Google Sheets.
In the opened workbook, choose File ▸ Save as Google Sheets if you want a native Sheets copy.
Alternatively, in a new or existing Google Sheet, choose File ▸ Import ▸ Upload and select the Excel file.
Check the formulas that matter, especially anything using newer Excel functions, and check every PivotTable.
To return to Excel, in Google Sheets choose File ▸ Download ▸ Microsoft Excel (.xlsx).
Search the downloaded file for #NAME? to find Sheets-only functions that did not survive.
If the workbook depends on VBA or Power Query, do not move it — rebuild the automation in Apps Script, or keep it in 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. A conversion moves the file into another product, so check what the workbook relies on beyond cell values — macros, Power Query, external links, PivotTables and functions that exist in only one product — before you convert it. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “export google sheets to excel”. Start on a copy or a tiny sample, keep the affected sheet visible, and compare the result with the outcome you expected before you touch the real workbook. 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. The point is a data step that keeps your analysis trustworthy, but the practical win is that someone else can open the file and understand what happened without asking you.
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. After converting, compare a few totals and a sample of formulas side by side with the original. That catches most conversion losses before the file is shared.
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. For “export google sheets to excel”, treat the converted file as a new file to check, not a copy to trust blindly: compare key totals, look for error values, and confirm the macros, links and queries you depend on.
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
How do I convert an Excel file to Google Sheets?
Upload the .xlsx to Google Drive and open it, then choose File ▸ Save as Google Sheets for a native copy. Opening it directly keeps it as an .xlsx in compatibility mode.
How do I convert Google Sheets to Excel?
File ▸ Download ▸ Microsoft Excel (.xlsx). Check the result for #NAME? errors, which mark Sheets-only functions such as QUERY, ARRAYFORMULA and IMPORTRANGE.
Do macros transfer?
No. VBA is not supported in Google Sheets and Apps Script is not supported in Excel. The automation has to be rebuilt on whichever side you land.
What else gets lost?
Power Query connections, some conditional-formatting rules, chart formatting details, and PivotTable layout options. Formulas mostly survive; anything version-specific may not.
Other ways people ask this
On the way here you may have searched this as “how to export excel to google sheets” and “export google sheets to excel” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to export excel to google sheets”, “export google sheets to excel” all point at the one operation explained on this page, which is why they all lead here.