Excel Workbook in Google Sheets: How to Open and Edit

Yes. You can open and edit an Excel workbook in Google Sheets by uploading the Excel file to Google Drive and opening it with Sheets. You can either keep working in the Excel format, such as .xlsx, or convert a copy to Google Sheets format; choose based on whether you need to preserve Excel-specific features or collaborate in Google’s browser-based tools.

What “Excel workbook Google” usually means

The phrase can refer to a few different tasks: opening an Excel file in Google Sheets, storing an Excel workbook in Google Drive, or sharing a workbook with someone who uses Google Sheets. These are related, but they are not identical. Drive stores files, while Sheets is the spreadsheet editor. Uploading a workbook to Drive does not by itself convert it into a Google Sheets file.

An Excel workbook is commonly saved as an .xlsx file. Older workbooks may use .xls, and macro-enabled workbooks use .xlsm. Google Sheets can open many Excel files for viewing and editing, but it does not reproduce every Excel capability. The safest choice depends on what is inside the workbook and what the recipients need to do with it.

How to open an Excel workbook in Google Sheets

For a typical .xlsx file, the simplest route is through Google Drive in a web browser:

Sign in to Google Drive and select New > File upload.
Choose the Excel workbook on your computer and wait for the upload to finish.
In Drive, double-click the uploaded file. It will usually open in Google Sheets, where you can view or edit it.

Depending on the file and your Drive settings, Sheets may work with the workbook in Microsoft Office editing mode, keeping it as an Excel file, or you may be prompted to convert it. Check the file name and its file type in Drive before making major edits. If you want to import the contents into a spreadsheet, you can open Sheets, choose File > Import, and select the uploaded file. The import options can include creating a new spreadsheet, inserting sheets, or replacing the current spreadsheet.

On a computer, you can also use Google Sheets to open files stored in Drive. The menus and exact prompts can change as Google updates its interface, but the basic process remains: upload the Excel file, open it with Sheets, and confirm whether you are editing the original Excel format or a converted Google file.

Keep the Excel format or convert it?

Keeping the .xlsx format is useful when the workbook must go back to someone who relies on Microsoft Excel. In Office editing mode, Sheets can make edits while retaining the file as an Excel workbook. This avoids making a separate Google Sheets-format version, but it does not guarantee that every Excel feature will behave exactly as it does in Excel.

To make a Google Sheets copy, open the workbook in Sheets and choose File > Save as Google Sheets. The converted spreadsheet is a separate Google Sheets file; the uploaded Excel file remains in Drive. This is a practical option when your team mainly works in Sheets or needs Google Sheets features such as simultaneous browser-based collaboration. If you later need an Excel copy, use File > Download > Microsoft Excel (.xlsx).

Keep .xlsx when Excel users need the working file, or when you want to minimize format changes.
Convert to Google Sheets when the team will work in Sheets and you want a native Google spreadsheet.
Keep both when you need an untouched source file and a separate version for collaboration. Label the files clearly to prevent edits to the wrong copy.

What may change when a workbook is opened

Common spreadsheet content often transfers well: cell values, many formulas, ordinary formatting, and straightforward charts. However, Excel and Sheets are separate products, so a workbook should be checked after opening or conversion, especially if it supports business reporting, financial calculations, or a repeatable process.

Features that may need particular attention include complex charts, pivot tables, conditional formatting, data validation, external data connections, and Excel-specific features such as Power Query or the Data Model. Support and behavior can vary by feature and file. A workbook that depends on data connections or add-ins may open with the visible results but not retain the process that refreshes those results. Verify the actual workbook rather than assuming that a successful upload means every capability transferred.

Macros are a key distinction. Google Sheets does not run Excel VBA macros. A macro-enabled .xlsm file may open, but its VBA automation will not work as an Excel macro in Sheets. Google Sheets has its own automation options, including Apps Script, but replacing VBA usually requires rewriting and testing the automation. If macros are essential, keep the workbook in Excel and use Excel to run them.

Formulas also deserve a check. Many common formulas work in both products, but some Excel functions, structured references, or specialized formula behaviors may not be supported in the same way. After conversion, look for error values such as #NAME? and compare key totals with the original. Check a few representative results, not only whether the cells appear populated.

Choose the right workflow for your situation

Think about the file’s purpose before deciding where it should live and which format should be the master copy. A personal budget with basic arithmetic may be an easy fit for conversion. A workbook containing VBA, linked data, or elaborate Excel-specific reporting is a stronger candidate for continued use in Excel.

For a quick review: Upload the workbook and open it in Sheets. Avoid converting it if you only need to inspect a few values.
For a Google-based team: Convert a copy if colleagues will edit the file regularly in Sheets. Check formulas, formatting, and permissions before relying on it.
For an Excel-dependent process: Keep the original in .xlsx or .xlsm and edit it in Excel. Drive can be used to store and share the file, but storing it there does not make Sheets a substitute for Excel’s features.
For a one-time handoff: Agree on one authoritative file and format. Multiple copies edited by different people can quickly become inconsistent.

