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

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.

More document file extensions · all file extensions