Import Excel Into 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. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. Treat “import excel into google sheets” 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. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.

In Google Sheets

Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. If you take one thing from this page on “import excel into google sheets”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people 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