Excel File Extensions Explained: XLSX, XLS, XLSM, XLSB and More

What Excel File Extensions Tell You

Every Excel workbook saves with a file extension that signals what kind of content lives inside. The extension is the short string after the final dot in a filename — say, sales-report.xlsx or budget-2026.xlsm. That tiny tag matters more than most users realize. It tells Windows or macOS which program should open the file. It tells Excel whether to expect macros, binary data, or a template.

It tells email gateways and antivirus tools whether the file is risky to deliver. And it tells collaborators whether their version of Excel can even open the workbook without complaints. Modern Excel supports roughly a dozen file extensions, each with its own purpose, performance characteristics, and compatibility quirks.

Most Excel users default to .xlsx and never think about alternatives. That works fine for ordinary spreadsheets. But the moment you add macros, target older Excel versions, build templates for reuse, handle multi-million-row datasets, or exchange data with non-Microsoft tools, the choice of extension starts to affect real work.

Picking the right format prevents wasted hours converting files back and forth, lost macros, blocked email attachments, and slow file opens on big workbooks. This guide walks through every Excel file extension you are likely to encounter, when each one is the right pick, and how to convert between them without losing data. Our what-is-Excel guide covers the broader picture of how Excel fits into modern work.

The XLSX Format and Why It Replaced XLS

The .xlsx extension is the default Excel workbook format used since Excel 2007 introduced the Office Open XML standard. Files saved as .xlsx are actually compressed ZIP archives containing a structured set of XML files describing every part of the workbook — sheets, cells, formulas, charts, formatting, and metadata. You can verify this by renaming any .xlsx file to .zip and unzipping it. The resulting folder reveals the internal XML structure that Excel uses to rebuild the workbook each time it opens.

This open format brings real advantages over the older binary .xls files Excel used through 2003. The XML structure compresses well, so .xlsx files are typically smaller than the .xls equivalents. The format is documented openly, which means other tools — LibreOffice, Google Sheets, Python pandas, R, Java POI — can read and write .xlsx files reliably without reverse-engineering Microsoft proprietary binary spec.

The .xlsx format also handles much larger datasets than .xls ever could. Modern Excel worksheets support 1,048,576 rows and 16,384 columns inside an .xlsx file, compared to only 65,536 rows and 256 columns in the legacy .xls format. That row limit increase alone made the migration to .xlsx essential for analysts working with substantial data volumes. The .xlsx format does have one important limitation worth knowing — it cannot store macros or VBA code.

That restriction is by design. Excel 2007 separated macro-enabled workbooks into the .xlsm extension specifically so that opening a regular .xlsx file would never expose users to potentially malicious VBA code lurking inside. If your workbook needs macros, you need .xlsm. If it does not, .xlsx is almost always the right pick for ordinary work.

XLS, XLSM, XLSB, and XLTX Compared

The legacy .xls extension dates back to Excel 97 through 2003. It uses a proprietary binary format known as BIFF (Binary Interchange File Format). Files saved as .xls have the row and column limits mentioned above and cannot use features introduced after Excel 2003 — no dynamic arrays, no XLOOKUP, no Power Query, no slicers in the modern sense. You should generally avoid creating new .xls files.

The only reason to use the format today is compatibility with very old systems or specific government tools that have not been updated since the mid-2000s. Even those use cases are rare in 2026. If a vendor or partner still requires .xls files, push back politely and ask whether they can accept .xlsx instead. Most can once the question is raised.

The .xlsm extension is .xlsx plus macros. Macro-enabled workbooks store VBA code alongside the regular workbook content. Excel warns users when opening .xlsm files because malicious macros have historically been a major malware vector. The warning appears even for macros you wrote yourself. Save your workbook as .xlsm whenever it needs VBA — never try to save a macro-containing workbook as .xlsx, because Excel will strip the macros silently with only a small warning that many users miss.

