How to Open an Excel File in Google Sheets

Google Sheets can open Excel files directly — no conversion software required, no third-party tools needed. But the experience isn't always identical across every file, and how you access it depends on where your file lives and how you're working.

Here's what's actually happening under the hood, and what to expect depending on your setup.

What Happens When Google Sheets Opens an Excel File

Excel files use Microsoft's OOXML format — either .xlsx (the modern standard) or the older .xls format. Google Sheets can read both, but it's doing real-time translation when it opens them. It interprets the file's structure, formulas, formatting, and data, then renders it inside Google's own spreadsheet engine.

This means the file doesn't become a Google Sheet automatically — it stays in Excel format unless you explicitly convert it. You'll notice a small .xlsx badge next to the filename in the browser tab when you're working in Excel-native mode inside Sheets.

Method 1: Open Directly from Google Drive

This is the most common approach and works for most users:

1. Go to Google Drive (drive.google.com)
2. Click "+ New" → "File upload", then select your .xlsx or .xls file
3. Once uploaded, double-click the file in Drive
4. Google Sheets opens it automatically in the browser

The file opens in Excel-compatible mode. You can edit it, and changes save back to the original .xlsx format — useful if you're collaborating with someone who uses Excel.

Method 2: Open and Convert to Google Sheets Format

If you want full Google Sheets functionality — including certain collaboration features, version history depth, and Sheets-specific formulas — you can convert the file:

1. Open the file using Method 1
2. Click File → "Save as Google Sheets"

This creates a separate Google Sheets copy. Your original .xlsx file stays in Drive untouched. The two files are independent from this point — edits to one don't affect the other.

Method 3: Drag and Drop into Drive

If you have Drive open in a browser window, you can drag an Excel file directly from your desktop into the Drive interface. It uploads and appears in your file list. From there, double-click to open in Sheets.

Method 4: Open from Gmail or Email Attachments

If someone emails you an Excel file:

1. Open the email in Gmail
2. Hover over the attachment — you'll see a "Open with Google Sheets" icon (a grid icon)
3. Click it — the file opens in Sheets directly from the attachment

This opens a temporary view. To keep and edit it, use File → "Make a copy" or "Save to Drive".

Method 5: Use the Google Sheets Import Feature

For more control over how the data comes in:

1. Open a blank Google Sheet
2. Go to File → "Import"
3. Upload the file or select it from Drive
4. Choose how to handle the import: replace the spreadsheet, insert new sheets, or append data

This method is particularly useful when you're pulling data from an Excel file into an existing Sheets document rather than opening the Excel file standalone.

What Carries Over — and What Might Not 📋

Excel and Google Sheets share a lot of common ground, but they're different products built on different foundations. Here's what typically transfers cleanly versus what can behave differently:

VBA macros are the most significant compatibility gap. Google Sheets uses Google Apps Script (JavaScript-based), not VBA. If your Excel file relies on macros for automation, those won't run after opening in Sheets — they'll need to be rebuilt.

Desktop vs. Mobile: Different Access Points 📱

On Android or iOS, the Google Sheets app can open .xlsx files too:

• Tap a file in the Google Drive app to open it in Sheets
• Files shared via email can be opened with the Sheets app directly
• The same compatibility considerations apply on mobile as on desktop

The mobile experience is generally more limited for complex files — large spreadsheets with heavy formatting or many sheets may render slowly or show display inconsistencies.

The Format Decision: Keep as Excel or Convert?

This is where individual circumstances start to diverge significantly.

Staying in .xlsx format inside Sheets makes sense when:

• You're regularly exchanging the file with Excel users
• Maintaining formatting fidelity to the original is important
• You don't need deep Google Sheets-specific features

Converting to Google Sheets format makes sense when:

• The file is now primarily yours to manage
• You want full Google collaboration and history features
• You're building on top of the file with Sheets-native tools

There's no universal right answer. A finance team sharing reports with Excel-heavy stakeholders has different needs than a solo user migrating their personal budget tracker to Google's ecosystem. File complexity, collaboration requirements, and how often the file travels between platforms all factor into which approach works smoothly — and which one creates friction you'd rather avoid.