How to Upload an Excel File to Google Sheets

Google Sheets and Microsoft Excel are the two dominant spreadsheet tools in most workflows — and moving data between them is something millions of people do every day. Whether you're switching from Excel to Sheets, sharing a file with someone who doesn't have Office, or just want to work in the browser, uploading an Excel file to Google Sheets is straightforward. But the process has a few variations worth understanding, and the results can differ depending on how complex your spreadsheet is.

What Actually Happens When You Upload an Excel File

When you upload an .xlsx or .xls file to Google Sheets, Google doesn't just display it — it converts it into a native Google Sheets format. That converted file lives in your Google Drive and behaves like any other Sheets document: it's editable, shareable, and stored in the cloud.

The original Excel file remains wherever it came from. You're not replacing it — you're creating a Sheets version of it. These two files are independent after conversion. Changes to one won't automatically update the other.

Method 1: Upload Through Google Drive 📁

This is the most common approach and works on any browser or device.

1. Go to drive.google.com and sign in to your Google account.
2. Click New (top-left), then select File upload.
3. Locate your .xlsx or .xls file and select it.
4. Once uploaded, the file will appear in Drive with an Excel icon — it's stored but not yet converted.
5. Right-click the file and choose Open with → Google Sheets.
6. Google Sheets will open the file and automatically convert it.

At this point you're viewing a converted copy. To save it permanently as a Sheets file, go to File → Save as Google Sheets. If you skip this step, the file stays in Excel format even while open in Sheets — which limits some Sheets-specific features.

Method 2: Import Directly from Inside Google Sheets

If you're already working in Sheets, you can pull in Excel data without going through Drive first.

1. Open a new or existing Google Sheet.
2. Click File → Import.
3. Choose the Upload tab and drag your Excel file in, or click to browse.
4. Google will ask how you want to import it — create a new spreadsheet, insert new sheets, or replace the current spreadsheet.
5. Select your preference and click Import data.

This method gives you more control over where the data lands. It's particularly useful when you want to merge Excel data into an existing Sheets project rather than create a standalone file.

Method 3: Open Excel Files Directly on Mobile

On Android or iOS, the Google Drive app and Google Sheets app both support opening Excel files directly.

• In the Drive app, tap the Excel file and it will open in Sheets automatically.
• In the Sheets app, tap the + icon and select Open existing to browse Drive or your device storage.

The mobile experience mirrors the desktop one, though editing very large or complex files on mobile can feel sluggish regardless of device.

What Converts Well — and What Doesn't

Most standard Excel content transfers cleanly. But the more advanced or formatting-heavy your spreadsheet, the more likely you are to see some differences.

Macros are the biggest sticking point. If your Excel file relies heavily on VBA macros for automation, those won't carry over. You'd need to recreate the logic using Google Apps Script, which uses JavaScript-based syntax rather than VBA.

File Size and Performance Considerations

Google Sheets has a cell limit of 10 million cells per spreadsheet. Most Excel files fall well under this, but very large datasets can hit this ceiling. Files with extensive formatting, many embedded images, or thousands of formula references may also open more slowly or display rendering quirks after conversion.

If you're working with a genuinely large Excel dataset — think hundreds of thousands of rows — performance in Sheets may feel noticeably different from Excel's desktop application, which handles raw computation locally rather than in a browser.

Keeping Files in Sync (or Not)

One thing many users don't immediately realize: uploaded and converted Sheets files are no longer linked to the original Excel file. There's no automatic sync. If your colleague updates the original .xlsx on their computer and emails you a new version, you'd need to upload and convert again.

For teams that need ongoing sync between Excel and Google Sheets, tools like Google Drive's desktop app (which can store .xlsx files in Drive and open them in Sheets without converting) or third-party integration services handle this differently — with trade-offs around which features remain available.

The Variables That Shape Your Experience 🔍

How smoothly this process goes depends on factors specific to your situation:

• How formula-heavy your spreadsheet is — basic spreadsheets convert almost perfectly; complex nested formulas occasionally behave differently
• Whether you use macros — if VBA automation is core to your workflow, conversion is only the first step
• File size and row count — performance differences become more noticeable at scale
• Whether ongoing sync matters — a one-time upload is simple; keeping two versions in sync requires more planning
• Who you're collaborating with — if teammates are still working in Excel, staying in .xlsx format within Sheets (without full conversion) may preserve compatibility better

The mechanics of uploading are consistent. What varies is how well the converted file fits your actual workflow once it lands in Sheets.