Excel Workbook File Type: Formats and Extensions Explained

How-to basics · Updated November 18, 2026

The standard file type for a modern Excel workbook is .xlsx, used by Microsoft Excel for Microsoft 365 on Windows when you save a regular workbook. Choose .xlsm if the workbook needs VBA macros, or another format when compatibility, templates, or data exchange calls for it.

What an Excel workbook file type means

A file type describes how information is stored in a file and is commonly indicated by its filename extension: the letters after the final period. For example, QuarterlySales.xlsx has the .xlsx extension. Windows may use that extension to choose an app when you open the file, while Excel uses the file format to interpret the workbook’s contents.

The word workbook refers to the Excel file as a whole. It can contain one or more worksheets, charts, tables, formulas, cell formatting, and other supported content. A worksheet is one tab within that file. The extension is therefore not the name of a particular sheet, nor does it simply describe whether the file contains numbers or text.

For a typical new workbook in current desktop Excel, .xlsx is the normal choice. It is the modern default because it supports the usual worksheet features and is broadly recognized by current spreadsheet software. The best format can differ if a file contains macros, must open in an older application, or is being exchanged as plain data.

Common Excel formats and extensions

These are the formats readers are most likely to encounter. The extension is useful, but the file’s purpose and contents matter too.

  • .xlsx: The standard XML-based Excel workbook format. It supports worksheets, formulas, charts, formatting, and many other workbook features, but it does not store VBA macro code.
  • .xlsm: An XML-based macro-enabled workbook. Use it when the workbook needs VBA macros and you want to retain that code when saving.
  • .xlsb: An Excel binary workbook. It can support many workbook features, including VBA, and may be useful for large or complex files. It is not automatically smaller or faster in every situation.
  • .xls: The older Excel 97–2003 workbook format. Use it only when an older program or workflow requires it; it has lower worksheet limits and may not preserve newer features.
  • .xltx and .xltm: Excel workbook templates. The first is a template without VBA macros; the second is a macro-enabled template. A template is intended as a starting point for new workbooks.
  • .csv: A comma-separated text file for exchanging tabular data. It is not a full Excel workbook: it cannot preserve multiple sheets, cell formatting, charts, or workbook structure.
  • .ods: The OpenDocument Spreadsheet format used by applications such as LibreOffice Calc. Excel can open and save ODS files, although some Excel-specific features may not translate perfectly.

Extensions such as .xlam are used for Excel add-ins rather than ordinary workbooks. If someone asks for an Excel file without specifying a format, .xlsx is usually the appropriate starting point; ask about macros or older software if those might be involved.

How the modern .xlsx format works

The .xlsx format belongs to the Office Open XML family. An .xlsx file is a packaged collection of related parts, including XML data describing workbook elements and the relationships between them. In practical terms, Excel can store the workbook’s sheets, styles, formulas, and other components as structured data rather than as one undifferentiated block.

This structure helps support a wide range of spreadsheet features and makes the format usable across many current office applications. It does not mean every program will reproduce every Excel feature exactly. Advanced charts, particular formulas, external connections, or application-specific features can behave differently when opened elsewhere.

It also explains a common source of confusion: renaming a file from .xls to .xlsx does not convert it. Changing the extension changes the label, not the data structure. Use Excel’s save or export options to create a genuine file in another format.

How to choose the right format

Pick the format based on what the recipient needs to do with the file, not just on which extension looks familiar. Consider these questions before saving:

  • Does the workbook contain VBA macros? Save as .xlsm if those macros must remain in the workbook. Saving a macro-containing workbook as .xlsx removes the VBA project, and Excel warns about this when you choose a format that cannot keep it.
  • Does the recipient use an older spreadsheet program? Ask which format it supports. .xls can help with Excel 97–2003-era compatibility, but saving in that format may remove features or exceed its worksheet limits.
  • Do they need the workbook or just the data? Send .xlsx when they need sheets, formulas, or formatting. Use CSV when a system specifically asks for plain tabular data.
  • Is the file intended as a reusable starting point? Choose .xltx or .xltm for a template, depending on whether VBA macros are required.
  • Will it be edited in another spreadsheet application? Confirm the recipient’s preferred format, then review the converted workbook for unsupported features before relying on it.

For example, a monthly budget with formulas and formatting is generally an .xlsx workbook. A button-driven workbook that runs VBA should be .xlsm. A list of product codes being imported into a database may be more useful as CSV, provided the receiving system specifies the expected delimiter and text encoding.

Save or convert a workbook in Excel

