How to Upload an Excel File to Google Sheets

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. Decide first whether you need a one-time copy or two files that stay in step. A converted file is a separate copy; later edits in one product do not appear in the other. For “upload an excel file to google sheets”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected sheet change, and only then apply the same setup to the full sheet. 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 is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.

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. Search the converted file for error values such as #NAME? or #REF! straight after the move; they usually mark a function or link that did not transfer.

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. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. For “upload an excel file to google sheets”, 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