The standard extension for a modern Excel workbook is .xlsx. Use .xlsm when the workbook needs to keep VBA macros, or choose another format only when a specific need—such as compatibility with an older Excel version or a smaller binary file—calls for it.
What a workbook extension tells you
A filename extension is the part after the final period, such as .xlsx in QuarterlyReport.xlsx. It identifies the file format to Windows, Excel, and other applications. The extension can indicate whether a file is an ordinary workbook, a macro-enabled workbook, a template, or a file intended for another purpose.
An extension is useful, but it does not tell the whole story. Two files can contain similar-looking sheets while storing data differently, and a file’s extension does not prove that its contents are safe or intact. Excel uses the format to decide how to interpret the file and which features it can preserve. Changing the letters in a filename does not convert the file: renaming report.xls to report.xlsx does not turn an older workbook into the newer format.
In everyday use, a file with worksheets, formulas, charts, and formatting is usually saved as .xlsx. If you are unsure, that is the right default for a workbook that does not need VBA macros.
The main Excel file extensions
Excel offers several workbook-related formats. The most useful ones to recognize are:
.xlsx— The standard XML-based workbook format used by modern Excel. It supports worksheets, formulas, charts, formatting, and many other workbook features, but it does not store VBA macros..xlsm— A macro-enabled workbook format. Choose it when the file contains VBA macros that need to remain in the workbook..xlsb— The Excel binary workbook format. It can be useful for large or complex workbooks and supports VBA macros, but its binary structure is less convenient for inspection by other tools..xls— The older Excel 97–2003 workbook format. Use it only when an older application or workflow specifically requires it, because it has lower worksheet limits and may not preserve newer features..xltxand.xltm— Excel template formats. The first is for templates without VBA macros; the second is for macro-enabled templates..xlam— An Excel add-in format, generally used to distribute workbook features or VBA tools that Excel can load as an add-in.
These extensions are related, but they are not interchangeable. A workbook saved as a template is intended to serve as a starting point for new files, while an add-in is meant to provide functionality inside Excel rather than act as an ordinary document.
Why XLSX became the default
Excel adopted the Office Open XML formats as its modern default beginning with Excel 2007. An .xlsx file is a package containing XML files and other resources, such as images, arranged in a defined structure. This approach supports a broad range of workbook content and makes it possible for compatible software to inspect or work with parts of a file.
The familiar spreadsheet features most people need—multiple worksheets, formulas, cell formatting, charts, tables, and many types of data connections—can be stored in an XLSX workbook. The important limitation is VBA: an XLSX file cannot preserve VBA macro code. If Excel detects VBA content when you save in this format, it warns that the code will be removed if you continue.
That limitation is not a defect for a workbook that has no macros. XLSX is generally the best choice for sharing ordinary spreadsheets because it is widely supported and avoids enabling VBA code just to open the file. However, some less common Excel features may have their own compatibility requirements, so check any warning Excel displays during conversion.
How to choose the right format
Choose the format according to what the workbook must do and who needs to open it. A practical decision process is:
- Use
.xlsxfor a regular workbook that contains no VBA macros. - Use
.xlsmif the workbook relies on VBA code, such as a button that runs a macro. - Consider
.xlsbfor a large workbook or a workflow that specifically benefits from the binary format. Check that the people and systems receiving it can use that format. - Use
.xlsonly when you have a real need to support Excel 97–2003 or another system that requires that older format. - Choose
.xltxor.xltmwhen you are distributing a reusable template rather than a finished workbook.
For example, a staff rota with formulas and conditional formatting but no macros can normally be shared as Rota.xlsx. If a button runs VBA to create a new schedule, save the working file as Rota.xlsm. The visible appearance may be similar, but saving the macro version as XLSX can discard the code.
How to save a workbook in another format
In Excel for Microsoft 365 on Windows, use File > Save As > Browse, then choose the desired option from the Save as type list. Enter a filename and select Save. To keep the original and create a second-format copy, use Save As rather than replacing the only copy.
On a Mac, use File > Save As and select a format from the File Format menu. The labels or dialog layout can vary slightly between Excel versions. In Excel for the web, the available options differ from the desktop application; for formats and features that are not offered there, open the workbook in desktop Excel.
When you save to a format that cannot represent all the workbook’s content, Excel may show a compatibility warning. Read it before confirming. It may identify features that will be lost, changed, or unsupported. If the warning concerns macros or a feature important to the recipient, cancel the save and choose a more suitable format instead.
Workbook extensions compared with CSV and other formats
A CSV file is not a full Excel workbook. It stores tabular data as text, with values separated by delimiters, and is useful for transferring data between applications. It does not preserve a workbook’s multiple worksheets, formulas as working formulas, cell formatting, charts, or VBA macros. When Excel saves a sheet as CSV, it saves data from the active sheet rather than the entire multi-sheet workbook. The exact text representation can also depend on the chosen CSV option and regional settings.
Other applications may use formats such as OpenDocument Spreadsheet, whose common extension is .ods. Excel can work with some non-native formats, but features may not transfer perfectly in both directions. If a colleague specifically requests CSV or ODS, consider retaining a separate XLSX or XLSM master copy so you do not lose workbook features when creating the exchange file.
In short, use a workbook format when you need a working spreadsheet with its structure and features intact. Use CSV when the goal is a straightforward data handoff and the recipient does not need the workbook’s formulas, layout, or multiple sheets.
Compatibility and version limits
Modern XLSX, XLSM, and XLSB workbooks support worksheets with up to 1,048,576 rows and 16,384 columns. The older XLS format is limited to 65,536 rows and 256 columns per worksheet. A file with data beyond those older limits may be truncated or otherwise altered when saved to XLS, so exporting to that format is not a harmless change for a large sheet.
Older Excel releases may not support every feature created in a newer release. Excel’s Compatibility Checker can help identify some issues when saving to an older format, but it is still sensible to inspect the saved copy, especially if the workbook contains advanced charts, newer functions, or complex formatting. A recipient’s version of Excel and any third-party spreadsheet application can affect what they can use.
Excel for the web can open many common workbooks, but it does not run, create, or edit VBA macros. A macro-enabled workbook may still be useful there for ordinary spreadsheet work, but someone who needs the macro functionality must use desktop Excel. On Mac, Excel supports many of the same workbook formats, though particular features can vary by version and platform.
Security and common extension problems
Macro-enabled formats such as XLSM can contain executable VBA code. That can be legitimate—for example, a company may use a macro to automate a repetitive report—but macros can also be used maliciously. Do not enable macros in an unexpected file just because it has an Excel icon or an .xlsm extension. Follow your organization’s security procedures and verify the sender and file before enabling code.
Some common problems have straightforward explanations:
- The macro disappeared: The workbook may have been saved as XLSX. Check whether the original XLSM or XLSB copy still exists, and use a macro-capable format when saving future edits.
- Excel says the extension does not match the file: The file may have been renamed without being converted, downloaded incorrectly, or created in another format. Ask for a fresh copy or open it from a trusted source and save it through Excel in the intended format.
- A recipient cannot open the file: Confirm their application supports the format. If they need only plain data, a CSV export may work; if they need formulas and layout, XLSX is usually more appropriate.
- The file is unexpectedly large: The workbook may contain extensive formatting, images, embedded objects, or unused data. XLSB can be worth considering, but first check for unnecessary content and confirm that recipients can use it.
Do not try to fix a format mismatch simply by changing the extension in File Explorer. Use Excel’s Save As options to convert a workbook so the file contents and extension agree.
Frequently Asked Questions
What is the default extension for an Excel workbook?
For a regular workbook in modern Excel, the default extension is .xlsx. Use .xlsm instead if the workbook needs to retain VBA macros.
Is XLSX the same as Excel?
No. Excel is the spreadsheet application; XLSX is one file format that Excel can create and open. Excel also supports formats such as XLSM, XLSB, XLS, CSV, and ODS, with different capabilities.
Can I change XLS to XLSX by renaming the file?
No. Renaming changes the filename, not the internal file format. Open the workbook in Excel and use File > Save As to create an XLSX copy.
Can an XLSX file contain macros?
No. XLSX does not store VBA macro code. Save a workbook that must retain VBA as XLSM or, where appropriate, XLSB.
Which Excel extension should I use for sharing?
Use XLSX for most ordinary workbooks. Use XLSM when VBA macros are required, and check the recipient’s software and needs before choosing an older or less common format.
Related
- Protect Sheet in Excel: Allow Editing in Certain Cells
- Jira Merge Table Cells: Steps and Limitations
- Conditional Formatting: Highlight Duplicates in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Checkbox in Google Sheets: Add and Use ItTo add a checkbox in Google Sheets, select the cell or range, then choose Insert > Checkbox. Click…
- Conditional Formatting in Outlook: Setup and LimitsConditional formatting in Outlook automatically changes how matching messages look in the message list, such as displaying mail…
- How to Create Columns in a Word Document: A Simple GuideTo create columns in a Word document, open the Layout tab, select Columns, and choose a layout such…
- Excel Shortcut Keys for Switching Between WorksheetsIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet tab, or…
- Microsoft Excel Always Not Responding? Causes and FixesNo—Microsoft Excel does not always become unresponsive because it is broken. A brief freeze can happen while a…
- Google Sheets Add Item to Dropdown: Steps and TipsTo add an item to a Google Sheets dropdown, select a cell that uses the dropdown, open Data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.