Excel File Format Guide: XLSX, XLS, CSV and Other Types

How-to basics · Updated November 18, 2026

An Excel file format is the type of file used to save a workbook, identified by its extension. For most current workbooks, use .xlsx; choose .xlsm if the workbook must retain VBA macros, and use .csv only when you need a plain-text data export rather than a fully featured workbook.

What an Excel file format means

A workbook can contain worksheets, formulas, formatting, charts, tables, and other elements. Its format determines which of these features can be stored and how other programs can read the file. The extension at the end of the filename—such as .xlsx—is a quick clue to the format. It also helps Windows and other applications decide what should open the file.

Changing a filename’s extension does not convert its contents. Renaming report.xlsx to report.csv, for example, does not turn the workbook into valid CSV data. To change formats, use Excel’s save or export options so it can convert the workbook appropriately.

Common Excel file extensions

These are the formats most likely to matter when creating, sharing, or importing spreadsheet files:

  • .xlsx: The standard Excel workbook format for modern versions of Excel. It supports most workbook features but does not store VBA macro code.
  • .xlsm: An Excel macro-enabled workbook. Choose it when a workbook uses VBA macros that need to be preserved.
  • .xlsb: An Excel binary workbook. It can store workbook features and VBA macros in a binary format. It may suit some large or complex workbooks, but the best choice depends on the workbook and the applications that need to open it.
  • .xls: The older Excel 97–2003 workbook format. Use it only when compatibility with older software or systems specifically requires it.
  • .csv: A plain-text, comma-separated data format. It is useful for transferring tabular data, but it does not preserve a multi-sheet workbook’s formatting, formulas, or other Excel features.
  • .ods: The OpenDocument Spreadsheet format used by applications such as LibreOffice Calc. Excel can open and save ODS files, though features may not transfer perfectly between programs.
  • .xltx and .xltm: Excel workbook templates. The first is for templates without VBA macros; the second is for templates that contain them.

For everyday work in current Excel, .xlsx is generally the safest default. The other formats are not simply alternate names for the same file: they make different trade-offs in features, compatibility, and what information is retained.

How XLSX and other workbook formats work

The .xlsx format is based on Office Open XML. In practical terms, it packages structured files—including XML data—inside a compressed container. This design supports workbook content such as cell values, formulas, formatting, and charts. You normally do not need to inspect the package itself; Excel reads and writes it for you.

The older .xls format uses a different, legacy binary structure. It also has much lower worksheet capacity: up to 65,536 rows and 256 columns per worksheet, compared with 1,048,576 rows and 16,384 columns in current Excel worksheet formats. Saving a modern workbook as .xls can therefore cause compatibility warnings or require changes to content that the older format cannot represent.

The .xlsb format stores workbook data in a binary workbook format rather than the XML-based package used by .xlsx. A binary format is not automatically better or safer; it is simply another option. When sharing files, check that the recipient’s software supports the format you choose.

What CSV keeps—and what it leaves out

CSV is often confused with an Excel workbook because Excel can open CSV files and display their rows and columns. But a CSV file is plain text, not a complete spreadsheet. It represents tabular values as text separated by delimiters, commonly commas. It has no workbook structure for multiple sheets, cell formatting, charts, or Excel formulas.

When Excel saves a worksheet as CSV, it exports the active sheet’s data, not every sheet in the workbook. Formula cells are saved as their calculated results rather than as working Excel formulas, and formatting is not retained. A date may appear as text in one display style, for example, while the original cell number format is lost. If a recipient needs to keep formulas or edit several worksheets, send an Excel workbook instead.

CSV files can also be affected by regional settings. Some systems use a semicolon as a list separator, and a CSV produced under one convention may not split into columns as expected under another. Excel offers CSV UTF-8 as a save option, which can help preserve characters such as accented letters when exchanging text internationally.

How to choose the right format

Start with what the recipient needs to do, rather than with the file extension alone. A useful rule of thumb is:

  • Choose .xlsx for a normal editable workbook that needs sheets, formulas, and formatting.
  • Choose .xlsm when the workbook needs to retain VBA macros. Confirm that the recipient expects a macro-enabled file.
  • Choose .csv when another system needs a simple table of values, and you do not need to transfer workbook features.
  • Choose .xls only when a legacy program or workflow requires that older format.
  • Choose .ods when the receiving workflow specifically uses OpenDocument spreadsheets, and review the result in the target application.
  • Choose .xltx or .xltm when you are distributing a reusable starting point rather than a finished workbook.

