Open an Excel Sheet: Quick Steps and File Options

How-to basics · Updated November 20, 2026

To open an Excel sheet in Microsoft Excel for Microsoft 365 on Windows, open Excel and choose File > Open > Browse, select the workbook, and click Open. You can also double-click an Excel file in File Explorer. An Excel file is usually a workbook containing one or more sheets, so opening the file makes its sheets available as tabs along the bottom of the window.

What it means to open an Excel sheet

People often use “Excel sheet” to mean either a spreadsheet file or one page inside that file. Excel calls the file a workbook and the individual grid pages worksheets, usually shortened to sheets. A workbook might contain tabs named January, February, and March, for example. Opening a workbook does not open each sheet in a separate file; it opens the workbook, and you switch between its sheets using the tabs at the bottom.

This distinction matters if someone asks you to open a particular sheet. First open the workbook that contains it, then click the matching sheet tab. If you do not see the tab, check for the small tab-navigation arrows at the lower left, or right-click a visible sheet-tab navigation arrow to view a list of sheets. A sheet may also be hidden; in that case, right-click a visible sheet tab and choose Unhide, if that option is available.

Open an existing workbook in Excel

Use Excel’s Open screen when you want to browse to a saved workbook or choose one from your recent files:

  1. Start Excel from the Windows Start menu or taskbar.
  2. On the start screen, choose Open. If a workbook is already open, choose File > Open.
  3. Choose Browse to open the Windows file picker. You may also see workbooks listed under Recent or locations such as OneDrive.
  4. Go to the folder containing the file, select it, and choose Open. Double-clicking the filename in the file picker also opens it.

Excel’s Recent list is a shortcut to files you have opened before; it is not necessarily a list of files stored on your computer. A recent entry may point to a OneDrive location, a network folder, or a removable drive. If the file has been moved, renamed, or disconnected, Excel may not be able to reach it from that entry. Choose Browse and locate its current location instead.

If you know the file’s name but not its folder, use the search box in File Explorer or check likely locations such as Documents, Downloads, Desktop, or the folder where your browser saves downloads. Confirm the file extension and modified date when several similar filenames appear. Selecting a file in the picker and choosing Open is safer than guessing between versions with names such as Budget-final and Budget-final-2.

Open a workbook from File Explorer

When Excel is installed and associated with the file type, double-click an .xlsx, .xls, or .xlsm file in File Explorer to open it. You can also right-click the file, choose Open with, and select Excel. If Excel is not listed, choose another app and select Excel if it is installed. Windows may offer an option to always use the selected app for that file type; use it only if you want Excel to handle those files by default.

Dragging a workbook onto the Excel app icon or an open Excel window can also open it. If Excel is already running, the workbook generally appears in another window or as another open workbook, depending on your window arrangement. Avoid opening a file from an email attachment or unfamiliar download until you know who sent it and why. A familiar file extension alone does not establish that a file is safe.

On a Mac, open Excel and choose File > Open, or use Finder to double-click a workbook. If the file opens in another application, use Finder’s Open With command to select Microsoft Excel. Excel for the web works differently: use its file picker or OneDrive rather than Windows File Explorer to select cloud files.

Open files from OneDrive or Excel for the web

If a workbook is saved in OneDrive, you can open it from Excel’s Open screen by selecting the relevant OneDrive location, or open OneDrive in a browser and select the workbook. Depending on your account and permissions, it may open in Excel for the web or offer an option to open it in the desktop app. The browser version is useful for viewing and editing supported workbook content without starting the desktop program, while the desktop version may be needed for particular features or workflows.

When you open a shared workbook, you may have permission to view but not edit it. If Excel says the file is read-only or asks you to request access, the owner or organization’s sharing settings control what you can do. Do not make a separate copy and assume it will update the shared original: a downloaded or locally saved copy is a different file unless it is saved back to the shared location.

If a cloud workbook is not appearing, check that you are signed in to the Microsoft account that has access to it and that the file has finished syncing. A cloud-only file may need an internet connection to open. If you use a work or school account, organization policies can also affect access, sharing, and which Excel features are available.

Identify the file type before opening

The extension after the filename helps indicate what kind of file you are opening. Common examples include:

  • .xlsx: The standard modern Excel workbook format. It does not store VBA macros.
  • .xlsm: An Excel workbook format that can contain VBA macros. Opening it does not mean you should automatically enable its macros.
  • .xls: An older Excel workbook format, which may have compatibility limits compared with current workbooks.
  • .csv: A plain-text, comma-separated data file, not a full Excel workbook. It normally represents tabular data rather than multiple sheets, formulas, or workbook formatting.

Excel can open many other text and data formats, but the result depends on the file’s structure. When using File > Open > Browse, the file-type list in the dialog can help you locate a file that is not displayed under the current filter. Changing the filter does not convert the file; it only changes which files the picker shows.

