How to Import Excel into Google Sheets: The Complete 2026 Guide to Converting XLSX Files Without Losing Data

Learning how to import Excel into Google Sheets is one of the most useful skills any spreadsheet user can master in 2026, especially as teams increasingly mix Microsoft 365 and Google Workspace inside the same workflow. Whether you are migrating an entire department, sharing a single report with a remote collaborator, or moving an old XLSX archive to the cloud, the conversion process determines whether your formulas, charts, and conditional formatting survive the trip intact. A clean import saves hours of rebuilding; a sloppy one creates broken references that haunt you for weeks.

The good news is that Google Sheets has made enormous progress in handling native Excel files. You can now open most XLSX files directly without converting them, run VLOOKUP and XLOOKUP side by side, and even keep Excel macros readable as Apps Script equivalents. The bad news is that not every feature translates cleanly. Power Query connections, certain array formulas, and ActiveX controls still require manual rebuilding once the file lands in Drive.

This guide walks through every reliable method for moving Excel data into Google Sheets, from the one-click File menu approach to the IMPORTRANGE live-link technique used by analysts who need both files to stay synchronized. We also cover how to import CSV exports from legacy systems, how to handle very large workbooks that exceed the 10 million cell limit, and how to preserve named ranges that scripts depend on.

If you arrived here because a colleague sent you a spreadsheet you cannot open, jump to the drag-and-drop section. If you are planning a full team migration, the structured workflow further down will save you from the most common pitfalls. Either way, by the end of this article you will know exactly which method to use, what to expect, and how to fix the handful of compatibility issues that still trip people up.

Beyond the mechanics, this matters strategically. Spreadsheets are not just files; they are the operational memory of finance teams, sales pipelines, project trackers, and academic research. Moving them between platforms carelessly creates phantom errors that compound silently. A salary calculation off by a penny, a pivot table that lost its source, or a chart that points to an empty range can travel through reports and decks for months before anyone notices.

We will also address the security side. Importing into Google Sheets places the file inside Drive's permission model, which is fundamentally different from the file-system permissions Excel inherits. Understanding that shift before you click upload protects sensitive payroll data, customer lists, and contract terms from accidental oversharing. Treat every import as a small data-governance event, not just a format conversion.

Finally, this is not just for office workers. Students moving research data between lab computers, freelancers juggling multiple client systems, and accountants reconciling vendor exports all need a dependable workflow. The steps below scale from a single file you need open in five minutes to a thousand-workbook archive migrated over a weekend.

The fastest reliable way to import a single Excel file is the drag-and-drop method through Google Drive. Open drive.google.com in a browser tab, position the XLSX file from your desktop or downloads folder, and simply drag it onto the Drive window. The file uploads in its original format and remains tagged with the small green and white Excel icon, signaling that it is still an XLSX file rather than a native Google Sheet. Double-clicking opens it inside Google Sheets in compatibility mode.

Compatibility mode is useful but limited. You can edit, share, and run most formulas, but features like Smart Fill and certain pivot table options remain disabled until you convert the file. To convert, open the workbook and select File > Save as Google Sheets. Google creates a new native copy in the same Drive folder while leaving the original XLSX untouched, which is excellent insurance if anything goes wrong during conversion.

For the second method, start from an empty Google Sheet. Click File, then Import, and choose Upload from the dialog. After selecting your XLSX file, Google presents four options: create new spreadsheet, insert new sheets, replace spreadsheet, replace current sheet, or append rows to current sheet. Each behaves exactly as labeled, and choosing wisely matters when you want to add a single tab from Excel into an existing dashboard without overwriting other tabs.

Large files behave differently. Anything above roughly 20 megabytes triggers a longer upload phase and a parsing step that can take a minute or two. If your file contains many formulas, charts, or images, expect the conversion progress bar to pause briefly while Google rebuilds those elements. Do not refresh the page during this phase, because doing so sometimes corrupts the in-progress conversion and forces a restart.