The .xlsb (binary workbook) extension is a special variant that stores the same content as .xlsx but in a binary format rather than XML. Files saved as .xlsb open and save dramatically faster on large workbooks (often 2 to 4 times faster) and take less disk space. The trade-off is reduced compatibility with non-Microsoft tools. Use .xlsb for huge personal workbooks where performance matters and the file stays inside Microsoft tools. Our Excel cheat sheet covers performance tuning for large workbooks.

CSV, TSV, and Other Data Exchange Formats

Beyond native Excel formats, the .csv (comma-separated values) extension is the most common data exchange format you will encounter. CSV files are plain text where each row is one line and columns are separated by commas. They contain no formatting, formulas, charts, or multiple sheets — only raw data. Almost every data tool on the planet reads CSV files, from databases to programming languages to BI tools.

Excel opens CSV files natively, parses them into a worksheet, and lets you save the result back as CSV or convert to .xlsx for richer features. CSV is the right choice when you need to share data with non-Excel tools, import data into a database, or hand off rows to a developer. Avoid CSV when you need to preserve formulas, formatting, or multiple sheets — those simply cannot exist inside a CSV file.

The .tsv (tab-separated values) extension is the same idea but uses tabs instead of commas as column delimiters. TSV files are slightly more reliable than CSV when your data contains commas inside cells (addresses, names, descriptions) because tab characters rarely appear inside ordinary text data. Excel handles .tsv files but treats them a bit differently than .csv during import. The .txt extension is the most general plain-text option.

Excel can import .txt files using the Text Import Wizard, which lets you specify delimiters, character encoding, and column types manually. This wizard handles fixed-width files, pipe-delimited files, and other unusual formats that .csv or .tsv cannot handle natively. You will reach for .txt rarely but it is essential when dealing with old mainframe exports or unusual data files. Our CSV to Excel guide covers conversion in depth.

Excel Template Formats — XLTX and XLTM

Templates deserve their own section because many Excel users skip them entirely and lose hours of productivity as a result. The .xltx extension marks an Excel template — a workbook designed to be the starting point for new workbooks rather than edited directly. When you double-click an .xltx file, Excel opens a fresh untitled workbook pre-populated with the formatting, layouts, formulas, and styling from the template.

The original .xltx remains untouched on disk. This pattern works beautifully for repetitive workbooks like monthly reports, expense forms, invoice templates, or budget worksheets where the structure stays the same but the data changes each cycle.

The .xltm extension is the macro-enabled equivalent of .xltx. Use it when your template includes VBA code that runs on the new workbook (form-filling automation, data validation routines, custom ribbon buttons). Both template formats live in a specific location on Windows (typically the Templates folder under your user profile) so Excel can find them under File > New > Personal Templates. Storing templates in this location makes them appear in the new workbook menu automatically.

The first investment in setting up proper templates pays back quickly because repetitive workbook creation becomes a one-click operation rather than a copy-paste-and-clean-up exercise that often introduces errors. Most Excel-heavy roles benefit from building 5 to 15 personal templates for the workbook types they create most often. Our Excel templates guide walks through building your first template.

How to Change an Excel File Extension

Changing an Excel file extension is straightforward but the safe way depends on what you are trying to do. If you want to convert a workbook from one format to another (say, .xls to .xlsx) the correct approach is File > Save As inside Excel itself. Choose the new format from the Save as Type dropdown. Excel handles the conversion properly, adjusts any features that need adjustment, and warns you about anything that will not survive the conversion. This works for any pair of formats Excel supports. Save As is the safe answer for almost any format conversion question.

Manually renaming a file to change its extension (right-click in File Explorer, rename, change the extension after the dot) is a different operation and rarely the right approach. Renaming changes only the filename — the file content itself stays in whatever format it was. Renaming a .xls file to .xlsx does not actually convert the content to the modern XML format.

