An Excel workbook is usually saved in the .xlsx format, the standard format for modern versions of Microsoft Excel. Choose a different format, such as .xlsm for a workbook that must keep VBA macros or .csv for plain-text data, when you need a specific compatibility or sharing feature.
What does Excel workbook format mean?
A workbook format is the file type Excel uses to store a spreadsheet and the information associated with it. The extension at the end of a file name—such as .xlsx—signals the format to Windows and to applications that open the file. It also indicates what kinds of workbook content the format can preserve.
An Excel workbook can contain multiple worksheets, cell values, formulas, formatting, charts, tables, and other objects. Some formats preserve most of those features; others store only a limited representation of the data. That distinction matters when opening, editing, or sending a file. A file that looks like a spreadsheet is not necessarily a full-featured Excel workbook.
In Microsoft 365 for Windows, the normal workbook format is Excel Workbook (*.xlsx). Excel uses it by default for new workbooks unless a different default or file type has been selected. A familiar file name might be QuarterlySales.xlsx.
Why XLSX is the standard format
XLSX is the default format for current Excel workbooks. It is based on Office Open XML, a standardized document format. An .xlsx file is technically a package containing structured XML documents and related resources, compressed together. Excel manages those parts for you; people normally open and edit the workbook through the Excel interface rather than changing the package directly.
XLSX supports ordinary spreadsheet content such as multiple sheets, formulas, cell formatting, charts, and tables. It also generally produces smaller files than the older .xls format, particularly for workbooks with lots of data. It is widely supported by current spreadsheet software, although software other than Excel may not reproduce every Excel-specific feature exactly.
The important limitation is that an .xlsx workbook cannot store VBA macro code. If Excel detects VBA code when you save a macro-enabled workbook as .xlsx, it warns that the code will be removed if you continue. Use a macro-capable format instead if you need to retain the code.
Common Excel file extensions
The extension is a useful clue, but the right choice depends on what the workbook contains and how it will be used. These are the formats readers are most likely to encounter:
- .xlsx — Excel Workbook: The usual choice for workbooks without VBA macros. It supports multiple sheets and common Excel features.
- .xlsm — Excel Macro-Enabled Workbook: Use this when the file must retain VBA macros. It can contain the same kind of ordinary workbook content as an .xlsx file, along with macro code.
- .xlsb — Excel Binary Workbook: Stores workbook data in a binary format and can support VBA. It can be useful for some large or complex workbooks, but it may be less convenient for workflows that depend on inspecting or processing the XML-based .xlsx package.
- .xls — Excel 97–2003 Workbook: The older Excel format, kept mainly for compatibility with older software or systems that require it.
- .xltx — Excel Template: A template without VBA macros. Opening a template normally creates a new workbook based on it, leaving the template itself available for reuse.
- .xltm — Excel Macro-Enabled Template: A reusable template that can include VBA macros.
- .csv — Comma Separated Values: Plain-text data arranged in rows and columns. It is not a full Excel workbook format.
- .ods — OpenDocument Spreadsheet: A format used by applications such as LibreOffice Calc and supported by Excel, though some features may not transfer perfectly.
These extensions are not interchangeable labels. Saving a file in another format can change or discard features, so treat a format change as a conversion rather than merely renaming the file.
How to choose the right format
Start with the job the file needs to do. If the workbook is for everyday Excel use and contains no macros, .xlsx is usually the most practical choice. If it contains VBA, select .xlsm or, where appropriate, .xlsb. If a recipient has an older system that specifically requires the legacy format, .xls may be necessary, but check whether the older format can represent the workbook’s content.
- Sharing a normal workbook: Use .xlsx for sheets, formulas, charts, and formatting that should remain editable.
- Keeping VBA code: Use .xlsm, and make sure the recipient’s organization permits macro-enabled files.
- Sending a reusable starting point: Save as .xltx or .xltm, depending on whether the template includes macros.
- Moving a simple table into another system: Use .csv if that system requests comma-separated text and you only need one sheet’s values.
- Working with an older Excel installation: Use .xls only when compatibility requires it, and review any warnings about unsupported features.
- Exchanging files with another spreadsheet application: Consider .ods if the other application expects it, then check the converted workbook for differences.
For a file that must be editable and preserve its layout, sending the actual workbook is usually preferable to exporting CSV. For a file that is only meant to be read or printed, a PDF may be more suitable, but a PDF is a document export, not a spreadsheet workbook format.
How to change a workbook’s format
In Excel for Microsoft 365 on Windows, open the workbook and choose File > Save As > Browse. In the Save As dialog, open the Save as type list, select the format you need, enter a file name, and choose Save. Depending on the format, Excel may show a message explaining which features could be lost or changed.
Saving under a new name is a sensible way to keep an untouched copy of the original. For example, you can retain Budget.xlsx and create a separate Budget.csv for an import, rather than overwriting the workbook. The Save As workflow is similar in Excel for Mac, though dialog labels and the available format list can vary by Excel version. Excel for the web has a more limited set of file-management options; download or open the file in the desktop app if you need a format that is not offered there.
Do not change a file’s extension by simply renaming it in File Explorer. Renaming report.xlsx to report.xls does not convert its contents. Use Excel’s Save As command so the application writes the data in the structure expected by the selected format.
What happens when you save as CSV?
CSV is useful because many databases, websites, and data tools can import plain-text rows and columns. However, it cannot retain the full contents of an Excel workbook. A CSV file represents one worksheet at a time and does not preserve multiple sheets, cell formatting, charts, tables, or VBA macros. It also does not store Excel formulas as working formulas in the same way a workbook does; the exported content is generally the displayed or saved cell data.
For example, a workbook might have a formatted report sheet and a separate notes sheet. Saving as CSV exports the active sheet, not both sheets as a combined workbook. If the data includes commas, quotation marks, or line breaks, CSV uses text conventions to keep fields together, but the receiving application must interpret them correctly. The delimiter can also depend on regional settings or the export workflow, so a file described as CSV may not always use the same separator in every environment.
Before exporting, select the worksheet you intend to send, check that formulas have calculated, and consider whether dates, leading zeros, or long identification numbers need special handling. A value such as an account code beginning with zero may be interpreted differently when another program imports plain text. Keep the .xlsx original if you may need the formulas, layout, or other worksheets later.
Legacy XLS and compatibility limits
The .xls format is associated with Excel 97–2003 and uses an older binary workbook structure. Its worksheet size limit is 65,536 rows by 256 columns, compared with 1,048,576 rows by 16,384 columns in modern .xlsx workbooks. A workbook that exceeds the older limits cannot be represented fully in .xls.
Even when a workbook fits within those row and column limits, newer Excel features may not be available in the older format. Excel can warn about compatibility issues when saving. Read those warnings rather than assuming the conversion is lossless: formulas, formatting, or newer objects may be changed or omitted. If the recipient can use .xlsx, that is generally a better choice than converting to .xls simply because it is familiar.
Older file formats can also be subject to different security considerations. If an unexpected .xls file arrives by email, follow your organization’s file-handling rules and do not enable content just because Excel presents a prompt. The extension alone does not establish that a file is safe.
Macros, security, and trust
A macro-enabled extension indicates that a file can contain VBA code; it does not mean that every such file is malicious, nor does it prove that a file is safe. Macros can automate legitimate tasks, but they can also be used to run harmful actions. Only enable macros in a file when you trust its source and have a valid reason to run them. Many workplaces restrict macros or allow them only from approved locations.
Excel may display a security warning or block macros based on the file’s source and the organization’s policy. Do not bypass those controls to make an unfamiliar workbook work. Ask the sender for a macro-free .xlsx copy if the automation is not needed, or verify the file through a trusted channel before using it. A workbook password and macro security are separate issues: protecting a file with a password does not establish that its code is trustworthy.
Common format problems and practical checks
Several problems that look like Excel errors are really format mismatches. A recipient may see a warning because a workbook with macros was saved as .xlsx, a CSV export may contain only one worksheet, or an older .xls file may lack room for all the rows. In each case, returning to the original workbook and saving a copy in a more suitable format is safer than trying to reconstruct missing content from the converted file.
Before sending a workbook, consider these quick checks:
- Confirm the extension matches the content: .xlsx for a regular workbook, .xlsm when VBA must be retained, and CSV only for plain-text data export.
- Open the saved copy and confirm the expected sheets, formulas, charts, and formatting are still present.
- Review Excel’s compatibility or conversion prompts before accepting a format that may remove features.
- For CSV, verify the correct sheet and inspect a few records in the application that will import it.
- For macro-enabled files, share them only with intended recipients and explain why the macros are needed.
If a file will be used by people on different platforms, agree on the format before distributing it. Modern Excel versions on Windows and Mac support common workbook formats, but other spreadsheet applications can interpret formulas and advanced features differently. A quick check by the recipient is especially useful when the workbook is important or contains complex formatting.
Frequently Asked Questions
What is the default Excel workbook format?
For current Excel versions, including Microsoft 365, the default format is generally .xlsx. It is the standard choice for workbooks that do not need to preserve VBA macros.
Is XLSX the same as Excel?
No. Excel is the spreadsheet application; .xlsx is one file format the application can open and save. Excel also supports formats such as .xlsm, .xlsb, .xls, .csv, and .ods.
What format should I use for an Excel file with macros?
Use .xlsm if the workbook needs to retain VBA macros. Excel may remove the macros if you save that workbook as .xlsx. Only enable macros in files from sources you trust.
Can I convert XLS to XLSX?
Yes. Open the .xls file in Excel, choose File > Save As, and select Excel Workbook (*.xlsx). Review any compatibility warning, then check the converted copy because older or unsupported features may not transfer exactly.
Is CSV an Excel workbook?
No. CSV is a plain-text format for tabular data, not a complete workbook. It generally represents one sheet and does not preserve workbook features such as multiple worksheets, formatting, charts, or VBA macros.
Which Excel format should I send to someone?
For an ordinary editable workbook, send .xlsx. Choose .xlsm only when the recipient needs the macros, and CSV only when they need a simple data export. If the recipient uses older software or another spreadsheet application, confirm the required format and check the file after conversion.
Related
- Power Query Text to Columns: Split Data Step by Step
- Data Validation Framework: Design, Rules, and Examples
- What Is Power Query? Excel Data Cleanup Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Combine Cells in Excel and Keep All ValuesTo keep every entry, combine the cell contents into a result first, copy that result, and use Paste…
- Excel Keyboard Shortcut to Resize a Column or AutoFitIn Excel for Microsoft 365 on Windows, select a cell in the column and press Alt, H, O,…
- Google Sheets Filter by Last Name: Sort and SearchYes. In Google Sheets in a web browser, select the full table, choose Data > Create a filter,…
- Excel Drop-Down Lists with Named Ranges: Setup and TipsTo create an Excel drop-down list from a named range, define a name for the cells containing your…
- Excel Date Slicer by Month: Setup and TroubleshootingYes. In Excel for Microsoft 365 on Windows, create a PivotTable, group its date field by months, then…
- Outlook Reading Pane: How to Change the View and LayoutTo change your Outlook reading pane, open the mail view and choose a position: in classic Outlook for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.