In Excel for Microsoft 365 on Windows, choose File > Save As > Browse. In the Save As dialog, open the Save as type list, select the required format, enter a filename, and select Save. If you are changing an existing workbook’s format, read any compatibility or macro warning before confirming.

To make a separate copy in another format while keeping the original, use File > Save As and give the converted file a different name. This is especially sensible for CSV, legacy .xls, or any conversion that may discard features. Reopen the saved copy and check important sheets, formulas, charts, and values.

On Excel for Mac, the usual route is File > Save As, then choose a format in the file format or file type control in the dialog. The precise dialog wording can vary with the Excel and macOS versions. Excel for the web has fewer file-format options than desktop Excel; for formats it does not offer, open the workbook in the desktop app and use Save As there.

Compatibility, features, and worksheet limits

One major reason to prefer .xlsx over .xls is capacity. In modern Excel, a worksheet can have up to 1,048,576 rows and 16,384 columns. The .xls format is limited to 65,536 rows and 256 columns per worksheet. A workbook with data beyond those older limits cannot be represented fully in .xls.

Compatibility is about more than row counts. When saving in a format that supports fewer features, Excel may flag features that cannot be retained. That can include newer formulas, formatting, or workbook objects. The exact outcome depends on the feature and the target format, so use the Compatibility Checker when Excel offers it and inspect the resulting file.

CSV conversion is particularly different from saving another workbook format. A CSV file represents a single sheet as text values separated by delimiters; it does not retain other sheets, formulas as editable formulas, formatting, or charts. Excel saves the active sheet when exporting to CSV. A formula cell is represented by its calculated value in the exported data, so keep the workbook copy if the formulas matter. Regional settings can affect whether a CSV uses commas or another delimiter, which is worth checking if another system cannot import it.

Macros and file safety

A macro-enabled extension indicates that the format can carry VBA code; it does not prove that a file contains a macro or that its code is safe. Conversely, a familiar-looking filename is not a reliable security check. Treat unexpected attachments with caution, especially if they ask you to enable macros or change security settings.

Excel and Microsoft 365 may block or restrict macros in files from untrusted sources, depending on Windows security markings and organizational policy. Do not enable content simply because a sender says it is necessary. Verify the sender and the reason for the macro through a trusted channel, and follow your organization’s rules. A workbook can also contain external links or data connections, so review prompts about updating linked content before allowing updates.

If a workbook contains macros you need to preserve, keep a clean backup before converting or editing it. Saving a macro-enabled workbook as .xlsx will not preserve its VBA code. If you only need to inspect its data, consider whether you can do so without enabling macros.

Common file-type problems

If Excel says a file extension does not match its format, the file may have been renamed incorrectly, incompletely downloaded, or created by another application. Do not assume that changing the extension will repair it. Obtain a fresh copy from the source or ask the sender to save it in a supported format. Use Excel’s file-opening options cautiously if the file is unfamiliar.

If a recipient cannot open an .xlsx file, first confirm the program and version they use. They may need a compatible spreadsheet application or a different export, such as .xls or CSV. Before converting, decide whether they need formulas and formatting, because a simpler format may discard them.

If a workbook opens with missing macros, check whether it was saved as .xlsx rather than .xlsm or .xlsb. If a CSV contains only one worksheet, that is expected: CSV is a sheet-level data export, not a multi-sheet workbook. If characters appear garbled after import, check the text encoding and import settings rather than trying a different workbook extension at random.

Frequently Asked Questions

What is the default Excel workbook file type?
For a regular workbook in current desktop Excel, the default format is .xlsx. Use .xlsm instead when VBA macros need to be retained.

Is .xlsx the same as .xls?
No. .xlsx is the modern Office Open XML workbook format; .xls is the older Excel 97–2003 format. The older format has lower worksheet limits and may not preserve newer Excel features.

Can an .xlsx file contain macros?
An .xlsx workbook cannot store a VBA project. Save a workbook that needs VBA macros as .xlsm or, where appropriate, .xlsb.

Is CSV an Excel workbook?
No. CSV is a plain-text data format that Excel can open, but it does not preserve a workbook’s multiple sheets, formulas as formulas, charts, or formatting.

Can I change .xls to .xlsx by renaming the file?
No. Renaming only changes the extension. Open the file in Excel and use Save As to convert it, then check for compatibility warnings and confirm the saved copy contains what you need.

Which format should I send to someone?
Use .xlsx for a normal editable workbook, .xlsm when they need its VBA macros, and CSV when they request plain tabular data. If they use older software or a particular import system, confirm its requirements first.

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.