How to Convert Excel Files to Google Sheets (What Breaks and How to Fix It)

A client sent me her invoicing tracker as an .xlsx file last month — three tabs, a pivot summary, and a macro that emailed reminders. Converting it to Google Sheets took four minutes. Recovering the pivot table and the macro took the rest of the afternoon. That gap is what this guide covers: how to convert Excel files to Google Sheets cleanly, what actually breaks in translation, and how to fix the specific errors you’ll see when it does.

The Three Ways to Convert

Method 1: Upload to Drive and convert (best for one-off files)

1. Open drive.google.com and click New → File upload, or drag the .xlsx file straight into the browser window.
2. Double-click the uploaded file. It opens in a preview.
3. Click Open with → Google Sheets. Sheets runs the conversion and opens the result.
4. Click File → Save as Google Sheets to create a native copy. The original .xlsx stays untouched in Drive.

This is the method to default to. It’s non-destructive: if the conversion mangles something, the original file is still sitting right next to the converted one.

Method 2: Import into a spreadsheet you already have

Use this when the Excel file’s data needs to land inside an existing workbook — merging a vendor’s price list into your master sheet, for example.

1. Open your existing spreadsheet and click File → Import.
2. Go to the Upload tab and drop in the .xlsx file.
3. Choose how it lands: Replace spreadsheet, Insert new sheet(s), or Replace current sheet.
4. Click Import data.

Imported lists often carry duplicate rows from repeated exports — before trusting the merged data, the three cleanup methods in how to remove duplicates in Google Sheets will sort it in a couple of minutes.

Method 3: Edit in compatibility mode without converting

Open an .xlsx directly from Drive and Sheets edits it as an Excel file — changes save back in .xlsx format. No conversion happens at all. This is the right choice when Excel users need the file back: round-trip it instead of maintaining two versions that drift apart.

What Survives and What Doesn’t

The last row is the one that costs people an afternoon. If the workbook has an .xlsm extension or a Macros tab, write down what each macro does before converting — the code doesn’t come across, and there’s no undo once you’ve saved over it. Rewriting the logic in Apps Script (Extensions → Apps Script) covers most macro use cases. If you’ve never touched Apps Script before, our guide to saving Gmail attachments to Google Drive contains a complete working script with the hourly trigger setup — copy that structure and swap in your own logic.

Functions that don’t make the trip

A small number of Excel functions have no Sheets equivalent — mostly the ones that reach into the local system, like =FILTERXML() and =WEBSERVICE(). After converting, press Ctrl + F and search for #NAME? — every broken function shows up as that error, so one search finds them all. Spill-style array formulas generally survive, since Sheets treats ranges as arrays natively.

When Conversion Goes Wrong

Dates are off by four years

Classic symptom: every date lands exactly 1,462 days too early. The file was created with the 1904 date system (old Mac versions of Excel) while Sheets assumes 1900. Fix it with a helper column: =A2+1462, copy down, then paste values over the originals.

#NAME? errors everywhere after converting

An unsupported function, or a reference to an Excel add-in Sheets can’t see. Find each one with the search above and replace it with a Sheets equivalent — most have one within a minute of looking.

The pivot table is empty or totals look wrong

Don’t debug the imported pivot; rebuild it. Click anywhere in the converted data, then Insert → Pivot table → Create, and re-add your rows, columns, and values. Rebuilding takes two minutes and is more reliable than trusting a translated one.

The file won’t convert at all

Sheets caps a spreadsheet at 10 million cells. If the workbook is bigger than that, conversion fails or truncates. Split the workbook by tab before uploading, or archive old rows into a separate file first.

Converting Back: Google Sheets to Excel

The reverse trip works the same way:

1. Open the spreadsheet in Google Sheets.
2. Click File → Download → Microsoft Excel (.xlsx).
3. Open the downloaded file in Excel and check the formula bar on any complex cells.

Three things break going this direction. =IMPORTRANGE() has no Excel equivalent — replace it with a manual copy or Power Query before exporting. =QUERY() needs to be rebuilt as a filter or Power Query step. And any Apps Script automations attached to the file simply don’t transfer. If the sheet depends on any of the three, sort that out before downloading, not after.

Which Method Should You Use?

My rule after converting dozens of client files: one-off file you’ll own from now on — Method 1, always. Merging someone else’s data into your own workbook — Method 2. Ongoing collaboration where the other side lives in Excel — don’t convert at all; use Method 3 and keep the file in .xlsx so both tools stay honest.

Frequently Asked Questions

Does converting Excel to Google Sheets break formulas?

Almost never. Standard functions, references, and named ranges convert cleanly. The exceptions are a handful of system-level functions (FILTERXML, WEBSERVICE) and anything that depended on a VBA macro. Search for #NAME? after converting to find every casualty in one pass.

Can I convert multiple Excel files at once?

Yes. Select several .xlsx files in Drive, right-click, choose Open with → Google Sheets, and each converts separately. Then save each as a Google Sheets file if you want native copies.

What happens to VBA macros?

They’re gone the moment you convert — no warning, no partial translation. Document what each macro does before converting, then rebuild the logic in Apps Script. Simple macros translate in under an hour; ones calling external APIs can take days, which is worth knowing before you promise a deadline.

Can I convert without uploading the file to Google’s servers?

No — Sheets’ converter is cloud-based, so the file has to reach Drive first. If the workbook contains sensitive financial or personal data, either keep it in Excel or remove the sensitive tabs before converting.

Does the original .xlsx get overwritten?

With Method 1, no — the converted copy is a separate file and the original stays as-is. With Method 3 (compatibility mode), yes — your edits save back into the .xlsx. That’s the main reason to choose deliberately between the two.

Sources:

• Differences between Excel and Sheets — Google Docs Editors Help