If you frequently work with comparison formulas like vlookup excel users rely on for matching customer IDs across sheets, both methods preserve the syntax perfectly. VLOOKUP, INDEX, MATCH, and the newer XLOOKUP all translate without modification. SUMIFS, COUNTIFS, and IFERROR also survive intact. The translation engine has been refined over the past several years and now handles nearly all standard worksheet functions without intervention.

Mobile uploads work too. The Google Drive app on iOS and Android lets you tap the plus icon, choose Upload, and select an XLSX from your device storage. The conversion happens server-side, so even a low-powered phone can move a hefty workbook into Sheets. This is invaluable when someone emails you a budget on a Sunday and you need to make a quick edit before a Monday morning meeting.

A final tip: if you plan to keep editing the file in both Excel and Sheets, do not convert it. Leave it as an XLSX inside Drive. Sheets will edit it natively, and you can re-download the file back to Excel anytime with all your changes intact. This dual-format workflow is increasingly common in organizations that have not committed fully to one ecosystem.

Compatibility issues are the single biggest reason imports fail or frustrate users. The most common is the broken external reference, where an Excel formula points to another workbook stored locally on your computer. When the file lands in Google Sheets, those references cannot resolve and you see REF errors scattered through your sheet. The fix is either to consolidate the data into one workbook before uploading, or to convert the linked formulas to static values using Paste Special > Values.

Macros are the second large pitfall. Anything written in VBA simply does not run inside Google Sheets, period. The good news is that Apps Script, the JavaScript-based equivalent inside Sheets, can replicate almost every common macro pattern. A simple data-entry macro that loops through rows takes about 15 minutes to rewrite. A complex financial model with custom forms might take a day or more, so plan accordingly and do not assume the conversion handles this automatically.

Conditional formatting based on formulas occasionally misbehaves. Rules that use INDIRECT, OFFSET, or reference other sheets sometimes lose their target after conversion. Always spot-check your highlighted rows and color scales after import, especially in dashboards where executives rely on visual signals to spot exceptions quickly. Rebuilding a single rule takes only a moment if you catch it early.

Charts generally survive, but custom chart types like waterfall, funnel, or histogram from newer Excel versions may convert to a simpler column chart. Recreate them using the Insert Chart menu in Sheets, which now supports most of these specialty types natively. Sparklines also transfer but lose some color customization, which is a small annoyance that takes seconds to fix.

Pivot tables transfer their structure but recalculate against the underlying data in Sheets. If you used Excel's data model or external connections, those pivots may show empty or different results. You typically need to delete and recreate the pivot from scratch, which sounds painful but usually takes under five minutes since the source data is right there. Sheets pivot tables have caught up significantly in capability since 2023.

Date and number formatting can drift, particularly when the source file uses regional formats different from your Google account's locale. A European workbook with day-month-year dates may suddenly display as month-day-year inside Sheets. Adjust this via File > Settings > Locale, which forces consistent regional formatting across the entire document. Always confirm dates after import before sending the file to anyone for decisions.

Finally, watch for hidden rows and columns. Excel's hide function carries over, but grouped outlines sometimes flatten during conversion, exposing data you intended to keep collapsed. After import, scroll through every tab and recheck visibility, especially in shared sensitive documents where hidden columns may contain salary, margin, or other confidential figures you do not want surfaced accidentally.

Advanced users can automate the entire import process using Google Apps Script. Inside any Google Sheet, open Extensions > Apps Script and write a small function that uses DriveApp.getFilesByType to scan a folder for XLSX files, then converts each one with Drive.Files.copy and a MIME type parameter of application/vnd.google-apps.spreadsheet. The script can run on a timed trigger, automatically converting any new Excel file dropped into a specific Drive folder. This is invaluable for finance teams receiving daily vendor exports.

For one-off bulk migrations, the Drive interface itself supports multi-file uploads. Select up to 100 XLSX files in your file explorer and drag them all onto Drive at once. They upload in parallel, and you can then right-click each and convert to Sheets, or use a batch script to do it programmatically. For migrations involving thousands of files, the Drive API combined with a service account is the production-grade approach.

