How to Import XLSX to Google Sheets Without Losing Data

Key Takeaways:Google Sheets converts most XLSX formatting and formulas, but VBA macros, advanced charts, and Power Query are lost entirelyAbout 85% of basic Excel formulas (SUM, VLOOKUP, IF) transfer correctly on importLarge XLSX files over 20 MB often crash the browser importer — SmoothSheet handles these server-sideA quick pre-import checklist can save hours of manual cleanup after conversion

You have an XLSX file from a colleague, a client export, or a legacy system. You need it in Google Sheets — but the last time you tried, half your formatting vanished and three formulas broke. Sound familiar?

Importing XLSX files to Google Sheets is straightforward in theory: upload, open, done. In practice, the conversion process quietly drops features that Excel supports but Sheets does not. This guide covers exactly what survives the import, what breaks, and how to handle each scenario so you do not lose data or waste time rebuilding your spreadsheet from scratch.

If you are looking for a general overview of moving Excel files to Sheets, check out our practical guide to importing Excel into Google Sheets. This article goes deeper — specifically into the XLSX format and how to preserve as much of your workbook as possible.

What Gets Lost When You Import XLSX to Google Sheets

Google Sheets handles XLSX files well for everyday spreadsheets, but it does not support every Excel feature. Understanding what converts and what does not will help you plan your import and avoid surprises.

Features That Are Lost Completely

• VBA macros: Google Sheets uses Apps Script (JavaScript-based) instead of VBA. Any macros in your XLSX file will be silently removed on import. There is no automatic conversion — you will need to rewrite them manually.
• Power Query and Power Pivot: These advanced ETL and data modeling features have no equivalent in Sheets. If your workbook depends on Power Query connections, you will lose those data pipelines entirely.
• ActiveX controls: Form buttons, dropdown menus, and other ActiveX elements built for Windows will not appear in Sheets at all.
• External data connections: Links to databases, web queries, and connections to other workbooks via file paths (like =[Budget.xlsx]Sheet1!A1) break immediately because Sheets cannot access local file systems.

Features That Partially Convert

• Charts: Simple bar, line, and pie charts usually transfer. However, advanced types like 3D pyramids, Sunburst, and Pie-of-Pie charts are either converted to static images or dropped. Custom chart formatting (specific colors, trendline styles) often resets to defaults.
• Conditional formatting: Basic rules (greater than, less than, color scales) survive. But rules using custom formulas or Excel-specific icon sets are frequently removed.
• Data validation: Simple dropdown lists transfer. Validation rules referencing other workbooks or complex named ranges silently fail, leaving cells without any input restrictions.
• Pivot tables: The data imports, but pivot tables may lose calculated fields and their cache connection to source data. You will likely need to recreate them using Sheets' pivot table feature.

Features That Transfer Well

• Cell values, text, and numbers
• Basic formatting (bold, italic, font size, cell colors, borders)
• Standard formulas (SUM, AVERAGE, VLOOKUP, IF, COUNTIF)
• Sheet names and tab structure
• Merged cells and frozen rows/columns
• Simple images embedded in cells

For a detailed comparison of what each platform supports, see our Google Sheets vs Excel breakdown.

How to Import XLSX to Google Sheets (Best Method for Each Scenario)

There is no single best method — it depends on your file size and what you need to preserve. Here are the three main approaches.

Small Files (Under 20 MB) — File > Import

For most everyday XLSX files, the built-in importer works well:

1. Open Google Sheets and go to File > Import.
2. Switch to the Upload tab and drag your XLSX file in (or click "Browse").
3. In the import dialog, choose one of these options:
   • Create new spreadsheet — safest option, keeps your existing sheets untouched
   • Insert new sheet(s) — adds the XLSX data as new tabs in your current spreadsheet
   • Replace spreadsheet — overwrites everything in the current file
4. Click Import data.

Tip: Always choose "Create new spreadsheet" first. Review the converted file before merging it into an existing workbook. This gives you a safe preview of what converted correctly.

You can also upload XLSX files directly to Google Drive and double-click to open them. Sheets will display the file in "compatibility mode" — you can then go to File > Save as Google Sheets to complete the conversion. According to Google's documentation, this method preserves the same features as File > Import.

Large Files (Over 20 MB) — SmoothSheet Server-Side Import

Here is where most people hit a wall. The browser-based importer loads your entire XLSX file into memory before processing it. With files over 20 MB — or spreadsheets with 100,000+ rows — you will often see:

• The upload spinning indefinitely
• A "file is too large" error message
• Your browser tab crashing mid-import
• Partial data import with missing rows

SmoothSheet solves this by processing your XLSX file server-side. Instead of your browser doing the heavy lifting, the file is parsed on SmoothSheet's servers and streamed directly into your Google Sheet. This means you can import XLSX files with hundreds of thousands of rows without browser crashes or timeouts — for a flat $9/month.

If your file exceeds Google Sheets' 10 million cell limit entirely, consider using our Excel to CSV Converter to extract the data first, then split it with the CSV Splitter into manageable chunks. You can also learn how to fix the "file too large" error in our dedicated troubleshooting guide.

