What Is a .ODS File? (.ods, .fods)
A .ods file is a spreadsheet in the OpenDocument Spreadsheet format, the native format of LibreOffice Calc. It is an open international standard (ISO/IEC 26300) that stores sheets, formulas, charts and formatting. Microsoft Excel and Google Sheets can open and save ODS files, so you rarely need special software.
- Extension
- .ods, .fods
- Full name
- OpenDocument Spreadsheet
- Type
- Document file
- MIME type
- application/vnd.oasis.opendocument.spreadsheet
- Developed by
- OASIS (OpenDocument standard)
About ODS files
OpenDocument was developed by OASIS and standardized by ISO; ODS is its spreadsheet member, alongside ODT for text and ODP for presentations. Like XLSX, an ODS file is a ZIP package of XML files, and governments and organizations that require open formats often publish data as ODS.
Excel opens ODS files and can save in the format, and Google Sheets imports and exports it. Everyday formulas, formatting and charts usually survive the trip. Pivot tables, conditional formatting details and some charts can change, and macros do not transfer because LibreOffice uses Basic macros while Excel uses VBA.
If a spreadsheet will go back and forth between people using different apps, choose one format and stick to it; repeated conversion between ODS and XLSX gradually loses formatting. The rarely seen .fods variant is a single uncompressed XML file, useful for version control.
What ODS files are used for
- Spreadsheets made in LibreOffice Calc
- Open data published by governments and public bodies
- Organizations that standardize on open formats
- Exchanging spreadsheets without depending on Microsoft Office
How to open a .ods file
Windows
Open in LibreOffice Calc (free) or Microsoft Excel, which reads ODS files directly.
Mac
Use LibreOffice Calc or Excel for Mac.
Online / any browser
Upload to Google Drive and open with Google Sheets, or open in Excel for the web from OneDrive.
Linux
LibreOffice Calc is usually preinstalled and opens ODS natively.
How to convert a .ods file
To convert ODS to XLSX, open it in LibreOffice Calc and choose File > Save As with Excel 2007-365 format, or open it in Excel and save as Excel Workbook.
For CSV, use File > Save As > Text CSV in LibreOffice (one sheet at a time), or File > Download > CSV in Google Sheets.
Renaming .ods to .xlsx does not convert it, even though both are ZIP-based.
Changing the extension in the file name does not convert the file. See how to change a file extension for when renaming is safe.
Naming and renaming ODS files
- Include the dataset and period in published data (school-enrollment-2024-25.ods) since open-data portals host many similar files.
- When you convert to XLSX for colleagues, keep the same base name and note which one is the master.
- Avoid version names like final-final; use dates or v2, v3 so both LibreOffice and Excel users can tell the latest.
Renaming lots of .ods files? Use the free online bulk renamer for patterns and numbering, or try File Renamer AI to name each file from what is inside it.
Related file types
A .xlsx file is a Microsoft Excel workbook, the default Excel file extension since Excel 2007. It stores one or more worksheets of cells, formulas, charts, formatting and pivot tables in a compressed Office Open XML package. Related Excel extensions are .xlsm (macros), .xlsb (binary) and the older .xls.
A .xls file is a spreadsheet in Microsoft Excel's legacy binary format, the default for Excel 97 through Excel 2003. It stores worksheets, formulas, charts and formatting, but each sheet is limited to 65,536 rows and 256 columns. Many older systems and bank exports still produce .xls files today.
A .csv file is a plain-text table where each line is a row and commas separate the columns. It has no formatting, formulas or multiple sheets, which makes it the universal format for moving data between spreadsheets, databases, banking portals, CRMs and code. Any text editor or spreadsheet app can open it.
A .odt file is an OpenDocument Text document, the native word-processing format of LibreOffice Writer and Apache OpenOffice. It is an open, ISO-standardized format that stores text, formatting, images and tables in a ZIP package of XML files, and is often required by governments and organizations that prefer open standards.
Frequently Asked Questions
Can Excel open ODS files?
Yes. Excel opens and saves ODS files, though some advanced features may look different.
How do I open an ODS file for free?
Use LibreOffice Calc, or upload it to Google Drive and open it with Google Sheets.
Is ODS better than XLSX?
ODS is a fully open standard; XLSX is more widely used. Pick whichever your collaborators use to avoid conversion problems.