AuraDoc
Sign inSign up

ODS: the open standard for spreadsheets

ODS stands for OpenDocument Spreadsheet. It is the native format of LibreOffice Calc and Apache OpenOffice Calc, and part of the OpenDocument standard maintained by OASIS and published as ISO/IEC 26300. An ODS file is a ZIP package of XML files that store the sheets, cell values, formulas, styles, charts and print settings. Microsoft Excel and Google Sheets can open and save it too.

Key facts

Extensions
.ods
Media type
application/vnd.oasis.opendocument.spreadsheet
Standard
OpenDocument (OASIS, ISO/IEC 26300)

Where it is used

ODS is common in public administrations, schools and organisations that use open-source office software, and some governments ask for open formats when documents are exchanged. People use it for budgets, timetables, inventories, price lists and any table that needs formulas.

Strengths

As an open, vendor-neutral standard, ODS can be read by many programs today and in the future without licence questions. It keeps formulas, several sheets, formatting and charts, and it is usually compact because the XML inside is compressed.

Limitations

Not every tool handles ODS as well as XLSX. Complex formulas, macros, pivot tables and conditional formatting may change slightly when the file is opened in Excel, and many web forms and business systems only accept XLSX or CSV.

Converting it to PDF

A PDF shows the spreadsheet exactly as it should be printed, without editable cells. Our ODS to PDF tool converts every sheet and follows the print range, orientation and scaling saved in the file, so set those in LibreOffice Calc before converting. Excel to PDF reads ODS files as well.

Getting it back from a PDF

To get a table back from a PDF, use PDF to Excel, which produces an XLSX file that LibreOffice Calc opens and can save as ODS. Formulas are not recovered, only the values shown on the page, and scanned pages have no text to read.

Convert with these free tools

Side-by-side comparisons

PDF terms explained

Guides that put it into practice

Common questions

Can Excel open ODS files?
Yes. Recent versions of Excel open and save ODS, although some formatting or advanced features may look different.
Is ODS or XLSX better for sharing?
XLSX is accepted by more systems; ODS suits open-source users and institutions that require open standards. For a copy that only needs to be read, send a PDF.
Why are some columns missing in my PDF?
They fall outside the print range or the page width. Adjust the print range or scale the sheet to fit the page in Calc, save the file and convert it again.

Other file formats

Need more than a quick fix?

AuraDoc is a document platform with OCR, AI search and summaries, and more than 60 PDF tools for teams. Try it free for 7 days.

Free tools for personal and professional use. This one runs on an isolated AuraDoc server: the file is deleted right after processing and never stored. Fair use and anti-abuse policy