Excel File Name Extensions: .xlsx, .xlsm, .xls and More

How-to basics · Updated November 18, 2026

The standard Excel file name extension is .xlsx, the default for workbooks in Microsoft Excel for Microsoft 365 on Windows. Use .xlsm when a workbook needs to store VBA macros; other extensions identify older workbooks, templates, add-ins, and different file formats.

What a file name extension tells you

An extension is the ending after the final period in a file name. In Quarterly Budget.xlsx, the name is Quarterly Budget and the extension is .xlsx. Windows and other operating systems use extensions as clues about what kind of data a file contains and which applications can open it. Excel uses them to distinguish its workbook formats and to decide what features and content can be saved.

The extension is not merely a label. Excel files can contain formulas, formatting, charts, worksheets, connections, and other data, but formats do not all support the same features. Choosing the wrong one can remove content or produce a compatibility warning. Changing the characters after the period does not convert the file: a workbook saved as an XLSX file does not become a valid PDF or macro-enabled workbook just because someone renames its ending.

Common Excel extensions and when to use them

These are the extensions most Excel users are likely to encounter. The best choice depends on what the workbook contains and who needs to open it.

  • .xlsx — The usual format for a modern Excel workbook. It supports ordinary worksheets, formulas, charts, tables, and formatting, but it cannot store VBA macro code. Choose it for most workbooks that do not need macros.
  • .xlsm — A macro-enabled Excel workbook. It can store VBA macros as well as workbook data. Choose it when a workbook relies on macros and needs to remain an editable workbook.
  • .xlsb — An Excel binary workbook. It can store macros and workbook features, but uses a binary format rather than the XML-based package used by XLSX and XLSM. It can be useful for certain large or complex workbooks, though compatibility with other spreadsheet programs may be less predictable.
  • .xls — The Excel 97–2003 workbook format. Use it only when a recipient or older system specifically requires that legacy format. It has older format limits and may not retain newer Excel features.
  • .xltx — An Excel workbook template that does not store VBA macros. A template is intended as a starting point for new workbooks rather than as an ordinary finished workbook.
  • .xltm — A macro-enabled Excel template. Choose it when the template needs to include VBA code.
  • .xlam — An Excel add-in format, generally used to distribute add-in features rather than a normal workbook for everyday data entry.

Older installations may also encounter .xla, an earlier Excel add-in format. Extensions such as .xlsb or .xltm are not interchangeable with .xlsx; select the format that matches the file’s purpose.

Why .xlsx is the default

XLSX is part of the Office Open XML family of formats and is the standard choice for a regular Excel workbook. It replaced the older XLS format as the normal save format in newer Excel releases. The format is structured as a package of related files, which allows it to represent modern workbook content and makes it distinct from the older binary XLS format.

For everyday work, its main practical advantage is broad suitability: it handles common workbook features while not carrying VBA macro code. That makes it an appropriate starting point for budgets, schedules, lists, reports, and similar files that do not depend on macros. It is also widely supported by current spreadsheet applications, although complex Excel-specific features may not behave identically in every program.

A common misconception is that XLSX is always safer or that macros cannot exist anywhere in an XLSX file. More precisely, XLSX does not store VBA project code as a macro-enabled workbook does. Files can still contain other active content or links, and a file’s extension alone does not prove it is trustworthy. Treat files from unknown sources with care.

How to choose the right format in Excel

In Excel for Microsoft 365 on Windows, use File > Save As, choose a location, and select a format from the Save as type list. The wording and available choices can vary slightly depending on the workbook and Excel version. If you are saving a new, ordinary workbook, Excel normally offers the Excel Workbook format, which uses .xlsx.

Before saving, consider what the workbook actually needs to do:

  • For a standard workbook with no VBA macros, choose Excel Workbook (.xlsx).
  • For a workbook that needs its VBA macros preserved, choose Excel Macro-Enabled Workbook (.xlsm).
  • For a reusable starting file, choose an Excel template format: .xltx without macros or .xltm with macros.
  • If a recipient requires Excel 97–2003, choose Excel 97–2003 Workbook (.xls) and review any compatibility warnings.
  • If the recipient only needs the displayed values in a simple table, consider whether a text format such as CSV is suitable; it will not preserve a full workbook.

When Excel warns that a format does not support a feature, read the message rather than dismissing it automatically. The warning may mean a feature will be removed or changed. If you need both a modern working copy and a version for an older system, save separate copies in the respective formats and verify the legacy copy.

What happens when you save as .xlsm

