Microsoft Excel Workbook: What It Is and How to Use One

A Microsoft Excel workbook is a file that stores spreadsheet data and the parts used to organize, calculate, analyze, and present it. In Excel for Microsoft 365 on Windows, a workbook usually contains one or more worksheets, each made of cells arranged in rows and columns; you can create one with File > New > Blank workbook and save it as an .xlsx file.

What “workbook” means in Excel

Workbook is Excel’s name for the complete spreadsheet file, not just the grid currently visible on screen. A workbook can contain several worksheets, along with items such as formulas, tables, charts, formatting, named ranges, and—in some file types—macros or data connections. When you open an Excel file, you open a workbook; the selected tab at the bottom shows one worksheet inside it.

The distinction is useful when someone asks you to “send the workbook” or “add a sheet.” Sending the workbook means sharing the file. Adding a sheet means adding another tab within that file. For example, a small shop might keep separate worksheets named January, February, and March in one annual sales workbook. Each sheet can hold different data, while the workbook keeps those related sheets together.

How a workbook is organized

A worksheet is a two-dimensional grid. Columns have letter labels, rows have number labels, and a cell is identified by combining the two: A1 is in column A and row 1; C5 is in column C and row 5. Cells can hold text, numbers, dates, formulas, or other values Excel recognizes. A selected cell or range is where you enter data, apply formatting, or perform an operation.

Worksheets appear as tabs along the bottom of the Excel window. Select a tab to switch sheets; use the plus button beside the tabs to insert a worksheet. Double-click a tab to rename it, or right-click it for options such as Move or Copy, Delete, and Tab Color. The ribbon at the top groups commands by task, while the formula bar displays or edits the contents of the selected cell.

Besides ordinary worksheets, a workbook may include chartsheets, which display a chart on a separate tab, and other features that work across the grid. Tables, PivotTables, charts, and data connections are not separate workbook files: they are objects or features saved as part of a workbook. The exact features available can depend on the Excel version and file format.

Create, name, and save a workbook

In Excel for Microsoft 365 on Windows, choose File > New > Blank workbook to start from an empty file. You can also select a template on the New page when you want a preformatted layout, such as a calendar or budget. Templates may include sample data and formulas, so check their contents before replacing anything important.

To save a new workbook, choose File > Save As, select a location, enter a file name, and choose a file type. Excel normally uses .xlsx for a standard workbook. The title bar shows the workbook’s name; saving regularly or using AutoSave with a cloud-stored file helps preserve recent changes. AutoSave is available for eligible Microsoft 365 files saved to OneDrive or SharePoint, and its status can depend on the account and file location.

For a simple, well-organized workbook, consider these habits:

Use a descriptive file name, such as QuarterlySales2026.xlsx, rather than a vague name such as Book1.
Give each worksheet a short, specific tab name, and use a consistent naming pattern when sheets represent months or departments.
Put clear column headings in the first row of a data table and avoid blank rows or columns inside the data.
Keep a separate untouched copy of important source data before making substantial changes.

On Mac, the basic ideas are the same, though the menu bar and dialog appearance differ; use File > New and File > Save As. In Excel for the web, create or open a workbook in the browser, usually from OneDrive or SharePoint. Cloud workbooks commonly save changes automatically, while a file downloaded to a computer must be saved there separately.

Enter data and calculate results

Click a cell, type a value, and press Enter to place it in the worksheet. To edit an existing cell, select it and type a replacement, or edit its contents in the formula bar. A formula begins with an equals sign and can use cell references, arithmetic operators, or functions. A formula referring to cells can update its result when those inputs change.

For example, if B2 contains 12, B3 contains 18, and B4 contains 20, the formula =SUM(B2:B4) adds those cells and returns 50. The layout assumed here is the three values in B2:B4, with the formula entered in another cell; the arithmetic is 12 + 18 + 20 = 50. The colon in B2:B4 means the range from B2 through B4.

Excel also offers tools to sort and filter data, format values as dates or currency, create charts, and summarize lists with PivotTables. For example, turning a consistent data range into a table through Insert > Table makes it easier to filter column headings and extend formatting as rows are added. Formatting changes how a value looks; it does not necessarily change the stored value. A cell that displays $1,200, for instance, may contain the numeric value 1200 with currency formatting.

Workbook file types and what they preserve

