How to Convert Excel to Google Sheets (and Back)

Excel and Google Sheets both do spreadsheets — but they don't do them identically. Converting a file between the two mostly works, sometimes surprises you, and occasionally loses data. This guide covers every conversion method in each direction, what survives the trip, and how to prepare files so nothing important breaks.

Why convert either direction

Excel → Google Sheets

• Real-time collaboration — multiple people editing at once with visible cursors
• No file to email — everyone works from the same URL
• Cross-device access — any browser, no Excel installation needed
• Built-in versioning — automatic revision history with named versions
• Better sharing controls — per-user permissions, expiring access, comment-only mode

Google Sheets → Excel

• Advanced features — Power Query, Power Pivot, complex pivot tables, VBA automation
• Offline work — full functionality without an internet connection
• Larger data handling — Excel processes millions of rows better than Sheets
• Compliance requirements — some industries mandate local file storage
• Sharing with Excel-only teams — clients or partners who don't use Google Workspace

Excel → Google Sheets: 4 methods

Method 1: Upload and open in Sheets (fastest)

1. Open Google Drive (drive.google.com)
2. Drag your .xlsx file into the Drive window (or click New → File Upload)
3. Wait for the upload to complete
4. Double-click the file — it opens in Google Sheets automatically

The file is still an .xlsx at this point. Sheets edits it as an Excel file — you can save, share, and collaborate, but it stays in Excel format.

Method 2: Convert to native Google Sheets format

To get a true .gsheet file with all Sheets features (some things like QUERY only work in native format):

1. Open the uploaded .xlsx in Sheets (as in Method 1)
2. File → Save as Google Sheets
3. A new .gsheet file is created in the same folder
4. The original .xlsx remains untouched — delete or keep as backup

Method 3: File → Import (into an existing Sheet)

Useful when you want to merge Excel content into an existing Google Sheet.

1. Open the target Google Sheet
2. File → Import
3. Upload tab → drag your .xlsx
4. Choose action: Create new spreadsheet / Insert new sheet(s) / Replace spreadsheet / Replace current sheet / Append to current sheet
5. Click Import data

"Insert new sheet(s)" is the most useful — brings Excel content in as new tabs in your existing Sheet without disturbing what's there.

Method 4: Copy-paste for small blocks

For a specific range rather than a whole file:

1. Select the range in Excel, Ctrl+C
2. Switch to Google Sheets, click target cell
3. Ctrl+V (regular paste)

Formulas paste as text unless you use Paste Special. For values only: Ctrl+Shift+V. For preserving Excel formulas: often better to import the whole file, then delete what you don't need.

Google Sheets → Excel: 3 methods

Method 1: Download as Excel

1. Open your Google Sheet
2. File → Download → Microsoft Excel (.xlsx)
3. Browser saves the file to your Downloads folder
4. Open in Excel

Fastest method. Result is a standard .xlsx with charts, formulas, and formatting mostly preserved.

Method 2: Export via Google Drive

Good for downloading multiple Sheets at once:

1. In Drive, select the Google Sheet file(s)
2. Right-click → Download
3. Drive converts each to .xlsx and downloads as a ZIP if multiple

Method 3: Publish and download

Only useful for making a public snapshot available for others to download:

1. File → Share → Publish to web
2. Choose Sheet or Entire spreadsheet
3. Format: Microsoft Excel (.xlsx)
4. Publish → get a direct download URL

Recipients hitting the URL get the current snapshot. Useful for embedded "download the report" links.

What's preserved and what breaks

Formula compatibility

Functions that work in both

The core spreadsheet functions are essentially identical:

• Math: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, MOD, PRODUCT
• Logic: IF, AND, OR, NOT, IFS, IFERROR, ISNA, ISBLANK, ISNUMBER
• Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP (Sheets added it)
• Text: LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, TRIM, UPPER, LOWER, PROPER, CONCATENATE, TEXT
• Date: DATE, TODAY, NOW, YEAR, MONTH, DAY, EOMONTH, WEEKDAY, NETWORKDAYS
• Statistical: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
• Financial: PV, FV, PMT, RATE, NPER, IRR, NPV

Excel-only (may not survive Sheets conversion)

• LAMBDA and helper functions (MAP, REDUCE, BYROW, BYCOL) — Sheets added LAMBDA later but with differences
• Newer text functions (TEXTBEFORE, TEXTAFTER, TEXTSPLIT) — Sheets added these more recently
• Some Power Query and Power Pivot functions
• Legacy CSE array formulas — Sheets uses ARRAYFORMULA instead