CSV files deserve particular care. Excel may interpret text that looks like a date or number, and a value such as 00127 can lose its leading zeros if treated as a number. If the original file is important, keep an untouched copy. For more control over importing a text file, use Excel’s Data tab and the available text or data import options rather than immediately saving over the original. A CSV also cannot preserve features such as multiple worksheet tabs, cell formatting, or Excel formulas as workbook features.

Protected View, read-only files, and editing

Excel may open some files in Protected View, a restricted mode intended to reduce risk from files that came from the internet or another potentially unsafe location. A message bar may explain that the file opened in this mode. If you trust the source and have checked that the file is the one you intended to open, Excel may offer Enable Editing. Do not enable editing just to dismiss a warning when the sender or file is unexpected; macros and other active content can pose additional risks.

Read-only status is different from Protected View. A workbook may be read-only because you lack edit permission, the file is marked read-only, another person or process is using it, or Excel opened it with a recommendation to avoid changes. If you only need to inspect data, read-only access may be appropriate. If you need to edit, check the workbook’s permissions and location, then use Save As to create a separate copy when that is permitted and suitable. A copy will not automatically replace or update the original.

If Excel asks for a password, the workbook may be encrypted or protected. You need the correct password or access granted by the person who manages the file. Do not assume that changing a filename or extension removes password protection; it does not unlock the workbook.

Common problems when opening a workbook

If a workbook does not open as expected, use the message Excel gives you to narrow down the cause. These checks solve many ordinary file-opening problems:

  • The file is missing: Check the folder, filename, and extension, then search the computer or cloud storage. A recent-file entry can point to an old location.
  • Excel says the format or extension is invalid: The extension may not match the file’s actual contents, or the file may be incomplete. Ask the sender for a fresh copy rather than renaming it at random.
  • The workbook appears damaged: Make a copy first. In Excel, choose File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair if that option is available. Excel may offer repair or data extraction, but recovery is not guaranteed.
  • The file is locked or in use: Close other copies of the workbook and check whether another user or program is editing it. On a shared location, ask the other user before trying to replace or overwrite the file.
  • The file opens with unexpected symbols or columns: It may be a text file with a different delimiter or character encoding. Importing it through Excel’s data tools can provide more control than opening it directly.

For an older workbook, Excel may display a compatibility notice or disable features that the older format cannot store. Keep the original unchanged if you need to preserve it, and save a separate copy in a modern workbook format only after checking that the contents look right. If the file is essential and a repair attempt fails, request another copy or contact the person responsible for the source rather than repeatedly overwriting the damaged file.

Choose the right way to open it

The best method depends on where the workbook is and what you need to do. Use Excel’s Open screen when you want to select a location, find a recent file, or inspect a file type. Double-clicking in File Explorer is convenient for a workbook already on your Windows computer. OneDrive or Excel for the web is practical for a cloud-stored file or shared editing, provided you have the correct account and permissions.

If you only want to look at a workbook and are unsure whether you should change it, open it read-only when that option is offered or make a copy before editing. If you need macros, external data connections, or specialized workbook features, the desktop app may be more appropriate than the browser version, but availability can depend on the specific feature, account, and file. For a simple table, Excel for the web may be enough. In either case, verify that you have opened the intended file and that its sheets and data appear as expected before making changes.

Frequently Asked Questions

How do I open an Excel sheet without Excel installed?

You can use Excel for the web with a Microsoft account and a workbook stored or uploaded to an accessible location. Other spreadsheet programs may also open many Excel files, but formatting or advanced features can differ. Keep the original file before saving changes in another program.

How do I open a specific sheet in an Excel workbook?

Open the workbook, then click the worksheet’s tab at the bottom. If the tab is not visible, use the tab-navigation arrows or check whether the sheet is hidden. A hidden sheet can be shown by right-clicking a visible sheet tab and choosing Unhide when available.

Why does Excel open my file in Protected View?

Excel may use Protected View for files it considers potentially unsafe, including some files downloaded from the internet. Confirm the source and contents before choosing Enable Editing. If the file is unexpected or untrusted, close it instead of enabling editing or active content.

Can I open an XLSX file in Google Sheets?

Google Sheets can import many .xlsx workbooks, but some formatting, formulas, or Excel-specific features may not transfer exactly. If you need a faithful Excel workbook, open it in Excel when possible and check the result before converting or saving a copy in another format.

What should I do if an Excel file will not open?

Check that you have the right file, that it is fully downloaded, and that you have permission to access it. If Excel reports damage, preserve a copy and try File > Open > Browse > Open and Repair. If it still fails, request a fresh copy from the file’s owner.

Related

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.