How to Link Excel and Google Sheets (Sync Data Both Ways)

Your team is split — half lives in Excel, the other half in Google Sheets. Sound familiar? Whether you're managing a gradual migration, collaborating across platforms, or simply need data flowing between both tools, knowing how to link Excel and Google Sheets is essential. The good news: you have at least five solid methods, from zero-code uploads to fully automated two-way sync. This guide walks through every option so you can pick the one that fits your workflow.

Key Takeaways:You can link Excel and Google Sheets using Drive upload, IMPORTRANGE, cloud connectors, third-party tools, or Apps Script.Over 60% of organizations now use both Excel and Google Sheets simultaneously.For large Excel files, SmoothSheet handles server-side imports up to millions of rows without browser crashes.Two-way real-time sync requires a third-party tool — no native option exists yet.

Why Link Excel and Google Sheets?

Most teams don't switch platforms overnight. Finance might depend on Excel for Power Query and complex financial models, while marketing runs dashboards in Google Sheets for real-time collaboration. Linking both tools lets you:

• Bridge hybrid teams — Excel users and Sheets users can work from the same data without manual copy-paste.
• Support gradual migration — Move workloads from Excel to Sheets at your own pace while keeping everything connected.
• Combine strengths — Use Excel's powerful desktop calculation engine for heavy lifting, then share results in Sheets for collaboration.
• Maintain a single source of truth — Avoid version chaos when the same dataset exists in two places.

If your team is weighing the full switch, our Google Sheets vs Excel comparison covers the pros and cons in detail. But if you need both right now, keep reading.

Method 1: Open Excel Files Directly in Google Sheets

The simplest way to link an Excel file to Google Sheets is to upload it to Google Drive and open it in Sheets' editing mode. No conversion required — Google Sheets can read .xlsx files natively.

How to do it

1. Open Google Drive and drag your .xlsx file into a folder (or click New > File upload).
2. Double-click the uploaded file. It opens in a Sheets-compatible viewer.
3. Edit directly — changes save back to the .xlsx format so Excel users can still open it.
4. Optionally, go to File > Save as Google Sheets to convert it into a native Google Sheets file for full feature access.

When to use this method

This works well for one-off files or quick edits. However, it's not a true "sync" — changes made in the Drive-hosted Excel file won't automatically appear in a separate Google Sheets workbook. For ongoing data flow, you'll need one of the methods below.

If your Excel files are large, the browser can struggle during upload. For detailed steps on handling big files, check our guide on how to import Excel into Google Sheets.

Method 2: Use IMPORTRANGE Between Sheets

IMPORTRANGE is Google Sheets' built-in function for pulling data from one spreadsheet into another. While it doesn't connect directly to an Excel file, you can combine it with Method 1 to create a lightweight sync pipeline.

How to do it

1. Upload your Excel file to Google Drive and convert it to Google Sheets format (File > Save as Google Sheets).
2. Copy the spreadsheet URL of the converted file.
3. In your destination Google Sheet, enter:
   =IMPORTRANGE("spreadsheet_url", "Sheet1!A1:Z1000")
4. Click Allow access when prompted. The data now flows automatically.

Limitations

• One-way only — Data flows from the source to the destination, not back.
• Requires conversion — The Excel file must be saved as Google Sheets first.
• Cell limits apply — Google Sheets' 10-million-cell limit still governs both files.

For a deep dive into syntax, permissions, and advanced tricks, see our full IMPORTRANGE guide.

Method 3: OneDrive/SharePoint + Google Drive Sync

If your organization uses both Microsoft 365 and Google Workspace, you can set up cloud-level syncing between OneDrive (or SharePoint) and Google Drive. This keeps files accessible in both ecosystems.

How to do it

1. Google Drive for Desktop — Install it on your computer and set it to mirror specific folders. Any Excel file saved to a synced folder becomes available in Drive.
2. OneDrive sync client — Similarly, OneDrive's desktop app can sync folders to your local machine, which Drive for Desktop can then pick up.
3. Admin-level connectors — Google Workspace admins can enable third-party SAML apps or use tools like Google Cloud Directory Sync to bridge SharePoint document libraries with Drive.

Pros and cons

This approach keeps files in both locations, but it syncs files, not data within cells. If someone edits the Excel version on OneDrive and another person opens the same file in Google Sheets via Drive, you can run into version conflicts. It works best when one platform is the primary editor and the other is read-only.

Method 4: Third-Party Sync Tools

When you need automated, scheduled, or two-way sync between Excel and Google Sheets, dedicated integration tools are the most reliable choice. Here are the top options:

Sheetgo

Sheetgo connects Google Sheets, Excel (via OneDrive), and CSV files into automated workflows. You create "connections" between source and destination, set a schedule, and data flows on autopilot. It supports filtering, column mapping, and merging from multiple sources.

Coupler.io

