How do XLSX files work with Google Sheets?
XLSX is the modern Excel workbook format. Google Sheets opens it through File > Import or by uploading to Drive and choosing Open with Google Sheets. Most values, tabs, and basic formatting convert cleanly, but some Excel-only features need a workaround or a stay-in-Excel decision.
When to use it
Use XLSX when teammates still work in Excel, when a vendor sends .xlsx attachments, or when you need a round trip: edit in Sheets, export XLSX for finance or compliance tools that require Excel files.
When to skip it
Skip XLSX as the live source of truth when everyone can collaborate in a native Google Sheet instead. Avoid repeated import-export cycles if macros, Power Query, or complex Excel tables are central to the workflow.
How it works
-
1
Upload the .xlsx to Google Drive or use File > Import inside an open spreadsheet.
-
2
Choose whether to create a new spreadsheet or insert sheets into the current file.
-
3
{:"Review each tab after import"=>"check dates, currency, merged cells, and named ranges."}
-
4
Edit collaboratively in Sheets, then File > Download > Microsoft Excel (.xlsx) when you need Excel format back.
-
5
For recurring feeds, prefer a shared Google Sheet link or CSV if Excel-specific features are not required.
-
6
Document which tab is canonical so nobody edits an old downloaded copy and re-uploads stale data.
Examples in Google Sheets
Vendor price list handoff
Import a quarterly .xlsx price list, validate SKUs in a helper column, then export XLSX for the procurement team that still works offline in Excel.
Multi-tab workbook migration
Open a legacy Excel model with Assumptions, P&L, and Dashboard tabs. Rebuild broken charts in Sheets while keeping raw data tabs intact for audit.
Client deliverable in Excel format
Finish analysis in Sheets, hide internal notes, download XLSX, and email the file with instructions to enable editing in Excel if they do not use Google Workspace.
Better Sheets resources
Common mistakes
-
Assuming every Excel formula converts; some functions have no direct Sheets equivalent.
-
Losing external workbook links on import without re-pointing IMPORTRANGE or manual paths.
-
Editing a downloaded XLSX locally while others edit the live Sheet, creating two truths.
-
Expecting VBA macros to run after conversion; rewrite logic in Apps Script or drop the automation.
-
Importing huge workbooks without checking Sheets cell limits per file.
Frequently asked questions
- Can Google Sheets open .xlsx files?
- Yes. Upload to Drive and open with Google Sheets, or use File > Import from an existing spreadsheet.
- Does XLSX keep multiple tabs?
- Import usually creates one sheet per Excel tab. Very large or hidden tabs may need manual cleanup.
- Can I export back to Excel?
- Yes. File > Download > Microsoft Excel (.xlsx) exports the whole workbook from Sheets.
- What breaks on import?
- Some pivot settings, slicers, certain chart types, and Excel-only functions may need rework in Sheets.
- XLSX vs CSV for handoffs?
- XLSX preserves multiple tabs and basic formatting. CSV is one tab, plain text, but more universal.
- Can I automate XLSX import?
- Apps Script can convert Drive XLSX blobs or use Advanced Drive API. Scheduled jobs work for repeat files.
- Do pivot tables survive?
- Simple pivots often import, but complex Excel pivot models may need rebuilding with Sheets pivot tables.
- Is Google Sheets the same as Excel?
- No. Sheets excels at collaboration and web hooks. Excel leads on heavy modeling and some analytics features.
Related Tutorials
Watch how Excel XLSX and Google Sheets works
Convert Google Sheets into a REST API
Related blog posts
Guides that explain Excel XLSX and Google Sheets in more depth.
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →Extract URLs from Google Sheets
Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.
Read post →Related terms
CSV and Google Sheets
CSV (comma-separated values) is a plain-text table format Sheets opens, imports, and exports easily. Use File > Import for controlled uploads or File > Download > CSV for handoffs to other tools. Watch encoding, delimiters, and date formats because CSV does not store types the way a native sheet does.
Read guide →importing data into Sheets
Importing means pulling external data into a spreadsheet tab: from a file upload, another Google Sheet, a published CSV URL, or a function like IMPORTRANGE. The import dialog controls separator, locale, and whether new rows replace or append existing data.
Read guide →exporting data from Sheets
Exporting sends sheet data out of Google Sheets as a file or published feed. File > Download offers CSV, XLSX, PDF, and more for the active tab or workbook. You can also publish a range, share a view-only link, or script exports to Drive and email on a schedule.
Read guide →workbooks and multiple tabs
In Google Sheets a workbook is the whole spreadsheet file containing one or more tabs (sheets). Each tab has its own grid, but tabs share the file's permissions, Apps Script project, and named ranges. Smart workbook structure separates raw data, calculations, and presentation so editors know which tab to touch.
Read guide →Done reading about Excel XLSX and Google Sheets?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.