# Download Google Sheets as Excel, Formatting Intact

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-05-10
- Updated: 2026-05-10
- Category: Google Sheets, Numbers and LibreOffice
- Canonical: https://www.fastbankconvert.com/blog/download-google-sheets-as-excel

> Download Google Sheets as Excel when someone wants XLSX: what carries over, Sheets-only functions that break, and checking the file.
To download Google Sheets as Excel, open the spreadsheet and choose File, then Download, then Microsoft Excel (.xlsx). The whole workbook saves as one XLSX file with every tab. Values and most formatting carry over. Formulas that use functions only Sheets has will not calculate in Excel, so replace them or paste them as values first.

## How do you download Google Sheets as Excel from the File menu?

Downloading Google Sheets as Excel takes three clicks: File, then Download, then Microsoft Excel (.xlsx). Your browser saves an XLSX copy, named after the spreadsheet, to your downloads folder. The Google Sheets original stays where it was, unchanged, and later edits to it do not reach the downloaded file.

Google's guide to [using Excel and Sheets together](https://support.google.com/docs/answer/9331167?hl=en) lists the formats on offer: Excel, PDF, CSV, ODS and others. Excel is the one that keeps every tab, the formulas and the formatting in a single file. CSV saves only the tab you are on, and only its values.

The same guide describes a second route: sending a copy by email as an Excel file. This attaches an XLSX to a message without saving it on your computer first, which is handy when the request comes from someone outside your Google account. Google's guide gives the path as File, then Email as attachment, with Microsoft Excel chosen under Attach as.

On a phone, the Sheets app offers a similar option under its menu, often labelled Share and export, then Save as. If you cannot find it, open the sheet in a mobile browser in desktop view and use the File menu.

## Formatting to check after the Google Sheets to Excel download

Most everyday formatting survives the Google Sheets to Excel download: number formats, bold and colours, borders, column widths, merged cells and frozen rows. Features that depend on Google's service, such as comments assigned to people, linked data and add-ons, may change or drop out. Open the file in Excel and check the parts your reader will rely on.

A short list of what to look at, ordered by how often it matters for a statement or budget sheet:

- **Number formats.** Currency and decimal places usually come across. A custom format written for Sheets may display differently. [Currency formats in Google Sheets](/blog/currency-format-in-google-sheets) explains which ones are standard.
- **Conditional formatting.** Simple rules, such as red for negative amounts, normally convert. Rules built on custom formulas need a look.
- **Charts.** Common chart types convert. Check titles, colours and axis ranges.
- **Data validation.** Dropdown lists made from a range usually carry over. Check that the range still points at the right cells.
- **Filter views.** Sheets lets each person keep their own filter views. Excel has no direct equivalent, so expect at most one plain filter.
- **Protected ranges.** Sheets protection is tied to Google accounts and does not carry Google's permissions into Excel.

None of this changes the values in the cells. A formatting difference makes a file look odd. A formula difference makes it wrong, which is why the next section matters more.

## Sheets-only functions that break in the downloaded Excel file

Functions that exist only in Google Sheets cannot calculate in Excel, because Excel has no function by those names. GOOGLEFINANCE, IMPORTRANGE, IMPORTHTML, GOOGLETRANSLATE, QUERY and ARRAYFORMULA are the common ones. Find them before you download, and replace each with plain values or an Excel-compatible formula.

To find them quickly, use Edit, then Find and replace in Sheets, tick **Also search within formulas**, and search for each function name. Or press Ctrl+` (Cmd+` on a Mac) to show formulas across the sheet and scan by eye.

The table pairs each function with an Excel-safe replacement. The suggestions are examples; pick the one that fits how the reader uses the file.

| Sheets function | What it does in Sheets | Excel-safe replacement |
| --- | --- | --- |
| GOOGLEFINANCE | Pulls live prices | Paste the values as of today |
| IMPORTRANGE | Reads another Google spreadsheet | Paste the values, or copy the source tab in |
| IMPORTHTML, IMPORTXML | Reads a web page | Paste the values |
| GOOGLETRANSLATE | Translates text | Paste the translated text as values |
| QUERY | Filters and groups with a query language | A FILTER formula, a pivot table, or values |
| ARRAYFORMULA | Fills a formula down a range | The plain formula filled down each row |

