Convert Google Sheets to Excel (Download as XLSX)

Learning to convert Google Sheets to Excel is a rite of passage for anyone who collaborates across the Google–Microsoft divide. You built the budget, the content calendar, or the client report in Google Sheets — then someone asks for “the Excel version”: an auditor who only accepts .xlsx attachments, a client whose IT blocks Google Drive links, a conference portal with an Excel-only upload form. The good news: Google built a one-click File › Download › Microsoft Excel export, and for most spreadsheets the result opens in Excel flawlessly. The “google sheets to excel” download is one click — File › Download › Microsoft Excel — but the gotchas below are worth knowing.

This guide walks through the download flow on desktop and mobile, then gets into the details that matter: which formulas and features don’t transfer (Google-only functions, Apps Script, some chart types), how to handle the sharing workflow so your Excel copy doesn’t go stale, and what to check before you send the file to someone who’ll open it in desktop Excel. Whether you’re a marketer in San Francisco, a teacher in Manchester, a freelancer in Toronto, or a startup founder in Bangalore, you’ll be exporting clean Excel files in minutes.

Google Sheets to Excel: Why Download as XLSX?

Google Sheets is brilliant for collaboration — simultaneous editing, comment threads, version history, no files to email around. But the Excel format remains the lingua franca of the business world, and there are plenty of moments when a live Google Sheet link won’t do. Compliance and audit processes often require a static, timestamped file attachment. Many corporate email systems and government portals accept .xlsx uploads but block external sharing links. Some recipients simply don’t have (or won’t use) a Google account. And for archival purposes — year-end financials, signed-off reports — a frozen file beats a living document that someone might edit tomorrow.

There’s also the offline angle. A downloaded XLSX opens in desktop Excel, LibreOffice Calc, WPS Office, and Apple’s Numbers with no internet connection — useful for flights, site visits, and anywhere connectivity is unreliable. Field teams in particular (construction, agriculture, sales) often work from downloaded Excel copies while keeping the Google Sheet as the system of record back at the office.

The key mindset shift: the Google Sheet and the downloaded Excel file are two separate artifacts from the moment you download. Edits to one don’t affect the other. That sounds obvious, but it’s the source of most “which version is current?” confusion in teams. Decide up front which one is the source of truth (usually the Sheet), and treat the XLSX as a point-in-time export — like a PDF of a document. With that understanding, the download itself is the easy part.

Method 1: File › Download › Microsoft Excel (desktop)

The canonical one-click export:

1. Open your spreadsheet at sheets.google.com.
2. Go to File › Download.
3. Choose Microsoft Excel (.xlsx).
4. Your browser downloads the file — usually to Downloads. Open it in Excel to verify.

The download includes all sheets in the spreadsheet, your formatting, and formulas (converted to Excel equivalents where they exist). What it doesn’t include: your version history, comments (mostly — some transfer as notes), and anything Google-specific, covered in the “doesn’t transfer” section below.

Method 2: Export from the Sheets mobile app

On Android or iPhone, the Sheets app export is slightly hidden:

1. Open the spreadsheet in the Google Sheets app.
2. Tap the ⋮ (three-dot) menu at the top right.
3. Choose Share & export › Save as.
4. Pick Excel (.xlsx) and choose where to save it (device storage, Drive, or share it directly).

Mobile exports are identical in content to desktop downloads. This is the method to use when someone asks for “the Excel version” while you’re away from your computer — thirty seconds and it’s in their inbox.

Method 3: Download from Google Drive without opening

You don’t even need to open the spreadsheet. In Google Drive (drive.google.com):

1. Right-click the Google Sheets file.
2. Choose Download.
3. Drive automatically converts it to .xlsx — Google Sheets files download as Excel by default.

This is the fastest path when you’re grabbing several files at once: select multiple Sheets in Drive, right-click › Download, and you get a zip of XLSX files. Note that this method gives you zero preview or options — for anything important, use Method 1 and verify the result.

Formulas and features that don’t transfer

Here’s where downloads surprise people. Google Sheets and Excel overlap enormously — SUM, AVERAGE, IF, VLOOKUP, INDEX/MATCH, and hundreds more work identically — but each has exclusives:

Google-only functions that break in Excel: GOOGLEFINANCE (live market data), IMPORTHTML/IMPORTXML/IMPORTDATA (web imports), IMAGE (in-cell images via URL), GOOGLETRANSLATE, QUERY (Sheets’ SQL-like function), SPARKLINE (older Excel lacks it; newer Excel 365 has partial equivalents), and ARRAYFORMULA wrappers (Excel 365 handles dynamic arrays natively, but the syntax differs).

When Sheets downloads to XLSX, these formulas typically become static values (their last computed result) or #NAME? errors. Before sending an important file, search for these functions (Ctrl/Cmd+F for “GOOGLE”, “IMPORT”, “QUERY”) and decide: replace with Excel-native equivalents, or freeze as values deliberately.

Other things that don’t fully transfer: Google Apps Script (bound scripts stay in the Sheet; Excel gets nothing — rebuild as VBA/macros if needed), slicers (may simplify), data validation with custom formulas (usually OK, occasionally simplified), protected ranges (permissions don’t map to Excel’s sheet protection), and connected Sheets / BigQuery data sources (the downloaded file keeps the last data snapshot, not the live connection).

The sharing workflow: keeping your Excel copy fresh

The moment you download, you have two versions of the truth: the living Google Sheet and the frozen XLSX. Teams get burned when nobody knows which is current. Pick a convention and stick to it:

Convention A — Sheet is the source of truth. All edits happen in Google Sheets; the XLSX is a point-in-time export for external parties. Name downloads with dates (budget-2026-10-08.xlsx) so staleness is visible, and re-download fresh copies rather than editing old ones.

Convention B — Excel is the deliverable. The Sheet was a drafting tool; once exported, the XLSX becomes the working document (common for client handovers). In this case, stop editing the Sheet to avoid divergent versions — or delete/archive it.

For recurring exports (weekly reports to a client who only takes Excel), consider automating: Google Apps Script can email an XLSX copy on a schedule, and third-party connectors can push Sheet data into Excel-friendly formats. But for most people, the honest answer is a calendar reminder: “download fresh XLSX every Monday.”

Troubleshooting Sheets-to-Excel downloads

Download button does nothing. Check your browser’s pop-up blocker and download permissions — Sheets downloads can be silently blocked. Try a different browser to isolate the issue.

#NAME? errors everywhere in Excel. Google-only functions (see the list above). Replace with Excel equivalents or freeze as values before downloading.

Charts look different in Excel. Rebuild critical charts natively in Excel if presentation matters; Sheets’ chart engine and Excel’s render some types differently.

File is huge. Sheets with tens of thousands of rows and heavy formatting can produce multi-MB XLSX files. Trim unused columns/rows (select and delete, don’t just clear) before downloading.

Dates shifted after download. Timezone/locale interpretation differences. Set explicit date formats in Sheets before downloading, or verify in Excel immediately.

Collaborators keep editing the Sheet after I downloaded. That’s the two-versions problem — adopt Convention A or B above, and communicate it.

Need the reverse trip? Our CSV to Google Sheets guide covers importing in the other direction.

Weird export behavior we didn’t cover? join the discussion in our community forum — describe the Sheet’s features and what the XLSX looks like, and we’ll help you sort it.

Automating Sheets-to-Excel Exports

Manually downloading the same report every week gets old fast. Here are three automation levels, from no-code to full-code.

Level 1: Scheduled email via Apps Script (no code writing)