For example, a monthly budget with formulas and separate sheets should normally be shared as .xlsx. A product list being uploaded to a website may be requested as CSV, but export only after checking which worksheet, columns, delimiters, and text encoding the website expects. If the workbook contains macros used to prepare that list, remember that a CSV export will not carry those macros with it.

Save or convert a workbook in Excel

In Excel for Microsoft 365 on Windows, use File > Save As > Browse, then choose the required type in the file type list and save. To export a plain-text file, you can also use File > Save As and select a CSV option. Excel may display a notice that some workbook features are not compatible with the selected format; read it before confirming, because continuing can discard information.

On a Mac, use File > Save As and choose a format from the file format list. The wording and dialog layout can differ by Excel version, but the key action is to select the target format rather than rename the file. Excel for the web supports common workbook workflows, but available save and export choices can differ from the desktop apps. If a specific format is missing, open the file in the desktop version of Excel.

For a CSV import in Windows Excel, Data > From Text/CSV lets you preview how the file will be interpreted before loading it. This is useful for checking delimiters and data types. It can help avoid treating an item code such as 00127 as a number and losing its leading zeros. For a one-off export, save a copy first so the original workbook remains intact.

Compatibility and conversion issues

Excel can open many formats, but opening a file successfully does not guarantee that every feature will work the same way after conversion. A formula supported in one application may not be supported in another, and charts or formatting can change when a workbook is saved to an older or different format. If the file is important, keep the original and inspect the converted copy in the software that will receive it.

Common warning signs include:

  • Features will be lost: Excel is telling you that the chosen format cannot store some content. Choose a compatible workbook format if you need to preserve it.
  • Text appears in one column: A CSV delimiter may not match the expected regional separator. Import the file and select the appropriate delimiter.
  • Leading zeros disappear: The receiving program may interpret an identifier as a number. Import the column as text when the value is a code rather than a quantity.
  • Characters look incorrect: The file may have been saved with an encoding that the receiving program interpreted differently. Try a UTF-8 CSV option when available.
  • The wrong sheet was exported: CSV saves the active worksheet. Select the intended sheet before saving, then check the exported file.

One common misconception is that CSV is a safer or more complete version of Excel. It is simpler and broadly supported, but it carries less information. Another is that a workbook can become macro-enabled just by changing its extension. Macro code must be saved in a format that supports it, such as .xlsm; changing the name alone cannot add or preserve that capability.

File safety and macros

The extension helps identify a file type, but it does not prove that a file is trustworthy. Treat unexpected attachments and downloads cautiously, even when they appear to be spreadsheets. In particular, VBA macros can perform actions when enabled, so only enable macros in files from sources you trust and when you understand why they are needed. A normal .xlsx workbook does not store VBA macros, while .xlsm is designed to retain them.

CSV has no Excel macro project, but it is not automatically harmless in every situation. When spreadsheet software opens CSV text, content that begins with characters interpreted as a formula may be treated as a formula. If you are preparing data from untrusted sources for other people to open, review formula-like entries and follow the receiving organization’s safe data-handling process.

Frequently Asked Questions

What is the default Excel file format?
For current desktop versions of Excel, the normal workbook format is .xlsx. It is the general-purpose choice for workbooks that need sheets, formulas, and formatting but do not need VBA macros.

Is XLSX better than XLS?
For most current work, yes: .xlsx supports modern worksheet capacity and features. Use .xls when an older system specifically requires Excel 97–2003 compatibility, and check Excel’s warnings before saving to that format.

What is the difference between XLSX and XLSM?
Both are Excel workbook formats, but .xlsm can retain VBA macro code and .xlsx cannot. If a workbook’s macros are required, save it in a macro-enabled format instead of .xlsx.

Does a CSV file save all Excel sheets?
No. Excel’s CSV export saves data from the active worksheet, not the entire multi-sheet workbook. It also does not preserve workbook formatting or working formulas.

Can I change XLSX to CSV by renaming the file?
No. Renaming changes only the filename, not the file’s internal structure. Use Excel’s Save As or export options to create a CSV, then check the resulting data and delimiter.

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.