Convert XLSX to Google Sheets
Google Sheets can import an Excel .xlsx workbook into a new file or insert its worksheets into an existing spreadsheet. A reliable conversion includes a post-import check for sheet tabs, formulas, dates, number formats, and summary totals.
Reviewed by the SheetsX team
Adds the XLSX worksheets to the current Google spreadsheet without replacing existing tabs.
A fictional Orders tab and formula-driven Summary tab are imported together.
SheetsX confirms eight live revenue formulas and every summary and regional total.
How do you convert XLSX to Google Sheets?
Open a Google Sheet, choose File > Import > Upload, select the .xlsx file, choose an import location, and click Import data. To add the Excel worksheets to the open spreadsheet without replacing existing tabs, choose Insert new sheet(s). After import, verify every worksheet, formula, date, and number format before relying on the converted file.
Watch an XLSX workbook become a verified Google Sheet
The recording imports Orders and Summary worksheets, then SheetsX checks dates, currency formats, eight revenue formulas, headline metrics, and regional revenue before writing a scoped conversion audit block.
The workbook and every person, order, product, and amount shown in the recording are fictional. The audit changes only Summary D3:E7.
“Audit the Google Sheets conversion of the fictional XLSX workbook in the Orders and Summary tabs. Do not change Orders!A1:H12 or Summary!A1:B13. Verify that Orders contains the title and note, eight order rows, dates, currency formats, and revenue formulas =F5*G5 through =F12*G12. Verify that Summary contains Total Revenue $1,172.00, Total Units 33, Order Count 8, Average Order Value $146.50, and regional revenue East $288.00, North $360.00, South $278.00, and West $246.00. In Summary!D3:E7 add a conversion audit block with headers Check and Result, then rows Rows imported | 8, Revenue formulas | 8 preserved, Total revenue | $1,172.00, and Conversion status | PASSED. Format D3:E3 with dark green fill and bold white text, use pale green fill for D4:E7, reply in English, and confirm no other cells changed.”
How to convert an XLSX file to Google Sheets
Choose the import destination carefully, keep the original Excel file as a backup, and verify the converted workbook before sharing it.
- 1
Open the destination spreadsheet
Create a new Google Sheet or open the spreadsheet that should receive the Excel worksheets. If the destination already contains data, note which tabs must remain untouched.
- 2
Upload the XLSX workbook
Choose File > Import > Upload, then select the local .xlsx file. Google Sheets reads the workbook and displays the available import locations.
- 3
Choose the correct import location
Select Insert new sheet(s) to add the Excel worksheets to the current spreadsheet. Other choices can create a new spreadsheet or replace existing content, so confirm the destination before importing.
- 4
Audit the converted workbook
Open every imported tab and check row counts, formulas, dates, currency and percentage formats, merged cells, charts, named ranges, and totals. Compare key values with the original workbook.
XLSX conversion checks that catch silent errors
Conversion is complete only after the imported workbook matches the original in both values and spreadsheet behavior.
| Use case | Formula or setting | What it does |
|---|---|---|
| Verify live formulas | =F5*G5 | Click representative calculated cells and confirm the formula remains live instead of becoming a pasted value. |
| Verify dates | 2026-08-03 | Confirm imported dates are true date values with the intended display format, not text that only looks like a date. |
| Verify currency | $1,172.00 | Check that totals are numeric, retain their currency format, and still recalculate when source values change. |
| Verify every worksheet | Orders + Summary | Make sure the expected sheet tabs, names, formulas, and cross-sheet references all survived the import. |
Use SheetsX to audit an Excel-to-Sheets conversion
A good audit prompt protects the imported ranges, lists the expected formulas and totals, and confines any visible check block to an empty range.
Install SheetsX- Import the XLSX workbook before starting the Agent recording so the Sheet remains the only visible app.
- Open a new English SheetsX Agent chat and identify every imported worksheet and protected range.
- List the exact row count, formulas, formats, headline totals, and regional totals that must be verified.
- Ask the Agent to write a small PASSED audit block only in a confirmed-empty range.
- Review the imported formulas and final audit block, then keep the original XLSX as a recovery copy.
XLSX to Google Sheets questions
Can Google Sheets open XLSX files?+
Yes. Google Drive and Google Sheets can open, edit, and save Microsoft Excel files. You can keep the file in Office format or convert it to a native Google Sheets file.
How do I import XLSX tabs into an existing Google Sheet?+
In the destination Sheet, choose File > Import > Upload, select the XLSX file, and choose Insert new sheet(s). Google Sheets adds the Excel worksheets as new tabs without replacing the existing tabs.
Does converting XLSX to Google Sheets preserve formulas?+
Many common Excel formulas transfer directly, but unsupported functions, external links, macros, data models, and advanced chart features may not. Check representative formulas and key totals after every conversion.
Will the original Excel file change?+
No. Saving or importing an Excel file as Google Sheets creates or updates a separate Google spreadsheet. Keep the original XLSX until the converted workbook has passed verification.
Why are imported dates wrong in Google Sheets?+
Dates can be interpreted differently when workbook locales or date systems differ. Confirm the destination locale, inspect the underlying date values, and apply the intended date format after import.
Can Google Sheets convert Excel macros?+
Excel VBA macros do not run in Google Sheets. Rebuild required automation with Google Apps Script and test each workflow separately before retiring the Excel version.
What should I check after an XLSX conversion?+
Check worksheet count and names, row counts, formulas, dates, number formats, data validation, conditional formatting, charts, merged cells, named ranges, external references, and important totals.