How to Upload an Excel File to Google Sheets

Moving spreadsheet data from Microsoft Excel to Google Sheets is one of the most common file tasks in modern workplaces — and it's more flexible than most people expect. Whether you're switching tools, collaborating with teammates who use Google Workspace, or just need cloud access to a local file, there are several ways to get it done. The right approach depends on your setup, how often you need to sync data, and what you want to happen to the file once it's in Google Drive.

What Actually Happens When You Upload an Excel File

Google Sheets can open Excel files (.xlsx and .xls formats) directly, but there's an important distinction to understand upfront: uploading a file and converting it are two different things.

• Uploading without converting keeps the file in Excel format (.xlsx) stored in Google Drive. You can open and edit it in Google Sheets, but it remains an Excel file.
• Converting to Google Sheets format transforms it into a native .gsheet file. This unlocks the full feature set of Google Sheets and removes dependency on Excel compatibility.

Neither option is universally better — it depends on whether you still need the file to work in Excel or whether you're fully moving to Google's ecosystem.

Method 1: Upload via Google Drive (Most Common)

This is the most straightforward approach and works on any browser.

1. Go to drive.google.com and sign in to your Google account.
2. Click the "+ New" button in the top-left corner, then select "File upload."
3. Browse to your Excel file on your computer and select it.
4. The file will appear in your Drive with an Excel icon — double-click it to open it in Google Sheets.

At this point, the file opens in a compatibility mode. You'll see a banner at the top indicating it's an Excel file. To convert it permanently, go to File → Save as Google Sheets. This creates a new .gsheet copy while leaving the original Excel file untouched in Drive.

Method 2: Drag and Drop Into Google Drive

If you prefer not to click through menus:

1. Open drive.google.com in your browser.
2. Simply drag the Excel file from your desktop or file explorer and drop it into the Drive window.

The file uploads automatically and behaves the same way as a manual upload. From there, the conversion option works identically.

Method 3: Import Directly from Within Google Sheets 📂

This method gives you more control over how the data lands in your spreadsheet.

1. Open a new or existing Google Sheet.
2. Go to File → Import.
3. Click the "Upload" tab and drag your Excel file in, or click to browse for it.
4. You'll be presented with import options:
   • Create new spreadsheet — opens the data as a fresh Google Sheet
   • Insert new sheet(s) — adds the Excel data as a new tab in the current document
   • Replace spreadsheet — overwrites the current sheet with the imported data
   • Replace current sheet — replaces only the active tab

This is particularly useful when you want to pull Excel data into an existing Google Sheets project, or when you're merging multiple files.

What Carries Over — and What Doesn't

Excel and Google Sheets share a lot of common ground, but compatibility isn't perfect. Understanding the gaps saves headaches later.

VBA macros are the biggest compatibility gap. If your Excel file relies heavily on macros for automation, those will not transfer. You'd need to recreate the logic using Google Apps Script, which has a different syntax and structure.

Uploading from Mobile

Google Drive's mobile app (iOS and Android) supports file uploads from your phone's local storage or connected cloud services. The process mirrors the desktop experience: tap "+", select "Upload", find your Excel file, and it will appear in your Drive. Opening it through the Google Sheets app on mobile follows the same conversion path.

One limitation: the File → Import method with its granular options is only available in the browser-based version of Google Sheets, not the mobile app.

Factors That Affect Your Experience 🔍

Several variables determine how smoothly the process goes:

• File size — Very large Excel files (thousands of rows, complex formulas) may take longer to upload and could hit Google Sheets' cell limits (currently capped at 10 million cells per spreadsheet).
• Formula complexity — Files with advanced Excel-specific functions or heavy cross-sheet references are more likely to have conversion issues.
• Formatting density — Heavily formatted files with many custom styles may look slightly different after conversion.
• Macro dependency — If automation is central to how the file works, conversion requires more than just uploading.
• Collaboration needs — If others still need to edit the file in Excel, keeping it in .xlsx format (rather than converting) maintains that compatibility.
• Frequency of updates — A one-time migration looks very different from a workflow where the Excel file gets updated regularly and needs to stay in sync with Google Sheets.

When Sharing or Syncing Is the Real Goal

If the underlying goal isn't just uploading once but keeping an Excel file regularly synchronized with Google Sheets, a simple upload won't solve that. Some workflows use Google Drive for Desktop (the sync client) to mirror a local folder to Drive automatically. Others use third-party tools or scripting to push data between the two platforms on a schedule.

The one-time upload approach works well for migrations and standalone files. Ongoing sync between live Excel files and Google Sheets is a different challenge with its own set of tradeoffs — and the right solution depends on how the file is being updated, by whom, and how often.