To convert Excel to Google Sheets, upload the .xlsx file to Google Drive, open it, and choose File > Save as Google Sheets. Google creates a new Sheets copy and leaves your original Excel file untouched. You can also import the file from inside Google Sheets or switch on automatic conversion for future uploads.
Below are three methods, a checklist of what can go wrong, and tips to confirm the converted file works.
Method 1: Upload to Drive and Save as Google Sheets
- Open Google Drive and select New > File upload.
- Choose your Excel file and wait for it to upload.
- Double-click the file to open it in Google Sheets in preview mode.
- Select File > Save as Google Sheets.
This is the most common route. A new Google Sheets file appears next to the original, so you keep both versions.
Method 2: Import From Inside Google Sheets
- Open a blank Google Sheet.
- Select File > Import.
- Open the Upload tab and browse to your .xlsx file.
- Choose where to place the data, such as a new spreadsheet or a new sheet in the current file, then select Import data.
Importing is handy when you want the Excel data inside an existing spreadsheet instead of creating a separate file.
Method 3: Convert Automatically on Upload
If you often move files, Google Drive has a setting that converts uploaded Office files to Google formats. Open Drive settings, find the upload option for converting files, and turn it on. Be aware that this changes behavior for all future uploads, so use it only if you want every Excel file converted.
What May Not Convert Perfectly
Most values, formatting, tabs and everyday formulas come across. Some features may not. Coursera’s guide warns that you can lose items such as macros, certain links and embedded charts. Check the following after converting:
| Excel feature | What to check |
|---|---|
| Macros (VBA) | Not supported; rebuild with Google Apps Script if needed |
| Charts and images | Confirm they still display correctly |
| Advanced formulas | Look for errors or differing function names |
| Pivot tables | Review layout and calculated fields |
| Conditional formatting | Compare colors and rules with the original |
| External links | Re-link data sources if broken |
Check Your Converted File
- Compare totals between the original and the new sheet.
- Scan for error cells such as #REF! or #NAME?.
- Test a few formulas by changing an input.
- Confirm sharing settings before inviting others.
Keep the original workbook as a backup until you are satisfied. For more on understanding digital tools, see our article on digital literacy in the age of AI.
Do You Need to Convert at All?
Google Sheets can open and edit Excel files directly, so conversion is not always required. Converting makes sense when you want full Google features such as real-time collaboration and Apps Script. If you must send the file back to an Excel user, you can download it as .xlsx from the File menu.
Frequently Asked Questions
Does converting Excel to Google Sheets change my original file?
No. Saving as a Google Sheet creates a new copy and leaves the Excel file as it was.
Will my formulas still work after conversion?
Most common formulas do. Complex or Excel-specific functions may need adjusting, so test the results.
What happens to Excel macros?
Google Sheets does not run VBA macros. You would need to recreate the automation using Google Apps Script.
Can I convert several Excel files at once?
Yes. Turn on the Drive upload setting that converts files automatically, then upload them together.
Can I convert Google Sheets back to Excel?
Yes. Use File > Download > Microsoft Excel (.xlsx).
Is there a file size limit?
Google limits spreadsheet size, such as the number of cells, so very large workbooks may not convert. Check Google’s current limits if your file is big.
Conclusion
Converting Excel to Google Sheets takes a minute: upload the file to Drive, open it and save it as a Google Sheet. Import or automatic conversion works too. Always verify formulas, charts and macros afterward, keep your original as a backup, and rebuild any unsupported features so your spreadsheet works smoothly in the browser.

Lily Rose is a passionate food blogger with years of experience exploring menus, flavors, and dining trends, delivering clear, reliable insights that help readers discover great food and make confident choices.