Google Apps Script can export any Sheet as XLSX and email it on a schedule. The pattern: a script function fetches the spreadsheet’s export URL (https://docs.google.com/spreadsheets/d/ID/export?format=xlsx), attaches it to an email, and a time-driven trigger runs it weekly. Dozens of copy-paste templates for this exist — search for “apps script email sheet as excel” and you’ll have it running in fifteen minutes with zero programming background.

Level 2: Drive-folder sync

For teams, a shared Drive folder plus a recurring calendar reminder (“export fresh XLSX every Monday 9 AM”) is embarrassingly effective. Better: a simple Apps Script that saves the XLSX export into a designated Drive folder on schedule, overwriting the previous version — now the “current Excel copy” is always exactly where everyone expects it, no human in the loop.

Level 3: API-driven pipelines

Developers can pull Sheet data via the Google Sheets API and generate XLSX files programmatically (Python’s openpyxl, Node’s exceljs), on any schedule, with full control over formatting. This is the right level when the export needs transformation — filtering rows, reformatting, combining multiple Sheets — that a plain download can’t do. Our CSV to Excel with Python guide covers the XLSX-writing side of this pipeline.

Start at the lowest level that solves your problem. Most weekly-report pain is fixed by Level 1; reserve Level 3 for genuinely complex needs.

When to Stay in Google Sheets Instead

Here’s the contrarian take this guide owes you: sometimes the right move is not downloading. If the requester just needs to view the data, a view-only Sheets link beats an XLSX attachment — it’s always current, needs no email round-trips, and works on any device. If they need to collaborate, the live Sheet wins outright: comments, suggestions, and version history don’t survive the download.

Download when the situation genuinely demands a file: compliance archives, offline access, upload portals, recipients without Google accounts, or handoffs where the document must be frozen in time. For everything else, consider whether “here’s the link” serves everyone better than “here’s the file.” The best Excel export is often the one you never needed to make — and when you do need it, the methods above have you covered in under a minute.

Sheets to Excel for Accountants: Month-End Checklist

Month-end close is where Sheets-to-Excel downloads face their toughest audience: auditors, tax preparers, and finance systems with zero tolerance for surprises. If that’s your world, run this checklist before every export:

1. Freeze the numbers. Replace volatile formulas with values where the figure must not move: copy the P&L columns, Paste special › Values only. Auditors distrust workbooks that recalculate differently on their machine — and rightly so, since GOOGLEFINANCE and IMPORTRANGE results can shift between your download and their review.

2. Hunt the Google-only functions. Ctrl/Cmd+F for GOOGLE, IMPORT, QUERY, SPARKLINE, IMAGE. Each hit is a potential #NAME? in the auditor’s Excel. Convert to values or rebuild with Excel-native equivalents, and document what you changed.

3. Fix the dates and currencies. Set explicit number formats in Sheets before downloading — don’t rely on Excel interpreting them correctly afterward. Indian accountants: watch the lakh/crore grouping vs international thousand-separator grouping; UK/US accountants: confirm DMY vs MDY on every date column.

4. Name it like evidence. GL-2026-09-final.xlsx beats Sheet1 (1).xlsx. Include the period, the version, and keep a one-line changelog tab inside the workbook noting the export date and any manual adjustments.

5. Verify in Excel, not Sheets. Open the downloaded file in actual Excel (desktop or the free web app) and re-run your key totals. If a single figure differs from the Sheet, stop and find out why before sending — “the download changed it” is never an acceptable footnote in an audit file.

Handling Very Large Google Sheets

Google Sheets supports up to 10 million cells, and downloads of multi-hundred-thousand-row Sheets can get painful: slow exports, browser timeouts, and XLSX files that make Excel wheeze. Strategy depends on your goal:

If you need all the data: download in the quiet hours (fewer timeouts), use Chrome on a desktop (most reliable downloader), and consider splitting first — duplicate the Sheet, delete half the rows in each copy, download both. Excel’s 1,048,576-row limit per sheet is a hard ceiling; anything bigger must be split or aggregated before it can live in Excel at all.

If you need analysis, not raw rows: aggregate in Sheets first with pivot tables or QUERY, then download the summary — a 500-row summary downloads instantly and is usually what the recipient actually wanted. Attach a note explaining the raw data stays in the Sheet.

If this is recurring: stop downloading behemoths manually. A scheduled Apps Script that exports filtered/aggregated views, or a BigQuery connection for truly large datasets, replaces the monthly download wrestling match with a pipeline. Your laptop — and your patience — will thank you.

One more large-file tactic: split by purpose, not just by size. Instead of arbitrarily chopping rows, create purpose-built views — one Sheet with this year’s data, another with last year’s; one with raw transactions, another with the pivot summary. Each downloads fast, each has a clear audience, and nobody wades through a million rows to find the fifty they need. It takes a little upfront thought, but purpose-split exports are the difference between “here’s a massive file, good luck” and genuinely useful deliverables. Your recipients will notice — and thank you. As a bonus, smaller purpose-built files are far easier to version, audit, and troubleshoot than monoliths, which compounds the payoff every single month you repeat the export. Start with one report, prove the pattern works, then roll it out to the rest. Within a quarter, the “big download day” dread becomes a non-event — just another automated pipeline doing its quiet job in the background while you focus on the analysis itself, which is where your time was always supposed to go. The upfront investment is small; the compounding returns are enormous.