The extension at the end of a file name indicates its format, and the format affects which workbook features can be retained. The usual choices are:

.xlsx: The standard modern Excel workbook format. It supports most everyday spreadsheet content but does not store VBA macros.
.xlsm: An Excel macro-enabled workbook format that can store VBA macros. A macro-enabled extension does not mean a file is safe to run.
.xlsb: An Excel binary workbook format. It can hold many Excel features, including macros, but may be less convenient for systems that expect the more common .xlsx format.
.xls: An older Excel 97–2003 workbook format. Saving in it can limit or alter features that newer Excel versions support.
.csv: A text format for delimited data, not a full-featured Excel workbook. It generally saves the active sheet’s displayed data, not the complete set of workbook tabs, charts, formatting, or formulas as working Excel objects.

Choose .xlsx when you need an ordinary workbook without VBA, and .xlsm only when a trusted process requires macros. Use CSV when a service specifically needs plain tabular data, and check which worksheet and values will be exported. If Excel displays a compatibility warning, read it before continuing: saving in an older format or a simplified format can remove features. Keep an original copy if you are unsure.

Sharing, collaboration, and privacy

You can share a workbook as an attachment, store it in OneDrive or SharePoint, or provide a sharing link. Cloud storage can let multiple people work on the same file, subject to their access permissions and the features supported by their Excel versions. Before sharing, consider whether recipients need view or edit access. A link that allows editing gives recipients more control than a view-only link.

Workbook protection has several meanings, and they are not interchangeable. Protect Sheet can restrict changes to cells or worksheet structure; it is intended to prevent accidental edits, not to provide strong confidentiality. Protect Workbook can restrict structural changes such as adding, moving, or deleting sheets. Password encryption for opening a file is a separate option and offers a stronger barrier, but it does not remove the need to store passwords securely. Do not assume that hiding a worksheet makes its contents private.

Take care with files from email, websites, or unknown senders. Excel may open some downloaded files in Protected View. Do not select Enable Editing or enable macros just because a workbook asks; first consider whether you expected the file and trust its source. Macros can make changes or perform actions beyond ordinary cell calculations. Share only the data the recipient needs, and remove hidden or sensitive information before distributing a copy.

Common workbook problems

A workbook that opens with a warning, missing content, or unexpected appearance may have been created in another Excel version or saved in a format that does not preserve all its features. First make a copy, then review the warning and file extension. If a workbook is slow, look for unnecessary formatting applied to entire columns, large formulas, external links, or heavy data connections; a smaller test copy can help isolate the cause.

If a formula displays as text instead of calculating, check whether the cell is formatted as Text or whether an apostrophe precedes the equals sign. Change the cell format to General if appropriate, then re-enter the formula. If a formula shows ####, the column may simply be too narrow for the formatted result; widen it before assuming the value is wrong. A #REF! error usually indicates that a formula refers to a cell or range that is no longer available, often because referenced cells were deleted.

When a workbook seems to have lost changes, check the file name and location: you may have edited a downloaded copy rather than the cloud original, or saved another version under a different name. Look at Excel’s recent files and the folder where the workbook was saved. For a file stored in OneDrive or SharePoint, check its sync status and version history if available through the service.

Frequently Asked Questions

Is an Excel workbook the same as a worksheet?

No. A workbook is the complete Excel file, while a worksheet is one tab within that file. A workbook can contain several worksheets, and each worksheet contains its own cell grid.

How do I create a new workbook in Excel?

In Excel for Microsoft 365 on Windows, choose File > New > Blank workbook. On Mac, use File > New; in Excel for the web, create a blank workbook from the browser’s New or Excel start page.

What is the difference between .xlsx and .xlsm?

Both are Excel workbook formats, but .xlsm can store VBA macros and .xlsx cannot. Use a macro-enabled file only when needed, and treat macros from untrusted sources cautiously.

Can an Excel workbook have more than one sheet?

Yes. A workbook can contain multiple worksheets, which you can add with the plus button by the sheet tabs. The practical limit depends on available memory and system resources rather than a small fixed number of tabs.

Does a CSV file save the whole workbook?

No. CSV is a plain-text data format, not a complete workbook format. It does not preserve a workbook’s collection of sheets and many Excel features, so use .xlsx when you need to keep the workbook structure intact.

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.