To paste values, select the cells, copy, and use Edit, then Paste special, then Values only. Do it in a copy of the spreadsheet, made with File, then Make a copy, so your live version keeps its formulas.

Scripts are a separate case. Apps Script code attached to a Google spreadsheet does not run in Excel, which uses its own macro languages. Buttons and custom menus built with Apps Script will do nothing in the downloaded file. If the workbook relies on them, write down what they do so the reader can repeat the steps by hand.

Some functions exist in both programs but only in newer versions of Excel, such as UNIQUE, SORT and FILTER. They work in current Microsoft 365 and fail in older desktop versions. If you do not know which Excel the reader has, convert those columns to values too.

## Dates and money amounts in a downloaded Excel workbook

Dates and money amounts keep their values in a downloaded Excel workbook, because both programs store a date as a serial number and an amount as a plain number. What can change is how they display. The spreadsheet's locale, and the reader's own Excel settings, decide whether 03/04 reads as March 4 or April 3.

Three things to check:

1. **Date order.** If the Sheets locale is set to the United Kingdom and the reader's Excel runs in the United States, dates still hold the right value but a custom display format may read oddly. Open one date and confirm it in a long format such as "4 March 2026".
2. **Dates stored as text.** A date that was text in Sheets stays text in Excel. Sorting by date then sorts alphabetically. Fix it in Sheets before the download, not after.
3. **Amounts stored as text.** The same applies to amounts with a left alignment in Sheets. They will not sum in Excel either.

Apple Numbers users who open the XLSX on a Mac meet their own version of the date problem. [Date formats in the Numbers app](/blog/numbers-app-date-format) covers it.

Money amounts are safest as plain numbers with two decimal places and no currency symbol in the cell content. If the same data is headed for a script or an app rather than a person, a different format may suit it better. [Storing money amounts in JSON](/blog/store-money-amounts-in-json) explains why cents as whole numbers avoid rounding drift there.

## A check of the downloaded Excel file before you send it

Check a downloaded Excel file by opening it in Excel, not just in a preview, and comparing a few numbers against the Google Sheets original. Confirm every tab is present, the row count matches, key totals match to the cent, and no cell shows an error such as #NAME?. Five minutes here saves a second round of emails.

A checklist for a statement or budget workbook:

- [ ] Every tab from the Sheets file is in the workbook, in the same order.
- [ ] The last row number on each data tab matches the original.
- [ ] A SUM of the amount column matches the same SUM in Sheets.
- [ ] The opening and closing balances, if the sheet has them, match the statement.
- [ ] A search for "#" finds no error values such as #NAME?, #REF! or #VALUE!.
- [ ] Dates sort in date order, oldest to newest, not alphabetically.
- [ ] No hidden tab or hidden column holds data the reader should not see.

The last item is easy to miss. A hidden tab in Sheets downloads as a hidden sheet in Excel, and anyone can unhide it there. If the workbook was built from bank statements, remove full account numbers and any raw data tabs before you send it.

When a file goes back the other way, from Excel into Sheets, a different set of things can change. [Uploading Excel to Google Sheets](/blog/upload-excel-to-google-sheets) covers that direction.

## When is a CSV or a shared link better than an Excel download?

A CSV is better than an Excel download when the file is going into another program, such as accounting or budgeting software, that wants plain rows. A shared link is better when the reader only needs to look, or when the data will keep changing. Choose XLSX when a person will work on the file in Excel.

Each format suits a different reader:

- **CSV.** One tab, values only, no formatting. Most import screens accept it. Download each tab separately with File, then Download, then Comma-separated values.
- **Shared link.** No copy to fall out of date. Set the role to Viewer or Commenter. The reader needs a browser, and a Google account if you keep access restricted.
- **PDF.** A fixed snapshot for a record or a signature, not for further work.
- **XLSX.** Formulas, formatting and several tabs in one file, for someone who will sort, filter and add to it.

The size of the sheet matters too. Google's guide notes that a dataset over 20 million cells should stay in Excel rather than Sheets, so a file that large was probably built elsewhere to begin with.

If the data started life as a PDF bank statement, you may not need Sheets in the middle at all. FastBankConvert is being built to turn a statement PDF straight into an Excel, CSV or JSON file, and it is getting ready to open. You can join at [Get started](/get-started).