Excel and spreadsheet file formats explained
Spreadsheet formats are not interchangeable: some preserve formulas, multiple sheets, charts and formatting, while others carry only cell values or a fixed visual copy. Use .xlsx for an ordinary editable Excel workbook, .xlsm when Excel macros must be retained, .csv or .tsv for plain tabular data, .ods for an OpenDocument spreadsheet, and .numbers for an Apple Numbers file. If a file will not open or changes appearance, start with the wider document compatibility guide and check whether the receiving app supports the file's actual format.
Spreadsheet formats preserve different parts of a workbook
A spreadsheet can contain much more than rows and columns. Depending on the format, it may store formulas, calculated values, cell styles, multiple worksheets, charts, images, filters, pivot tables, external links, macros and print settings. The extension at the end of the filename identifies the container used to hold those features.
The most important distinction is whether you need to preserve a working spreadsheet or only its data or appearance:
- Working workbook: Choose a format such as XLSX, XLSM, XLSB, XLS or ODS when the recipient must continue editing formulas, sheets and formatting.
- Plain tabular data: Choose CSV or TSV when another system needs rows and fields rather than a complete workbook.
- Fixed visual copy: Choose PDF when the recipient needs to read, review, share or print the result without using spreadsheet software.
- App-native document: Keep a Numbers file in its native format while editing in Apple Numbers, but export a copy when sharing it with people who use other software.
XLSX, XLSM and XLSB are modern Excel workbook formats
.xlsx is the standard choice for a current Excel workbook without macros. It is an XML-based format that can preserve worksheets, formulas, charts, formatting and most normal Excel features. Microsoft Excel opens it directly, while Google Sheets, Apple Numbers and LibreOffice Calc can also import or open many XLSX files.
.xlsb is Excel's modern binary workbook format. It can hold workbook features and macro code, but it is less broadly supported than XLSX. Use it when an existing Excel workflow specifically depends on XLSB rather than choosing it as a general sharing format.
| Format | What it is designed to preserve | Common software that opens it | Main limitation |
|---|---|---|---|
| .xlsx | Formulas, worksheets, charts and formatting | Microsoft Excel, Google Sheets, Apple Numbers, LibreOffice Calc | Cannot contain VBA macros |
| .xlsm | XLSX-style workbook content plus macro code | Microsoft Excel; some other apps can import the workbook content | Macros may not run outside desktop Excel |
| .xlsb | Excel workbook content in a binary format | Primarily Microsoft Excel; support elsewhere varies | Less portable than XLSX |
| .xltx | Reusable Excel template without macros | Microsoft Excel and some compatible spreadsheet apps | Intended to create workbooks, not act as the finished workbook |
| .xltm | Reusable Excel template with macro code | Microsoft Excel | Macro behavior depends on Excel and its security settings |
XLS is the older Excel binary format
.xls was the standard Excel workbook extension before the modern Open XML formats became the default. Current desktop versions of Excel can open XLS files, normally in Compatibility Mode, and applications such as LibreOffice Calc can also open and save them.
Changing the filename from .xls to .xlsx does not perform that conversion. The internal file structure remains unchanged, and Excel may warn that the extension does not match the actual format. A real conversion requires opening the file in compatible spreadsheet software and using Save As or Export to create a new file.
CSV and TSV contain data rather than complete workbooks
A .csv file is plain text arranged as records and fields, commonly with commas separating the fields. A .tsv file uses tab characters instead. These formats are useful for moving tabular data between spreadsheet software, databases, accounting systems, contact managers and other applications.
CSV and TSV do not preserve a full spreadsheet workbook. When Excel saves a workbook as CSV, it saves the active worksheet's displayed values rather than the workbook's complete feature set. Other sheets, formulas as formulas, charts, cell colors, fonts, merged cells, comments and most layout information are not part of the resulting plain-text file.
Delimited files can also open incorrectly even when they are not damaged. Common causes include:
- the file uses semicolons, tabs or another delimiter instead of commas;
- a text field contains a comma and is not quoted as the importing app expects;
- dates are interpreted according to the wrong regional convention;
- long numbers are displayed in scientific notation;
- leading zeroes disappear from identifiers such as account codes;
- the app reads the file with the wrong character encoding;
- all fields appear in one column because the delimiter was not detected.
If the file contains formulas or carefully designed formatting, keep the original workbook as the master copy and create CSV only as an export for the system that needs the data.
ODS and Numbers belong to different spreadsheet ecosystems
.ods is the OpenDocument Spreadsheet format. It is the native spreadsheet format associated with applications such as LibreOffice Calc and is defined by the OpenDocument standard. Microsoft Excel can open and save ODS files, and Google Sheets can import or export them, but feature and formatting differences can appear when a workbook moves between ODS and Excel formats.
A .numbers file is an Apple Numbers spreadsheet. Numbers on a Mac can import Excel spreadsheets and delimited text files, then export copies in formats including Excel, CSV, TSV and PDF. A recipient who does not use Numbers will usually need an exported copy rather than the native Numbers file.
Google Sheets is different because its native spreadsheets normally live in Google Drive rather than being exchanged through a distinctive desktop filename extension. Google Sheets can work with Excel files and can download copies in formats such as XLSX, ODS, CSV and PDF.
The extension and the spreadsheet's contents reveal what you need
Start with the complete filename, not its icon. Different apps can assign similar icons to unrelated formats, and a filename can be renamed without changing the data inside it. If extensions are hidden on your computer, display them before choosing an app or attempting a conversion.
Use this quick reference to identify the likely format and opening method:
| Extension or type | Best first app or method | What to check after opening |
|---|---|---|
| .xlsx | Current Microsoft Excel; Google Sheets, Numbers or LibreOffice Calc are alternatives | Formulas, charts, conditional formatting and print layout |
| .xls | Desktop Excel or LibreOffice Calc | Compatibility warnings and features limited by the older format |
| .xlsm | Desktop Microsoft Excel | Whether macros are required, trusted and permitted to run |
| .xlsb | Desktop Microsoft Excel | Whether the recipient's software supports binary workbooks |
| .csv | Import into Excel, Google Sheets, Numbers or Calc | Delimiter, encoding, dates, leading zeroes and column data types |
| .tsv or tab-delimited .txt | Import as delimited text | Confirm that tabs are selected as the separator |
| .ods | LibreOffice Calc; Excel and Google Sheets can also handle it | Formula, chart and formatting compatibility |
| .numbers | Apple Numbers | Export a copy if the recipient does not have Numbers |
| Google Sheets document | Open through Google Drive or Sheets | Download XLSX, ODS, CSV or PDF when a separate file is needed |
| A PDF reader or browser | Treat it as a fixed document rather than the editable source workbook |
After the file opens, do not assume that a visible table proves the conversion was successful. Check the features that matter to the document:
- Inspect the sheet tabs. A CSV or TSV file normally represents one table, not a multi-sheet workbook.
- Select formula cells. Confirm that the formula bar contains formulas rather than only their previous calculated results.
- Recalculate totals. A value can appear correct immediately after import even if a formula or reference was lost.
- Check dates and identifiers. Look for reversed day and month values, removed leading zeroes or rounded long numbers.
- Review charts and pivot tables. Cross-application conversion may preserve source cells while changing the objects built from them.
- Test filters and data validation. Dropdown lists, rules and table behavior may not survive a move into a plain-text format.
- Inspect print preview. Column widths, page breaks, paper size, margins and scaling can change even when the worksheet looks acceptable on screen.
- Check for macros before saving. Saving a macro-enabled workbook as XLSX removes its VBA project because XLSX cannot store that code.
If an application reports that the file format and extension do not match, pause before opening it. The file may have been renamed accidentally, generated incorrectly or damaged. It may also come from an untrusted source using a misleading extension. Renaming it again is not a dependable repair because the warning concerns the file's internal structure, not just its visible name.
A mobile app can also be the limiting factor. Desktop Excel, Excel for the web and Excel mobile apps do not provide identical support for every format or feature. If a workbook opens read-only or fails to open on a phone, test it in the desktop application before concluding that the file itself is broken.
Choose the output format by what the recipient must do
Preserve the original file before converting it. A conversion can remove unsupported features, and repeated movement between spreadsheet ecosystems can gradually alter formulas, formatting or workbook behavior. Work from a copy when the source contains macros, complex charts, external data connections or carefully controlled print layouts.
Use the following sequence to choose a safe output:
- Identify the real format. Check the extension and open the file with software that officially supports it.
- Decide what must survive. List whether the recipient needs formulas, multiple sheets, macros, formatting, charts, editable values or only a visual record.
- Choose the receiving application. Find out whether the recipient uses Excel, Google Sheets, Apple Numbers, LibreOffice Calc, a database system or only a document viewer.
- Export a copy in the appropriate format. Do not overwrite the only source file when the export may discard features.
- Open the exported copy independently. Check it as the recipient will see it rather than relying on the source workbook still open in the original app.
- Compare important cells and pages. Verify totals, formulas, labels, dates, charts and print output before sending the file.
For continued spreadsheet editing, XLSX is usually the safest general-purpose choice when the workbook does not require macros. Use XLSM when the recipient uses a compatible version of Excel and needs the macros. Keep ODS when the document will remain in an OpenDocument workflow, or export an XLSX copy for recipients who work mainly in Excel.
Use CSV or TSV when the receiving system needs raw table data. During import, choose the delimiter, text encoding and data type for sensitive columns instead of accepting every automatic guess. Product codes, telephone numbers, postal codes and long identifiers often need to be imported as text so their original characters remain intact.
Use PDF when the recipient only needs to read, approve, archive or print the spreadsheet. PDF preserves a fixed page presentation rather than spreadsheet behavior, so formulas cannot recalculate and cells are not intended for ordinary workbook editing. Before producing the PDF, check the print area, page orientation, paper size, repeated header rows, scaling and page breaks. A worksheet that looks correct in its grid can still produce cut-off columns or dozens of nearly empty pages.
For an Apple Numbers file, export an Excel copy when the recipient needs editable spreadsheet content in Excel. Export CSV or TSV when only table values are required. Export PDF when the layout is final and editability is unnecessary. Keep the original Numbers file because objects or features specific to Numbers may not have direct equivalents in the exported version.
For a Google Sheets document, downloading an XLSX copy usually gives Excel users the most useful editable version. Downloading CSV creates a separate file for one sheet and discards the rest of the workbook structure. A PDF download is more appropriate for a report whose page appearance matters more than its formulas.
No single spreadsheet format is best for every purpose. The safest choice follows the task: preserve the native workbook while it is being edited, exchange data in a delimited text format only when workbook features are unnecessary, and create a PDF copy when the recipient needs a stable document rather than a live spreadsheet.
Source: Excel format definitions, compatibility behavior and feature-loss guidance from File formats that are supported in Excel, Open XML Formats and file name extensions, Excel formatting and features that are not transferred to other file formats, and A file is in a different format than its extension indicates in Excel, Microsoft Support; CSV structure from RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) Files, RFC Editor; ODS identification from Open Document Format for Office Applications Version 1.3, OASIS Open; Numbers compatibility and export guidance from Import an Excel or text file into Numbers on Mac and Export to other file formats in Numbers on Mac, Apple Support; Google Sheets import, editing and download guidance from Use both Excel and Sheets: Best practices, Google Docs Editors Help; and LibreOffice format support from Using Microsoft Office and LibreOffice and XML File Formats, LibreOffice Help. Page last checked 2 October 2026.