# Upload Excel to Google Sheets: Convert or Keep XLSX

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-04-11
- Updated: 2026-04-11
- Category: Google Sheets, Numbers and LibreOffice
- Canonical: https://www.fastbankconvert.com/blog/upload-excel-to-google-sheets

> Upload Excel to Google Sheets: convert the file or edit it as XLSX, what formatting changes, and the auto-convert setting in Drive.
To upload Excel to Google Sheets, add the XLSX file to Google Drive with New > File upload, then open it. You can convert it into a native Google Sheet, which unlocks every Sheets feature, or keep editing it as an Excel file. Convert when you will work in Sheets; keep XLSX when it must return to Excel.

## Two ways an uploaded Excel file opens in Google Sheets

An Excel file in Google Drive can be opened in two ways. It can be converted, which creates a separate Google Sheets copy beside the original XLSX. Or it can be edited in its own format, which Google calls Office Compatibility Mode. The upload step is the same; the difference is what happens when you open the file.

Google's help on [working with Office files in Google Sheets](https://support.google.com/docs/answer/6055139) describes both routes. To convert, you open the Office file in Sheets; Sheets can convert .xls, .xlsx, .xlsm, .xlt, .xltx, .xltm, .ods, .csv, .tsv, .txt and .tab. For editing without converting, the page describes Office Compatibility Mode, which works in Chrome on a computer and may ask for Google's Office Editing extension.

### Steps for the upload

1. Go to drive.google.com and open the folder you want.
2. Choose New > File upload and pick the XLSX file, or drag it into the folder.
3. Double-click the uploaded file to open it.

### Steps to convert it

1. With the file open, choose File > Save as Google Sheets.
2. A new Google Sheet with the same name opens in a new tab.
3. Work in that new copy. The XLSX stays in Drive, unchanged.

### Steps to keep it as XLSX

1. Open the file and check the File menu for Office Compatibility Mode.
2. Edit as usual. Changes are saved to the XLSX itself.
3. To get the file back to someone in Excel, download it as .xlsx.

## Should an Excel upload be converted or kept as XLSX?

Convert the upload when the file is going to live in Google Sheets: shared editing, Sheets-only functions, forms and add-ons all need a native sheet. Keep it as XLSX when the file belongs to an Excel user who will want it back, or when it relies on features Sheets does not support, such as macros.

The table below gives example situations and the route that fits each.

| Example situation | Route | Why |
| --- | --- | --- |
| You plan to keep a budget in Sheets from now on | Convert | Full Sheets features, real-time collaboration |
| Your accountant sent an XLSX to review and return | Keep XLSX | No second copy to keep in sync; it goes back as Excel |
| The workbook runs VBA macros | Keep XLSX, or stay in Excel | Converted files lose macros |
| You want to combine the data with other Sheets files | Convert | IMPORTRANGE and other Sheets functions need a native sheet |
| A one-off look at a file on a borrowed computer | Keep XLSX | Fast, nothing new to tidy up later |

If the choice is really about which program to use day to day, the comparison of [Excel Online vs Google Sheets for statement data](/blog/excel-online-vs-google-sheets) weighs the two in more depth.

Converting is not one-way. A converted sheet can be downloaded as XLSX later. Each trip, though, is a chance for formatting to drift, so pick a home for the file and keep it there.

## The Convert uploads setting in Google Drive

Google Drive has a setting that converts every uploaded Office file into Google format automatically. Google's [page on uploading files to Drive](https://support.google.com/drive/answer/2424368) names it "Convert uploads to Google Docs editor format" and says it is changed on a computer at drive.google.com/drive/settings.

Turn it on when you move a whole folder of Excel files into Sheets for good. Every upload then arrives as a native Google Sheet, with no manual step.

Leave it off if you often receive XLSX files that need to go back to their owner. With the setting on, the upload becomes a Google Sheet instead of an Excel file. When the owner later asks for "the file", you have to download it as XLSX, which is a fresh conversion rather than their original.

The setting applies to future uploads only. Files already in Drive stay as they are.

## What changes when an Excel workbook becomes a Google Sheet?

