How to Convert an Excel File to Google Sheets
Moving data between Microsoft Excel and Google Sheets is one of the most common file tasks in modern work environments. Whether you're switching to a cloud-based workflow, collaborating with someone who doesn't have Excel, or simply trying to access a spreadsheet on a device without Office installed, converting an Excel file to Google Sheets is straightforward — but the results aren't always identical. Understanding how the conversion works helps you avoid surprises.
What Actually Happens During the Conversion
Google Sheets doesn't just open your Excel file — it converts it into a native Sheets format. This means your .xlsx or .xls file gets interpreted and rebuilt within Google's ecosystem. Most of the time, this works seamlessly: data, basic formulas, cell formatting, and tab structures carry over cleanly.
What doesn't always survive perfectly:
- Complex Excel-specific formulas (some have no direct Sheets equivalent)
- Macros written in VBA (Visual Basic for Applications) — Sheets uses Google Apps Script instead
- Certain chart types or advanced conditional formatting rules
- Pivot table configurations — these may need to be rebuilt
- Embedded objects like Word documents or specialty add-in content
The simpler your spreadsheet, the cleaner the conversion. A basic budget tracker or data table will come through almost perfectly. A multi-sheet financial model with nested VBA macros is a different story.
Method 1: Upload and Open in Google Drive 📂
This is the most common approach and works from any browser.
- Go to drive.google.com and sign in to your Google account
- Click New → File upload and select your Excel file (
.xlsx,.xls, or.csv) - Once uploaded, right-click the file in Drive and select Open with → Google Sheets
- Google Sheets will open a converted copy — to save it as a true Sheets file, go to File → Save as Google Sheets
Important distinction: If you skip step 4, the file stays in Excel format even though it's open in Sheets. You'll notice the .xlsx label in the title bar. Some features remain restricted until you save it as a native Sheets file.
Method 2: Change the Default Setting in Drive
If you regularly receive Excel files and always want them to open as Sheets, you can change a Drive setting once:
- In Google Drive, click the gear icon (Settings) in the top right
- Select Settings
- Under the General tab, check the box that says "Convert uploads to Google Docs editor format"
With this enabled, any Excel file you upload automatically converts to Google Sheets format — no extra steps required.
Method 3: Open Directly from Gmail or a Shared Link
If someone sends you an Excel file as an email attachment in Gmail, you can click "Open with Google Sheets" directly from the email. This creates a temporary preview. To keep a proper editable copy, use File → Save as Google Sheets from within that view.
Shared links to Excel files stored in Drive work the same way — you can open and convert them without downloading first.
What to Check After Converting
Even on a clean conversion, a quick review is worth the two minutes it takes. Look for:
| What to Check | Why It Matters |
|---|---|
| Formula results | Some functions behave differently or return errors in Sheets |
| Date formatting | Excel and Sheets handle date serials differently in edge cases |
| Conditional formatting | Rules may be simplified or dropped |
| Charts and graphs | Visual styling often shifts even when data is intact |
| Named ranges | Usually carry over, but worth confirming |
| Macros/VBA | Won't function — need to be recreated in Apps Script |
If accuracy matters — for a financial report, a shared team tracker, a data analysis — don't assume the conversion is perfect. Spot-check formulas against known values.
Working in "Excel Mode" vs. Native Sheets Mode 🔄
Google Sheets lets you edit Excel files without converting them. This is useful when you need to share the file back with someone who uses Excel, or when you need to preserve formatting that might shift during conversion.
The tradeoff: when you're editing an .xlsx file inside Sheets, certain Sheets-specific features — like some collaboration tools, Sheets-native formulas, and Google Apps Script triggers — are unavailable or limited. You're essentially working in a compatibility layer.
Converting to native Sheets format unlocks the full feature set but means the file no longer opens cleanly in Excel without re-exporting.
The Re-Export Path: Going Back to Excel
Converting to Sheets doesn't have to be permanent. If you need to send an updated version back as an Excel file:
- Go to File → Download → Microsoft Excel (.xlsx)
This re-exports the Sheets file into Excel format. Be aware that the same compatibility issues apply in reverse — any Sheets-specific features won't translate back to Excel perfectly.
Where the Variables Come In
The mechanics of converting are consistent. What varies significantly is how much the conversion matters to you — and that depends on factors specific to your situation.
A solo user tracking personal expenses will likely never notice any conversion quirks. A team migrating a business-critical Excel workbook with years of embedded formulas and macros will face real decisions about whether to rebuild functionality in Apps Script, maintain parallel versions, or restructure the file entirely.
Your file's complexity, the people who need to access it, whether they're Excel or Sheets users, and what you plan to do with the data afterward all shape what the "right" conversion approach actually looks like for your specific case.