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
- ODS vs XLSXODS is the open spreadsheet standard of LibreOffice; XLSX is the default Excel workbook. Compare compatibility, features, openness and archiving, and when to send a PDF instead.
- XLSX vs CSVXLSX keeps formulas, formatting and several sheets; CSV keeps only values in plain text. Compare them for data exchange, imports, reports and PDF conversion.
PDF terms explained
- Table extractionTable extraction turns tables printed in a PDF into rows and columns you can edit in a spreadsheet. Learn how it works, its limits and how to check results.
- Embedded fontsAn embedded font is stored inside the PDF so the text looks the same on every device. Learn about font subsets, missing fonts and why archives require embedding.
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.