For example, if a team receives a monthly sales workbook with ordinary tables and totals, a Sheets copy may make it easier for several people to update figures together. If that same workbook refreshes sales data through a Power Query connection and runs a VBA button to prepare a report, the team should test the workflow carefully or keep the operational file in Excel.

Sharing and collaborating on the file

Google Sheets is designed for browser-based collaboration. Once a file is in Drive, you can use its Share controls to give specific people access as viewers, commenters, or editors, subject to the options available for the account. People with permission can work on the spreadsheet without passing an attachment back and forth. For a Google Sheets-format file, edits are saved to the shared document as collaborators work.

Sharing an Excel file through Drive does not automatically give everyone access; Drive permissions still apply. Also, editing an Office-format file in Sheets is not the same as using the Excel desktop application. If collaborators need Excel-only features, agree on an editing process that preserves the workbook and avoids simultaneous changes in separate copies. For a critical workbook, keep a clean backup before inviting multiple editors.

When someone needs a local Excel file, download an .xlsx copy and open it in Excel. If a Google Sheets file has been converted, download it through File > Download > Microsoft Excel (.xlsx). Review the downloaded workbook in Excel, especially when it contains formulas, charts, or formatting that matters to its users.

Costs, access, and privacy

Google Sheets is available in a web browser with a Google account, and Google offers personal and organizational account options. The amount of Drive storage and the available administration features depend on the account and plan. Uploading an Excel file uses Drive storage, so a large collection of workbooks may be affected by the account’s storage allowance. Excel desktop access, in contrast, depends on the Microsoft product or license available to you.

Consider the sensitivity of the workbook before uploading it. A file in Drive is subject to its sharing permissions and the policies of the Google account or organization. Check that access is limited to the intended people, particularly if the workbook contains customer, employee, financial, or confidential information. For work accounts, follow your organization’s rules about cloud storage and approved services.

For offline work, Excel desktop is generally the more dependable choice for an Excel workbook, particularly one with advanced features. Google Sheets also offers offline options when configured, but offline availability depends on the account, browser, device, and setup. Do not assume that a file will be editable offline simply because it has been opened once in a browser; confirm offline access before relying on it during travel or an outage.

Common problems and practical fixes

If the file does not open, first confirm that the upload completed and that the file is a supported Excel format. A password-protected or encrypted workbook may need to be opened and saved without that protection in Excel before it can be used in Sheets. Only remove protection if you are authorized to do so, and restore appropriate safeguards when sharing the file.

If numbers or dates look different, check the spreadsheet’s locale and the original cell formats. A value such as 03/04/2026 can mean different dates in different regional settings. A number with leading zeroes, such as a product code, may need to be stored as text so the zeroes are not lost or interpreted as formatting. Compare the displayed values and underlying cell contents with the original workbook.

If a formula shows an error after opening, identify whether the function or reference is Excel-specific, then compare the result against Excel. If a chart, dropdown, or report is missing, check whether the feature was supported in the conversion rather than repeatedly uploading the same file. For important workbooks, preserve the original and test changes on a copy before replacing a production file.

Alternatives to opening it in Google Sheets

If you only need to store or send the workbook, keep it as an Excel file in Drive or another approved storage service and share the file without converting it. Recipients can download it and use Excel or another compatible spreadsheet application. This is often preferable when fidelity matters more than browser-based collaboration.

Excel for the web is another option for working with Excel files in a browser, especially when the workbook uses Microsoft features. Its capabilities differ from the desktop application, so check requirements for advanced tools or automation. If the document is meant to become a long-term shared spreadsheet rather than remain an Excel workbook, Google Sheets may be a good destination after a careful conversion and review.

Frequently Asked Questions

Can Google Sheets open an Excel workbook?
Yes. Upload the workbook to Google Drive and open it in Sheets, or use File > Import from a Google Sheets spreadsheet. Some Excel features may not transfer or work the same way.

Does opening an Excel file in Google Sheets change the original?
Not necessarily. You can edit an Excel-format file in Office editing mode, or choose File > Save as Google Sheets to create a separate converted file. Check the file type and keep a backup when the original matters.

Can Google Sheets run Excel macros?
No. Sheets does not run VBA macros. A macro-enabled workbook may open, but the VBA automation will not run as it does in Excel. Replacing it with Apps Script requires a separate rewrite.

How do I turn a Google Sheets file into an Excel workbook?
Open the spreadsheet and choose File > Download > Microsoft Excel (.xlsx). Then open the downloaded file in Excel and check important formulas and formatting.

Is Google Sheets the same as Google Drive?
No. Drive stores and shares files, while Sheets edits spreadsheets. You can store an Excel workbook in Drive without converting it; opening it in Sheets lets you work with its spreadsheet contents.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.