Preserving Formulas — What Converts and What Does Not

Formula compatibility is the biggest concern for most users. Here is a realistic breakdown:

Formulas that convert reliably:

• Math: SUM, AVERAGE, MIN, MAX, ROUND, ABS
• Lookup: VLOOKUP, HLOOKUP, INDEX, MATCH
• Logic: IF, AND, OR, NOT, IFERROR
• Text: LEFT, RIGHT, MID, CONCATENATE, LEN, TRIM
• Date: TODAY, NOW, DATE, YEAR, MONTH, DAY
• Statistical: COUNT, COUNTA, COUNTIF, SUMIF

Formulas that often break:

• GETPIVOTDATA — no equivalent in Sheets
• CUBE functions — require Analysis ToolPak
• Structured table references (like Table1[@Column]) — Sheets does not support named table syntax
• Dynamic array functions unique to newer Excel versions may behave differently
• Any formula referencing external workbooks via file paths

Pro tip: Before importing, open the XLSX file in Excel and press Ctrl+` (backtick) to toggle formula view. Scan for any of the incompatible functions listed above. If you find them, document what each formula does so you can rebuild it in Sheets after import.

Formatting Preservation Checklist

Use this table as a quick reference before and after importing your XLSX file:

Troubleshooting Common XLSX Import Issues

Even with the right method, you may run into problems. Here are the most common XLSX import issues and how to fix them.

Broken Formulas Showing #NAME? or #VALUE!

This happens when your XLSX contains functions that Google Sheets does not recognize. Search your spreadsheet for #NAME? errors — each one indicates a formula that failed to convert.

Fix: Click on the cell showing the error. Read the formula in the formula bar. Look up the Sheets equivalent (for example, replace GETPIVOTDATA with a QUERY function or manual cell references). Our QUERY function guide can help you replicate complex data lookups.

Missing Data or Truncated Rows

If your imported spreadsheet seems to be missing rows at the bottom, your file likely exceeds Google Sheets' 10 million cell limit. Sheets will silently truncate the data without warning.

Fix: Check the original XLSX row count in Excel. If it exceeds what you see in Sheets, use the Google Sheets Limits Calculator to determine whether your data fits. For oversized files, SmoothSheet can split the import across multiple sheets automatically.

Garbled Text and Encoding Issues

International characters (like Turkish I, Ş, or German umlauts) sometimes display as question marks or garbage characters after import. This is almost always an encoding mismatch.

Fix: If you see garbled text, export the problematic sheet as CSV from Excel (save as "CSV UTF-8"). Then use our CSV Encoding Fixer to verify and repair the encoding before re-importing into Sheets.

Slow Performance After Import

Your XLSX imported successfully, but the Google Sheet is painfully slow to scroll, edit, or calculate. This usually happens with files containing 50,000+ rows or heavy use of volatile functions like NOW(), TODAY(), or INDIRECT().

Fix: Remove unnecessary formatting (highlight all cells, go to Format > Clear formatting on empty ranges). Delete hidden sheets and unused columns. Replace volatile functions where possible. If the file is simply too large for smooth performance, consider splitting the data across multiple sheets.

FAQ

Does Google Sheets support the XLSX format natively?

Yes. Google Sheets can open and edit XLSX files directly without converting them first. When you open an XLSX in Sheets, it runs in "compatibility mode." However, to use Sheets-specific features like real-time collaboration and Apps Script, you need to convert it by going to File > Save as Google Sheets. The conversion is where feature loss occurs.

Can I import a password-protected XLSX file into Google Sheets?

No. Google Sheets cannot open password-protected or encrypted XLSX files. You must remove the password protection in Excel first (File > Info > Protect Workbook > Encrypt with Password, then clear the password field). Save the unprotected file and then upload it to Sheets.

Will my XLSX formulas automatically update after importing to Google Sheets?

Formulas that are compatible with Sheets will recalculate automatically. However, formulas referencing external Excel workbooks will break because Sheets cannot access local file paths. You will need to replace those references with IMPORTRANGE or direct cell references within your Google Sheets environment.

What is the maximum XLSX file size Google Sheets can import?

Google allows uploads up to 100 MB for XLSX files to Google Drive, but the practical browser-based import limit is around 20-25 MB. Files larger than this often cause timeouts or crashes. The real constraint is the 10 million cell limit per spreadsheet — not file size alone. For large XLSX files, SmoothSheet's server-side import avoids browser memory issues entirely.

Import With Confidence

Importing XLSX files to Google Sheets does not have to be a gamble. Most everyday spreadsheets — with standard formulas, basic formatting, and reasonable file sizes — convert cleanly. The issues arise with advanced Excel features (macros, Power Query, complex charts) and with large files that overwhelm the browser.

Your best approach: check the formatting preservation table above before importing, use "Create new spreadsheet" to preview the conversion, and keep the original XLSX as a backup. For files that are too large for the standard importer, SmoothSheet handles the heavy lifting server-side so you do not have to watch your browser crash and burn.

Got a massive XLSX that keeps timing out? Try SmoothSheet free and import it in seconds instead of minutes.