To open an Excel workbook in Google Sheets, upload the .xlsx or .xls file to Google Drive, then right-click it and choose Open with > Google Sheets. You can edit it in its Excel format or convert it to a native Google Sheets file; the original Excel file stays available in Drive unless you delete it.
What You’ll Need
- A Google account with access to Google Drive and Google Sheets. You will need to sign in to upload and save a workbook.
- The Excel workbook on your computer, or a copy already stored in Google Drive. Common formats include .xlsx and .xls.
- An internet connection and a current web browser. These instructions are for Google Sheets in a browser, rather than the Google Sheets mobile app.
You do not need Microsoft Excel installed to open the file in Sheets. If the workbook contains sensitive or work-related information, make sure your organization allows you to upload it to your Google account before proceeding.
Step-by-Step
- Sign in to Google Drive. In your browser, go to drive.google.com and sign in to the Google account where you want the workbook stored. Check the account icon if you use more than one Google account; uploading to the wrong account can make the file seem to disappear later. You can also start at sheets.google.com, but Drive is the most direct route when the Excel file is on your computer.
- Upload the Excel workbook if it is on your computer. In Drive, select New > File upload. Browse to the workbook, select it, and choose Open in the computer’s file picker. Keep the Drive tab open while the upload runs. Wait for the upload notification to report completion before trying to open the file. If the workbook is already in Drive, skip this step and locate it in the folder where it is stored.
- Locate the uploaded file. Look for the workbook in the Drive folder you were viewing when you uploaded it, or use the search box at the top of Drive to search by its filename. Excel files usually retain their Excel extension, such as .xlsx. If you are unsure which result is the new upload, check the filename and the modified date before opening it.
- Open it with Google Sheets. Right-click the file in Drive and select Open with > Google Sheets. If you are using a trackpad or a device without a right mouse button, use the equivalent secondary-click gesture. Drive opens the workbook in the Sheets editor in a new tab or window. Depending on your browser settings, you may need to allow pop-ups or switch to the tab that opened.
- Choose whether to keep Excel format or convert. For supported Office files, Sheets can let you edit the workbook while keeping it in Excel format. The filename and file type in Drive help you identify the file you opened. If you want a separate, native Google Sheets copy, choose File > Save as Google Sheets in the editor. This creates a converted Sheets file; the uploaded Excel file remains in Drive as a separate item. Conversion is useful when you plan to work mainly in Sheets or collaborate with people who use Google Sheets.
- Check the workbook before making changes. Review the tabs at the bottom, the key formulas, number formats, charts, and any important conditional formatting. Look at a few representative rows and columns rather than assuming every detail carried over exactly. If you see a warning about unsupported content, read it before editing. Features such as some Excel-specific charts, macros, or complex formatting may not behave the same way in Sheets.
- Make a small change and confirm it saves. If you are comfortable editing, try a harmless change such as adjusting a cell’s display or entering a note in a copy. Sheets normally saves changes automatically, but wait for the save status to finish before closing the tab. For a workbook that must remain in Excel format, verify that you are editing the Office file rather than a converted copy, and reopen the file in Drive if you need to confirm which version was changed.
- Share the correct version if needed. Use the Share button in Sheets to give other people access to the file you intend them to use. A converted Google Sheets file and the original Excel upload are separate files, so sharing one does not automatically share the other. Check the filename and file type before copying a link, and set access only to the people who should be able to view or edit it.
There is another route if you already have a blank spreadsheet open: in Google Sheets, select File > Import, then use the Upload tab to choose the Excel workbook. Follow the import prompts and select the option that fits your goal, such as creating a new spreadsheet or adding the workbook’s sheets to an existing spreadsheet. Review the selected destination carefully, because replacing a spreadsheet or sheet can overwrite existing content. This route is handy when you want the workbook’s data brought into a particular Sheets file rather than simply opened from Drive.
Common Mistakes
- Opening a preview instead of the editor. A single click on a file may show a preview. Use the file’s right-click menu and choose Open with > Google Sheets to open the editable version.
- Assuming opening always converts the file. Opening an Excel workbook in Sheets does not necessarily turn it into a native Google Sheets file. Use File > Save as Google Sheets if you specifically want a converted copy, and remember that the original and converted files are distinct.
- Overwriting the wrong spreadsheet during import. The import process may offer choices that replace existing content. Read the destination and import option before confirming, and make a copy of an important destination file first.
- Expecting Excel macros to run. VBA macros in an .xlsm workbook do not run in Google Sheets. Converting a workbook does not translate VBA into Google Apps Script, so macro-based tasks need a different solution.
- Assuming every formula and layout will be identical. Many common formulas and formats transfer, but Excel and Sheets do not support every feature in the same way. Validate the results if the workbook relies on specialized functions, external connections, elaborate charts, or complex print layouts.
Tips
- Keep a clean original. If the workbook matters, keep the uploaded Excel file unchanged and convert a copy. This gives you a reference if formatting or a feature changes during conversion.
- Use clear filenames. After conversion, distinguish the files with names such as Project budget – Excel original and Project budget – Google Sheets. Avoid editing one version while sending a link to the other.
- Check sharing permissions separately. Drive permissions apply to each file. If collaborators need both the original and the converted file, share each one deliberately rather than assuming permissions carry across.
- Review critical values against Excel. For business, reporting, or operational workbooks, compare important totals and a few formulas with the source. Pay attention to dates, decimal places, currency symbols, merged cells, and filters, which can be easy to overlook.
- Use the import route for a destination spreadsheet. File > Import is often more convenient when you want to insert Excel tabs into an existing Google Sheets workbook. Choose the import option intentionally and confirm the destination before you proceed.
- Know that the browser menus are the relevant controls. These steps use Google Sheets on the web, so Excel desktop ribbon instructions do not apply. The menus may look a little different across browser window sizes, but the Drive upload and Sheets File menu paths remain the key actions.
Troubleshooting
The file does not appear in Drive. Check the upload notification for an error, then confirm that you are looking in the same folder and signed in to the same Google account used for the upload. Search Drive by the full or partial filename. If the upload did not finish, try again and keep the browser tab open until it completes. If your organization restricts uploads, contact its administrator rather than moving confidential files to a personal account.
Open with Google Sheets is missing. Confirm that you are right-clicking the Excel file itself, not a shortcut, folder, or preview. Refresh Drive after the upload completes. If the menu still does not show the option, open sheets.google.com in another tab and use File > Import > Upload to select the workbook. You can also check whether the file is a supported Excel format and whether your account has permission to edit it.
The workbook opens read-only or you cannot edit it. The file owner may have given you view-only access, or the workbook may have protection or restrictions that prevent editing. Check the access level shown in Drive and ask the owner for edit permission if appropriate. If you own the file, make sure you are signed into the account that owns it and try opening the correct copy. A preview is not the same as the editable Sheets view.
Formatting, charts, or formulas look different. Do not assume the converted version is an exact replica. Compare the affected area with the original Excel workbook, and check whether the feature is supported in Sheets. If the exact Excel layout or behavior is essential, keep the workbook in Excel format and edit it in Microsoft Excel. If you must use Sheets, consider simplifying unsupported elements in a separate copy, then verify key totals and results before sharing.
The workbook seems to have disappeared after conversion. Conversion normally creates a new Google Sheets file rather than replacing the uploaded Excel file. Search Drive for both filenames and sort or inspect the results by modified date. Open each item and check its file type. If you used an import option that replaced content, look for another copy or use Drive’s file history or trash only if appropriate; do not delete either version until you have confirmed which one contains the work you need.
The file will not upload or open. Check your connection, refresh Drive, and try a smaller or newly saved copy of the workbook. A damaged, password-protected, or unusually complex file may not import successfully. If Excel is available, open the source there, save a fresh copy in a standard .xlsx format if suitable, and upload that copy. Do not remove password protection or change security settings on a file unless you are authorized to do so.
Frequently Asked Questions
Can I open an Excel file in Google Sheets without converting it?
Yes. Open it from Drive with Open with > Google Sheets. For supported Office files, you can edit while retaining the Excel file format. Choose File > Save as Google Sheets only when you want a separate native Sheets copy.
Will Google Sheets change my original Excel file?
Uploading creates a file in Drive, separate from the copy on your computer. When editing an Office file in Sheets, changes can be saved to that Excel-format file. Converting with Save as Google Sheets creates another file. Keep a backup if you need to preserve an unchanged source.
Can I open an Excel file on a phone?
You can use the Google Sheets or Drive app to view and work with compatible files, but the exact menus differ from the browser steps here. For the clearest control over import choices and file versions, use Google Drive and Sheets in a desktop browser.
Do Excel macros work in Google Sheets?
No. Excel VBA macros do not run in Sheets, and conversion does not automatically turn them into Google Apps Script. If macros are essential, use Excel or arrange for the automation to be rewritten and checked for Sheets.
Can I open an Excel file already saved in Google Drive?
Yes. Find it in Drive, right-click it, and choose Open with > Google Sheets. You do not need to download and upload it again if the file is already in the Drive account you are using.
Which method should I choose: Drive or File > Import?
Use Drive’s Open with option to open a workbook as a file and decide whether to keep its Excel format or convert it. Use File > Import when you want to bring its sheets into a new or existing Google Sheets spreadsheet. Check the import destination so you do not replace content accidentally.
Related
- Keep 0 in Front of a Number in Excel Without Losing It
- Excel Share Mode: How to Keep Your Workbook Shared
- Excel Insert Row Shortcut: Steps for Windows and Mac
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Flip an Image in Excel: Windows, Mac, and WebTo flip a picture in Excel, select it, open the Picture Format tab, choose Rotate in the Arrange…
- Excel Not Responding? Troubleshoot Common Causes and FixesIf Excel says “Not Responding,” wait briefly first, especially if you opened a large workbook or started a…
- Google Sheets Merge Cells Shortcut and Other MethodsGoogle Sheets has no dedicated default keyboard shortcut that merges cells directly. In a browser, press Alt+/ on…
- Making a Template in Word: Steps, Styles, and SetupTo make a template in Microsoft Word for Microsoft 365 on Windows, create or open a document with…
- Excel Group Rows: How to Add and Use the Drop-DownsTo group rows in Excel for Microsoft 365 on Windows, select the rows using their row numbers, then…
- Ctrl+E in Excel: What the Shortcut Does and How to Use ItIn Excel for Microsoft 365 on Windows, Ctrl+E runs Flash Fill. Flash Fill recognizes a pattern in your…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.