Sheets-only (won't work in Excel)

• QUERY — Sheets' SQL-style function has no Excel equivalent
• ARRAYFORMULA — Excel uses dynamic arrays instead, syntax differs
• IMPORTRANGE, IMPORTDATA, IMPORTHTML, IMPORTXML — Excel has different import mechanics
• GOOGLETRANSLATE — no Excel equivalent
• GOOGLEFINANCE — Excel uses Stocks data type instead
• SPARKLINE — Excel has a different sparkline mechanism (not formula-based)

Macros and Apps Script — the total incompatibility

Excel uses VBA (Visual Basic for Applications). Google Sheets uses Apps Script (JavaScript-based). They're entirely different languages targeting different APIs.

What survives Excel → Sheets

VBA code is stripped during conversion. If you open an .xlsm in Sheets natively (without converting), VBA is preserved in the file but doesn't run. Any macro triggers, form buttons, or event handlers stop working.

What survives Sheets → Excel

Apps Script code is not exported with the .xlsx download. Scripts remain in the Sheet on Google's servers but don't come along.

Translating between them

Simple macros translate reasonably well. Concepts map:

• VBA Sub → Apps Script function
• VBA Range("A1").Value → Apps Script SpreadsheetApp.getActiveSheet().getRange("A1").getValue()
• VBA event handlers → Apps Script onEdit, onOpen triggers
• VBA MsgBox → Apps Script SpreadsheetApp.getUi().alert()

See the Macros & VBA guide for the VBA basics and the Google Sheets Apps Script guide for the equivalents.

Handling large files

Sheets row and cell limits

• Google Sheets: 10 million cells per spreadsheet
• Excel: 1,048,576 rows × 16,384 columns per sheet (~17 billion cells possible)

Excel files larger than 10 million cells fail to import to Sheets. If you're near the limit:

• Delete unused rows/columns before conversion
• Split into multiple Sheets by category, region, or date range
• Keep the original as Excel and use Sheets only for a summary or filtered view

Performance on large files

Google Sheets slows noticeably above 100,000 rows of formula-heavy data. Excel handles this size comfortably. If your workbook is large and formula-heavy, keep it in Excel and access from Google Drive as .xlsx if you need cross-platform access.

File size limits

• Excel .xlsx max size for upload to Drive: no strict limit, but files over 100 MB may time out
• Sheets file size for editing: no explicit MB limit, but the 10-million-cell cap effectively caps size

Editing Excel files in Sheets without converting

Since 2019, Google Sheets natively edits .xlsx files without conversion. This is often the best of both worlds.

How it works

1. Upload .xlsx to Drive
2. Open with Google Sheets (no "Save as Google Sheets" step)
3. Edit normally — all changes save back to the .xlsx
4. Download at any point as .xlsx to get the latest version

Advantages

• Collaboration on the same Excel file — real-time editing, cursors, comments
• No format conversion means no loss of Excel-specific structure
• File stays compatible with users who only have Excel
• VBA and other Excel-specific content preserved (though not runnable in Sheets)

Limitations

• Sheets-specific features (QUERY, IMPORTRANGE) unavailable — file is still .xlsx
• Some advanced Excel features have limited support in the editor
• Files must stay in .xlsx format — no way to add Apps Script

Automating conversions

Batch conversion via Apps Script

Apps Script can loop through folder contents and convert every .xlsx to .gsheet:

Batch conversion via Google Drive API

For higher volumes, the Drive API (via Python, Node, or another language) does the same operation with better error handling. Requires OAuth setup.

Third-party tools

• Zapier / Make.com — no-code automation for triggered conversions ("new file in Dropbox → upload to Drive → convert to Sheets")
• Google Workspace Marketplace add-ons — several handle bulk conversion with UI

Common pitfalls

Before you convert: a 5-point checklist

1. Does it have VBA macros? If yes, converting loses them. Decide whether to rewrite as Apps Script or keep the .xlsx and edit in Sheets natively.
2. Does it use Power Query or Power Pivot? Both are Excel-only. Converting loses the queries and data model.
3. Does it use Sheets-only functions? QUERY, ARRAYFORMULA, IMPORTRANGE won't work in Excel. Plan replacements.
4. How big is it? Over 10 million cells won't fit in Sheets. Over 100K rows may perform poorly.
5. Who needs to open it? If any recipient is Excel-only, keep as .xlsx (which Sheets edits natively).

Frequently asked questions