If you need to keep Excel and Sheets in continuous sync, consider third-party tools like Coupler.io, Sheetgo, or Power Automate. These services schedule periodic syncs in either direction, handle conflict resolution, and log all changes for audit purposes. They cost between 20 and 200 dollars per month depending on volume, which is justified for mission-critical reporting pipelines where manual re-uploads would create unacceptable delay or error risk.

Connected Sheets is another powerful option if your data lives in BigQuery. Rather than importing static XLSX exports repeatedly, push the underlying data to BigQuery once and use Connected Sheets to query it directly. The spreadsheet interface remains familiar while the data scales to billions of rows without hitting the 10 million cell limit. This pattern is now standard inside large enterprises that combine SQL warehouses with spreadsheet-driven analysis.

For users who prefer the look and feel of Excel but need Google's collaboration, the Microsoft Excel web add-in for Google Drive lets you open Sheets files inside Excel Online. This middle-ground workflow keeps power users productive while leveraging Sheets' real-time editing. It is not perfect, but it removes a lot of friction during gradual organizational transitions where some teams move faster than others.

Document your team's preferred workflow. The biggest waste of time is each colleague reinventing the import process. Create a one-page internal guide that specifies which method to use for which scenario, where converted files should live in Drive, and who owns the originals. This small piece of documentation pays back enormous dividends within months as your spreadsheet ecosystem grows more complex.

Finally, build a small test workbook that exercises every formula, chart, and feature your organization actually uses. Run it through your chosen import method whenever Google releases a major Sheets update or Microsoft releases a new Excel version. This regression file catches compatibility regressions early, before they ripple through hundreds of real production spreadsheets and create cleanup work that nobody enjoys.

Putting it all together, a smooth Excel to Google Sheets workflow comes down to four practical habits. First, always keep the original XLSX archived untouched in a backup folder before converting; this single discipline saves countless rollback emergencies. Second, choose the import method based on the file's purpose, not the file's source. A static archive belongs in CSV. A live dashboard belongs in IMPORTRANGE. A working document belongs in native Sheets format. Matching method to purpose prevents 90 percent of future headaches.

Third, audit your converted file the moment it opens. Spend three minutes checking the date columns, scrolling through every tab, verifying that the totals at the bottom of the file still match what they showed in Excel. This habit catches conversion drift early, when it is easy to fix, rather than late, when the file has already been shared with stakeholders making decisions on the data. Treat the first three minutes after conversion as quality control time.

Fourth, communicate with collaborators. If your team is mixed between Excel and Sheets users, decide as a group which is the canonical version and where it lives. Nothing creates more chaos than two versions of the same budget being edited simultaneously across platforms with no clear authority. A simple naming convention like prefixing the canonical file with a star or the word MASTER goes a long way toward preventing parallel-edit disasters.

For students and exam takers, practicing import workflows pays off on certifications too. The MOS Excel exam and the Google Workspace certifications both touch on cross-platform file handling, and recruiters increasingly ask about hybrid environments during interviews. Being able to confidently say you have migrated workbooks between platforms, with concrete examples, signals professional maturity that pure formula knowledge alone does not convey.

If you are managing a team migration, communicate the timeline in phases. Pilot with a single department first, gather feedback, then expand. Most organizations underestimate the human side of switching spreadsheet platforms. People develop deeply personal workflows with their favorite shortcuts, and abrupt forced migrations create resistance that lingers. A phased approach with optional training sessions converts skeptics into advocates within a quarter.

Performance optimization deserves attention as files grow. Google Sheets handles up to 10 million cells, but performance degrades well before that threshold on complex formula-heavy files. Replace volatile functions like NOW, TODAY, INDIRECT, and OFFSET wherever possible with static alternatives. Archive old months into separate sheets rather than letting one tab grow to 50,000 rows. These small disciplines keep your converted workbooks snappy for years rather than slowing to a crawl after six months of growth.

Finally, stay current. Google ships meaningful Sheets updates roughly every quarter, and many of those updates improve Excel compatibility specifically. The XLOOKUP function arrived in 2022. LAMBDA and LET landed in 2023. Smart chips and table formatting matured in 2024 and 2025. What was painful to convert two years ago may now work flawlessly, so revisit problem files periodically to see if newer Sheets features have eliminated old workarounds you put in place.