How to Convert Excel (XLSX) to Google Sheets: 3 Ways
- Upload an XLSX file to Drive, then use File > Save as Google Sheets to create a separate Google Sheets copy.
- Use File > Import when the Excel data belongs in an existing spreadsheet.
- CSV is the safest option for values only; it does not keep formulas, formatting, charts, or multiple worksheets.
You have an Excel workbook and need it in Google Sheets, usually to collaborate with someone or move a workflow online. Google Sheets can open and edit XLSX files directly. To use Sheets-only features such as Apps Script or protected ranges, convert the file into a native Google Sheet.
Most workbooks convert in seconds and retain values, standard formulas, and basic formatting. The exceptions are Excel-only features such as VBA macros, external workbook links, some charts, and complex pivot tables. This guide covers three reliable conversion methods, the setting that automates future uploads, and the quickest way to diagnose conversion issues.
Method 1: Convert Excel to Google Sheets in Google Drive
This is the fastest way to create a Google Sheets copy while leaving the original Excel file unchanged in Drive.
Step 1: Upload the XLSX file
Open Google Drive, select New > File upload, and choose your XLSX file. You can also drag the file into a Drive folder.
Step 2: Open the file in Google Sheets
Double-click the uploaded workbook. If Drive opens a preview, choose Open with Google Sheets. At this stage, you can edit and collaborate on the workbook while it remains an Excel file.
Step 3: Save a native Google Sheets copy
Select File > Save as Google Sheets. Google creates a new Sheets file and keeps the XLSX original. Rename or archive the Excel file if both versions would confuse collaborators.
Method 2: Import an Excel file into an existing Google Sheet
Use import when you need the Excel data inside a spreadsheet that already exists, rather than as a separate new Google Sheet.
Step 1: Open the destination spreadsheet
In Google Sheets, open the spreadsheet that should receive the Excel data. Select File > Import, then choose the XLSX file from Drive or upload it from your computer.
Step 2: Choose the import location
For most workbooks, choose Insert new sheet(s). It adds the imported worksheets as new tabs and leaves the existing content intact. Choose Replace spreadsheet only when you deliberately want to overwrite the destination spreadsheet.
Step 3: Import and check the result
Select Import data. Before sharing the result, scan formula cells, totals, charts, and pivot tables. Removing blank rows and finding duplicate records in Excel before import can also save a second cleanup pass.
Method 3: Convert Excel to Google Sheets with CSV
CSV is the most dependable path when you only need the cell values. It is also useful for older XLS files that need a clean data-only transfer.
Step 1: Save each required worksheet as CSV
In Excel, choose File > Save As and select CSV (Comma delimited). A CSV file stores one worksheet, so repeat this for every tab you need.
Step 2: Import the CSV into Sheets
Create or open a Google Sheet, then choose File > Import > Upload. Select the CSV and choose the import location that fits your workflow.
CSV keeps plain values such as text, numbers, and dates. It does not preserve formulas, formatting, charts, data validation, or multiple sheets. Use it when clean data matters more than workbook behavior.
Convert every Excel upload automatically
If you regularly move Excel files into Google Sheets, enable automatic conversion for future uploads:
- In Google Drive, select the gear icon and choose Settings.
- Next to Convert uploads, turn on Convert uploaded files to Google Docs editor format.
New Office files you upload will then be converted automatically. Files already in Drive are not changed by this setting.
What transfers when you convert Excel to Google Sheets
Most everyday workbooks transfer well, but these limits are worth checking before you make the converted copy.
The table below separates the features that usually carry over from the ones that commonly need manual work.
| Usually transfers | May break or change |
|---|---|
| Cell values, text, numbers, and dates | VBA macros; recreate the workflow with Apps Script if needed |
| Standard formulas such as SUM, IF, VLOOKUP, and XLOOKUP | External workbook links and references |
| Basic formatting and much conditional formatting | Embedded charts and advanced chart types |
| Simple worksheet structure | Pivot tables and functions with different syntax |
How to fix formulas and formatting that break after converting
If your converted sheet lights up with errors, here’s the quick triage:
#NAME?errors — usually an Excel function Sheets doesn’t recognize, or a named range that didn’t carry over. Check the function against Sheets’ equivalent and re-enter it.- Broken pivot tables — rebuild them natively in Sheets (Insert → Pivot table); the underlying data is intact even when the pivot object isn’t.
- Dead macros — recreate the logic in Extensions → Apps Script.
If a file is large or formula-heavy, fixing it cell by cell is slow. This is where an AI coworker for spreadsheets earns its keep: Kuse for Excel reads the actual structure of your data, explains what a broken formula was trying to do, and rebuilds the working version for you — and because it runs on top of your spreadsheet, it works whether your data ends up in Excel or Sheets. For a sheet you’re rebuilding from scratch, the AI spreadsheet generator can lay out the formulas and structure from a plain-language description.
Convert Google Sheets back to Excel
To export a Google Sheet, open it and select File > Download > Microsoft Excel (.xlsx). You can also download CSV, TSV, ODS, or PDF copies. Check the downloaded file before sending it: Sheets-only formulas or formatting may need an Excel equivalent.
FAQs
Can I open XLSX with Google Sheets?
Yes. Upload the XLSX file to Google Drive and open it with Google Sheets. You can edit it while keeping the Excel format, or use File > Save as Google Sheets to create a native Sheets copy.
Do I need Excel installed to convert a file?
No. You can upload, open, import, and convert Excel files in Google Drive and Google Sheets from a web browser.
Why can't I open an XLSX file in Google Sheets?
Check whether the upload finished, whether the workbook exceeds the 10 million-cell limit, and whether the file is damaged or password-protected. Remove protection in Excel or re-save the workbook as XLSX before trying again.
My formulas broke after converting. How do I fix them?
A #NAME? error usually means Sheets does not recognise an Excel function or named range. Replace it with the Sheets equivalent. Rebuild pivot tables in Sheets and recreate VBA macros in Apps Script.
Is there a file-size limit?
Google Sheets supports up to 10 million cells per spreadsheet. For larger workbooks, remove unused rows and columns, split the file, or use a data warehouse workflow for analysis.