Coupler.io specializes in pulling data from apps (including Excel on OneDrive/SharePoint) into Google Sheets. It runs on a schedule (hourly, daily, or weekly) and supports transformations like column reordering before data lands in your sheet.

Zapier / Make (Integromat)

Zapier and Make are general-purpose automation platforms. You can build a "Zap" or "Scenario" that triggers when a row is added to an Excel workbook (on OneDrive) and creates a corresponding row in Google Sheets — or vice versa. This is ideal for event-driven sync (new row added, cell updated).

When to choose third-party tools

If you need bidirectional sync, scheduled refreshes, or integration with other apps (Salesforce, HubSpot, databases), these tools are worth the investment. Plans typically start at $10-25/month.

For teams dealing with large CSV exports alongside their Excel-to-Sheets workflow, SmoothSheet complements these tools nicely — it handles the heavy server-side import of big files directly into Google Sheets for just $9/month.

Method 5: Google Apps Script for Custom Sync

For developers or power users who want full control, Google Apps Script can read Excel files from Drive, parse them, and write data into Google Sheets programmatically.

Basic example

function importExcelFromDrive() {
  var file = DriveApp.getFilesByName('report.xlsx').next();
  var blob = file.getBlob();
  var resource = { title: file.getName(), mimeType: MimeType.GOOGLE_SHEETS };
  var converted = Drive.Files.insert(resource, blob, { convert: true });

  var sourceSheet = SpreadsheetApp.openById(converted.id).getSheetByName('Sheet1');
  var data = sourceSheet.getDataRange().getValues();

  var targetSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Imported');
  targetSheet.getRange(1, 1, data.length, data[0].length).setValues(data);

  // Clean up the temporary converted file
  DriveApp.getFileById(converted.id).setTrashed(true);
}

Setting up automation

1. Open your Google Sheet and go to Extensions > Apps Script.
2. Paste the script above and customize the file name and sheet names.
3. Enable the Drive API under Services (click the + icon).
4. Set a time-driven trigger to run the function hourly or daily.

When to use Apps Script

This method gives you maximum flexibility — you can transform data, filter rows, merge multiple files, and handle errors exactly the way you want. The downside is maintenance: if the Excel file structure changes, you'll need to update the script.

Comparison: Which Method Should You Use?

Here's a side-by-side look at all five methods to help you decide:

*Requires existing Microsoft 365 and Google Workspace subscriptions.

If you're regularly importing large Excel files or CSV exports as part of your sync workflow, SmoothSheet can handle files with millions of rows via server-side processing — no browser freezes, no timeouts. It's a natural companion to any of these methods when file size becomes the bottleneck.

Tips for a Smooth Excel-to-Sheets Workflow

• Check compatibility first — Excel features like VBA macros, Power Query, and ActiveX controls don't work in Google Sheets. Review what you'll lose before syncing.
• Watch for formula breakage — Functions like GETPIVOTDATA or formulas referencing local file paths (=[Budget.xlsx]Sheet1!A1) will break after import.
• Mind the cell limit — Google Sheets caps at 10 million cells per workbook. If your Excel file is larger, use SmoothSheet's Excel to CSV converter to split and import in manageable chunks.
• Set one source of truth — Decide which platform holds the master copy. Bidirectional sync sounds great, but it creates conflict resolution headaches if two people edit the same cell simultaneously.

Frequently Asked Questions

Can I link an Excel file to Google Sheets without converting it?

Yes. Upload the .xlsx file to Google Drive and open it directly — Google Sheets can edit Excel files in compatibility mode without converting. However, for features like IMPORTRANGE or Apps Script integration, you'll need to save it as a native Google Sheets file first.

Is there a way to sync Excel and Google Sheets in real time?

There's no built-in real-time sync between the two platforms. The closest options are third-party tools like Sheetgo or Zapier, which can sync on a schedule (every 15 minutes to hourly). IMPORTRANGE provides near-real-time sync, but only between two Google Sheets files.

What happens to Excel macros when I open the file in Google Sheets?

VBA macros do not run in Google Sheets. They're silently ignored when you open the file. If you need similar automation, you'll have to rebuild the logic using Google Apps Script, which is JavaScript-based rather than VBA.

How do I handle large Excel files that crash Google Sheets during import?

Google Sheets has a 10-million-cell limit and struggles with files over 100,000 rows. For large files, you can split them before importing using a tool like the Excel to CSV converter, or use a Google Sheets add-on like SmoothSheet that processes imports server-side without stressing your browser.

Conclusion

Linking Excel and Google Sheets doesn't have to be complicated. For quick access, upload your Excel file to Google Drive and edit it directly. For live data flow between spreadsheets, IMPORTRANGE does the job for free. And when you need scheduled, two-way sync, tools like Sheetgo or Zapier fill the gap.

The key is choosing the method that matches your team's technical comfort and how frequently data needs to move. Start simple — you can always layer in automation later as your needs grow.