Excel will sometimes still open the renamed file because it detects the actual content type, but other tools may refuse to read it correctly, and some operations may produce surprising results. The only legitimate use case for renaming is troubleshooting — for example, renaming .xlsx to .zip to inspect the internal XML structure for debugging purposes. For real conversion work, always use Save As inside Excel. Our Excel to PDF guide covers exporting to non-Excel formats.

Excel Extensions in Email and Corporate Environments

File extensions matter outside Excel itself, too. Corporate email gateways often block certain Excel extensions because of malware risk. The .xlsm and .xltm formats — anything macro-enabled — are the most commonly blocked, since malicious macros remain a primary vector for office-based malware. Many organizations require alternative delivery (SharePoint links, OneDrive sharing, or zipped attachments with passwords) when sending macro-containing workbooks. Plain .xlsx files almost always pass through email gateways without trouble. If your recipients report missing attachments, check whether the extension is one your organization filters before assuming the email system failed.

Antivirus tools and endpoint security platforms also scan Excel files based on extension. The macro-enabled formats receive the strictest scrutiny, often quarantining files until users manually approve them. This causes friction in workflows that legitimately need macros, especially in financial modeling, audit, and operations roles where VBA-driven workbooks are common. The workaround in mature organizations is usually code-signing macros with a trusted certificate, which whitelists the macro content for trusted senders.

Smaller organizations often just live with the friction. Knowing which extensions trigger which security responses helps you choose the format that minimizes problems for the workbook journey — sometimes a redesign that moves logic out of VBA into native Excel formulas pays back through reduced security friction even if the rebuild itself takes a few hours.

Verifying and Changing the Default Save Format

Excel saves new workbooks in whatever default format you have configured under File > Options > Save > Save files in this format. The default is .xlsx for most installations. You can change this to .xlsm, .xlsb, or even the legacy .xls if your workflow requires a different default. Most users should leave the default at .xlsx and use Save As to pick a different format when needed.

Changing the default to .xlsm just because some workbooks use macros tends to cause confusion later — every new workbook now gets the security-warning treatment whether it has macros or not, which trains recipients to ignore the warning and bypasses one layer of malware defense.

Verifying the actual format of an existing file is worth doing periodically, especially for files that have moved between systems or been emailed multiple times. Right-click the file in Windows Explorer and check Properties to see the actual extension and file type. On macOS, use File > Get Info in Finder. If Windows is hiding file extensions (a common default setting), enable View > Show > File name extensions in File Explorer.

Once extensions are visible everywhere, format mismatches become easy to catch — you can immediately see when a .xlsx has been silently renamed to .xls or vice versa. This visibility prevents the most common file-handling mistakes that cause workbooks to break unexpectedly when shared across teams or platforms.

Wrapping Up — Picking the Right Excel Extension

The short answer to picking an Excel file extension is .xlsx almost always, .xlsm when you need macros, .csv when handing off data to non-Excel tools, and .xltx for reusable templates. The other extensions exist for specific niches — .xlsb for huge personal workbooks, .xls only for legacy compatibility, .txt and .tsv for unusual data exchange formats.

Most Excel users go years without needing anything beyond .xlsx and .csv. Knowing the full picture matters mainly when something goes wrong — a recipient cannot open the file, macros vanish silently, a workbook becomes painfully slow, or an email gateway blocks the attachment. In each of those cases, understanding which extension caused the problem (and which to switch to) unblocks the work quickly.

The biggest practical advice is to set Windows or macOS to always show file extensions so you can see at a glance what format any workbook is in. Without visible extensions, files look identical in File Explorer regardless of whether they are .xlsx, .xlsm, or .xlsb — and the wrong format can cause hours of trouble before anyone notices.

Make file extensions visible system-wide, learn the handful of formats that matter for your specific workflows, and use Save As inside Excel rather than manual renaming when conversions are needed. That small set of habits prevents the vast majority of Excel file-format problems and frees you to focus on the content of your work rather than fighting with the file system about how it is stored.