Knowing how to convert Excel to Google Sheets saves time when you want to share a workbook, edit it with a team or work from any device. The core steps are simple: upload the Excel file to Google Drive, open it with Google Sheets, then choose File and Save as Google Sheets.
This guide walks through three methods, explains what to check after converting, and covers the limits that catch people out, such as macros and password-protected files.
How to Convert Excel to Google Sheets: Quick Answer
- Go to Google Drive and upload your .xlsx or .xls file.
- Double-click the file to open a preview.
- Click Open with Google Sheets at the top.
- In Sheets, click File, then Save as Google Sheets.
The last step creates a new Google Sheets copy and leaves your Excel file unchanged. You will see both files in Drive, and the new Sheet no longer shows the .XLSX badge.
Convert, Import or Edit in Place?
Google gives you more than one way to work with Excel files, and the right choice depends on what you need next.
| Option | What happens | Best for |
|---|---|---|
| Convert to Sheets | Creates a separate Google Sheets copy; the Excel file stays as it was | Ongoing teamwork in Sheets, add-ons and Apps Script |
| Import data | Brings Excel data into a new or existing Sheets file | Adding one workbook’s data to a spreadsheet you already use |
| Edit in place | Opens the Excel file in Sheets and saves changes to the original Excel file | Quick edits when others still use Excel |
Editing in place keeps the file in Excel format, but some Excel features are not displayed or editable that way. If you want add-ons, Apps Script, protected ranges or translation tools, convert the file to a Google Sheet instead. Google’s guidance is to convert when you need to collaborate in real time and your dataset is 20 million cells or fewer. You can read the full best practices for using Excel and Sheets together in Google’s help centre.
Method 1: Convert an Excel File From Google Drive
This is the most common method, and it works for a single file.
- Upload the file. In Google Drive, click New, then File upload, and choose your Excel file.
- Open the preview. Double-click the uploaded file. If you use Chrome and the file will not open as expected, check that the old Office Editing extension is not installed.
- Open it in Sheets. Click Open with Google Sheets at the top. The file opens in Sheets with a green .XLSX badge, which shows you are still editing an Excel-format file.
- Save as a Sheet. Click File, then Save as Google Sheets. A new copy opens without the badge.
- Tidy up. Keep the Excel file as a backup, or rename it to something like [Archived] Sales report so you do not confuse the two.
Method 2: Import Excel Data Into a Google Sheet
Use this method when you want the data inside an existing spreadsheet, or when you only need part of a workbook.
- Open Google Sheets and create a new spreadsheet, or open an existing one.
- Click File, then Import.
- Upload or choose the Excel file and click Select.
- Pick an import option: Create new spreadsheet, Insert new sheet(s) or Replace spreadsheet.
- Click Import data. If prompted, click Open now.
Your Excel file is not changed, even when you edit the Sheets file later. Note that you cannot use the options to replace the current sheet, append to the current sheet or replace data at a selected cell when importing an Excel file.
Method 3: Auto-Convert Future Uploads
If you move files from Excel to Sheets often, you can have Drive convert them for you.
- Open Google Drive and click the Settings icon, then Settings.
- Find the Convert uploads option.
- Turn on Convert uploaded files to Google Docs editor format.
From then on, new Excel uploads become Sheets files automatically. Files you uploaded before you changed the setting are not converted. Excel tables are imported as Sheets tables so your data structures stay intact, and Excel pivot tables can also be imported.
Auto-convert is handy for teams, but it can surprise you if you upload an Excel file only to store or send it. Turn the setting off again if you want files to stay in their original format.
Which Excel File Types Can Be Converted?
Google can convert the common spreadsheet formats, including .xlsx, .xlsm, .xls (newer than Office 95), .xlt, .xltx and .xltm. It can also handle .ods, .csv, .tsv and plain text files. For a refresher on how Excel files are built, see our guide to creating and styling Excel files in four steps.
What to Check After Converting
Excel and Sheets are close cousins, not twins. Spend a few minutes reviewing the new file before you share it.
- Formulas. Scan for error values and test a few key calculations against the original workbook.
- Formatting. Check number formats, dates, column widths and fonts.
- Charts. Confirm that each chart still shows the right data and looks readable.
- Pivot tables and tables. Make sure the structure came across and refresh any summary figures.
- Named ranges. Some named range types are not supported, such as tables used as named ranges and lists of ranges.
- Data validation and conditional formatting. Test drop-down lists and rules on a few sample cells.
- Links to other workbooks. Check any links that pointed to other Excel files, since they may need to be rebuilt.
Limits to Know Before You Convert
Macros do not run in Sheets
Google Sheets does not run VBA macros. If your workbook relies on them, Google offers a Macro Converter that translates VBA into Apps Script. It does not convert everything, though. Some triggers, UserForms and certain named ranges need to be rebuilt by hand, and the details are in Google’s guide to fixing common macro conversion issues. Even a converted script is worth testing carefully on a copy.
Password-protected files
Google Docs, Sheets and Slides do not support password-protected files, so these open in a viewer only. Remove the password in Excel, save a copy, and convert that copy.
Very large or unusual workbooks
Stay in Excel if your dataset is larger than 20 million cells, if you use the Hyperion add-on, or if you rely on rare chart types such as 3D pyramid or pie-of-pie charts. For those cases, editing in place or keeping Excel as the main tool can work better.
The copy does not sync back
After you convert, the Sheets file and the Excel file are separate. Changes in one do not update the other, so decide which file is the master and archive the other.
How to Convert Google Sheets Back to Excel
You can move in the other direction whenever you need to.
- Open the Google Sheet.
- Click File, then Download.
- Choose Microsoft Excel (.xlsx).
You can also send a copy by email as an Excel attachment from the File menu. The downloaded file is separate from the original Sheet, so later edits will not sync.
Troubleshooting Common Problems
- The file opens in a preview but not in Sheets. Click Open with Google Sheets at the top of the preview.
- The file still shows the .XLSX badge. You are editing in Office-compatible mode. Click File, then Save as Google Sheets to create a true Sheets file.
- Some features are missing. Features that Sheets cannot display may still be preserved in the Excel file. Convert the file only after you are sure you do not need them.
- Changes will not save to the Excel file. Refresh the page, reopen the document, or consider converting a very large file to Sheets.
- Numbers or dates look wrong. Check the cell format and the spreadsheet locale in Sheets, then reformat the columns.
For more practical tech guides, browse the Technology section of the site.
Tips for Teams Moving From Excel to Sheets
- Convert a copy first. Keep the original Excel file until the Sheets version has been checked.
- Name the files clearly. Archive the old file so nobody edits the wrong version.
- Agree a single master. Decide whether Excel or Sheets holds the live data.
- Test shared edits. Open the Sheet with a colleague and confirm that permissions and comments work as expected.
- Plan for macros early. List every macro and decide whether to rebuild it, convert it or leave the process in Excel.
Frequently asked questions
Can I convert Excel to Google Sheets for free?
Yes. A free Google account includes Drive and Sheets, so you can upload an Excel file, open it with Google Sheets and save it as a Google Sheets file without paying anything. Storage limits on your Drive account still apply to uploaded files.
Does converting change my original Excel file?
No. Converting creates a separate Google Sheets copy and leaves the Excel file untouched. Changes you make in the new Sheet do not flow back to the original, so keep track of which version is the working copy.
What is the difference between converting and importing?
Converting turns the whole workbook into a new Google Sheets file. Importing brings data from an Excel file into a new or existing spreadsheet, with options to create a new spreadsheet, insert new sheets or replace the spreadsheet. Both leave the original Excel file unchanged.
Will my formulas still work after converting?
Many common formulas carry over, but Excel and Sheets are not identical. After converting, scan for error values, test key calculations against the original and rewrite any function that Sheets handles differently.
Do Excel macros work in Google Sheets?
No. Sheets does not run VBA macros. Google offers a Macro Converter that translates VBA into Apps Script, but some items, such as UserForms and certain triggers, need to be rebuilt manually.
Can I convert a password-protected Excel file?
Not directly. Google Docs, Sheets and Slides do not support password-protected files, so they open in a viewer only. Remove the password in Excel first, save a copy, then upload and convert that copy.
How do I convert a Google Sheet back to Excel?
Open the sheet, choose File, then Download, and select Microsoft Excel (.xlsx). You can also email a copy as an Excel attachment from the File menu. The download is a separate file, so later edits will not sync.
Is there a size limit for converting?
Google advises converting if your dataset is 20 million cells or fewer, and staying in Excel for larger ones. Google Sheets also has its own file limits, so very large workbooks may be better kept in Excel or split into smaller files.
Conclusion
Converting Excel to Google Sheets takes a few clicks: upload the file to Drive, open it with Google Sheets and choose Save as Google Sheets. Import data when you only need part of a workbook, and turn on auto-convert if you do this often. Always check formulas, charts and macros afterwards, and keep the original Excel file until you trust the new copy.

Sarah Wilson is a versatile writer who covers a wide range of topics, with a strong specialty in entertainment. She delivers engaging, insightful content focused on movies, celebrities, trends, and pop culture.