Converting keeps values, most formulas and basic formatting, but some Excel features do not come across. Google's help names three: macros are not supported, linked spreadsheets are not supported, and locked or hidden cells in protected workbooks and worksheets become viewable and editable in Sheets.

That last point deserves attention with financial files. If someone protected a workbook to hide a column of account numbers or margins, converting it exposes that column to anyone who can open the Google Sheet. Remove the sensitive data before converting, or keep the file in Excel.

Two size rules also apply. Google's page on [files you can store in Google Drive](https://support.google.com/drive/answer/37603) limits converted spreadsheets to 20 million cells or 100 MB. It also says that cells with more than 50,000 characters are removed during conversion from Excel. A long notes column can lose content with no message.

Other parts of a workbook worth a look after converting:

- Pivot tables and charts, which may look different or need rebuilding.
- Custom number formats, especially accounting formats and negative numbers in brackets.
- Conditional formatting rules with complex formulas.
- Data validation lists that point at another file.
- Fonts that Google does not offer, which are replaced.

## Checking dates and amounts after the Excel upload

Check three things in the converted sheet: dates are still real dates, amounts are still numbers, and totals match the Excel file. Unlike a CSV import, an XLSX carries its values already typed, so problems are rarer, but the spreadsheet locale still decides how dates and currency look.

A short check:

1. Click a date cell. The formula bar should show a date, not text, and the column should sort in calendar order.
2. Compare a date with the original. If the day and month show in the opposite order, confirm the value with a long format such as 3 April 2026. When the value is right, only the display follows a different locale; fix it under File > Settings, Locale.
3. Sum the amount column and compare with the same sum in Excel.
4. Click a formula cell and read the formula. A plain number where a formula used to be means it was flattened.
5. Look at negative amounts. Brackets, red text or minus signs should match the original.

For example, suppose an example workbook has 212 transactions with debits totalling 18,406.33 in Excel. After conversion, `=COUNTA(A2:A)` should still give 212 and `=SUM(C2:C)` should still give 18,406.33. A smaller count means rows did not come across, or the range in your formula stops short; a different sum with the same count points to a few amounts that turned into text. Write both figures down before you upload, so the comparison takes seconds.

The same kind of date display issue shows up in Apple's spreadsheet app; the guide to the [Numbers app date format](/blog/numbers-app-date-format) covers it there.

## Re-uploading an updated Excel file to Google Drive

When you get a newer version of an Excel file, upload it with the same name into the same folder. Google's upload help says this adds it as a new revision of the existing file, and offers "Keep both files" if you want two. The catch is that a converted copy does not update.

That catch matters. If you converted last month's XLSX into a Google Sheet and edited the Sheet, uploading the new XLSX updates the XLSX only. Your Google Sheet still holds last month's data plus your edits, and nothing merges them.

Three ways to avoid that:

- **Keep working in XLSX** when files keep arriving from an Excel user, so every new version replaces the old one.
- **Copy only the new rows** from the new XLSX into your Google Sheet, if your edits must stay.
- **Agree on one home.** Ask the sender to edit the Google Sheet directly, which removes the upload step altogether.

Drive also records the upload time as the created time, so a file can look "new" in Drive while its content is older. Check the data, not the timestamp.

## When an Excel statement file should stay off Google Drive

Keep a workbook off Google Drive when it holds data you are not allowed to store in a personal cloud account. That includes client statements under a firm policy, files with full account numbers, or anything a contract keeps on approved systems. Once uploaded, the file sits in your Drive and counts against your storage.

Before you upload, check:

- Whether your employer or client allows Google Drive for this kind of data.
- Which Google account you are signed into. A personal account and a work account look alike in the browser.
- Whether a folder you upload to is shared. A file in a shared folder is visible to everyone with access to that folder.

Some people want to avoid uploads at the source as well, and look for ways to turn statements into spreadsheets on their own computer. The guide to [converting PDF to Excel without uploading](/blog/convert-pdf-to-excel-without-uploading) covers those options and their trade-offs.

If you are making the Excel file from a PDF statement in the first place, FastBankConvert is being built for that step, with uploads encrypted in transit and trial files deleted after download. It is getting ready to open; [Get started](/get-started) to hear when trial conversions begin.