When a workbook contains VBA macros, saving it as .xlsx cannot preserve those macros. Excel may warn that macro features will be lost. Choose .xlsm if the VBA code must remain available in the workbook. Simply changing the extension in File Explorer does not restore or preserve the code.

Macro-enabled does not mean that a workbook will automatically run its macros. Excel’s security settings and the source of the file affect whether macros are blocked or require the user’s permission. A recipient should enable macros only when they trust the file and understand why the code is needed. An .xlsm extension signals that the format can contain VBA; it is not a guarantee that the workbook contains useful macros or that its code is safe.

Excel for the web can work with some macro-enabled workbooks, but VBA macros cannot run in the browser. Use the desktop Excel application when the workbook’s workflow depends on running VBA, and confirm that a particular feature works in the version being used.

Excel extensions compared with CSV and PDF

CSV is a common source of confusion because Excel can open and save files ending in .csv. CSV means comma-separated values: it is a text format for tabular data, not a complete Excel workbook. When saving as CSV, Excel saves the active worksheet’s data in a text representation. Other sheets, formulas as formulas, formatting, charts, and many workbook features are not retained as they are in an XLSX workbook. Depending on the chosen CSV variant and regional settings, separators and character encoding can also matter.

PDF serves a different purpose. A PDF is generally used to share a layout for viewing or printing, not to continue editing a spreadsheet as a workbook. It does not preserve the normal worksheet structure and formulas in the way an XLSX file does. To keep a spreadsheet editable in Excel, use a workbook format; to share a simple data table with a system that expects text, CSV may fit; to distribute a fixed-layout report, PDF may be more appropriate.

OpenDocument Spreadsheet files use the .ods extension. Excel can open and save certain files in this format, but conversion can affect features or formatting. If collaborators use different spreadsheet applications, agree on a format and check the resulting workbook, especially when it uses advanced Excel features.

Changing or checking an extension

If you cannot see extensions in Windows File Explorer, turn on View > Show > File name extensions. This makes it easier to distinguish, for example, Report.xlsx from a file named Report.xlsx.xlsx, or to notice when a downloaded file has an unexpected type. The exact layout of File Explorer controls can vary by Windows release.

To convert a workbook, open it in Excel and use File > Save As to select the destination format. Do not rely on renaming the extension in File Explorer: renaming changes the name, not the file’s internal structure. Renaming may also make the file harder for applications to recognize.

On a Mac, use Excel’s File > Save As and select a file format in the format control. Available choices can differ from Windows or depend on the workbook. Excel for the web has fewer format and desktop-application capabilities than Excel for Microsoft 365 on Windows, so use desktop Excel if you need a format option that is unavailable online.

Common extension problems and fixes

  • Excel says the file format and extension do not match: The extension may have been changed manually, or the file may have been created in another format. Confirm its source and use Excel’s Open dialog or the original application to identify and resave it. Do not assume a mismatch is harmless.
  • Macros disappeared: Check whether the workbook was saved as .xlsx. If so, the VBA code may have been removed during saving. Use a macro-enabled source copy and save it as .xlsm before making further changes.
  • A file opens with a warning or appears damaged: An incorrect extension, incomplete download, or damaged file can cause problems. Get a fresh copy from a trusted source before trying recovery options.
  • A workbook loses features after saving: It may have been saved in a format that cannot support those features, such as the older .xls format or CSV. Save a modern workbook copy as .xlsx or .xlsm, depending on whether it requires VBA.
  • The extension is hidden: Enable file name extensions in File Explorer so you can see the actual ending rather than relying only on an icon or a shortened name.

Frequently Asked Questions

What is the default Excel file extension?
The default extension for a standard workbook in current Excel is .xlsx. A workbook that needs to store VBA macros should normally be saved as .xlsm.

What is the difference between .xlsx and .xlsm?
Both are modern Excel workbook formats, but .xlsm can store VBA macro code and .xlsx cannot. Use XLSM when macros must be preserved; otherwise XLSX is the usual choice.

Can I change .xls to .xlsx by renaming the file?
No. Renaming only changes the file name. Open the workbook in Excel and use File > Save As to convert it, then check whether Excel reports features that may not carry over.

Is .csv an Excel file extension?
CSV is a text format that Excel can open and create, but it is not a full Excel workbook format. It generally saves the active sheet’s tabular data and does not retain the workbook’s complete formulas, formatting, sheets, or charts.

Which Excel extension should I use for a template?
Use .xltx for a template without VBA macros and .xltm for a macro-enabled template. These formats mark the file as a template intended to help create new workbooks.

Why can’t I see .xlsx after the file name?
Windows often hides known file extensions by default. In File Explorer, select View > Show > File name extensions to display them.

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.