"My formatting looks weird in Excel!"
The Fix: Microsoft Excel sometimes reads open standards poorly. If it must look perfect in Excel, open the ODS in LibreOffice and click "Save As" -> Excel (.xlsx) before sending it.
ODS: OpenDocument Spreadsheet
The open spreadsheet standard.
SpreadsheetsOpenOfficeLibreOfficeSpreadsheets
Explore the cross-platform, open source standard for managing tabular data and complex spreadsheets.
FILE FORMAT GUIDE
Master The .ODS File.
Learn what an OpenDocument Spreadsheet is, why it keeps your data safe, and how to use it without paying for expensive software.
A
B
C
D
Data
150
Open
Source
Free
Yes
Fast
Safe
What is an .ods file?
1
It is a Spreadsheet
It holds rows and columns of data, math formulas, and charts. It works exactly like a regular Excel file.
2
It is Open
ODS stands for OpenDocument Spreadsheet. The rules to make it are public. No single company owns it.
3
It is Free
Because it is open, many free programs use it as their main format. You do not have to pay to view your own data.
A Secret ZIP Folder
Here is a fun fact: an .ods file is actually just a ZIP folder in disguise.
If you change the name of the file from budget.ods to budget.zip, you can open it like a folder. Inside, you will find simple text files holding your data. This is why ODS files are so safe; they are just simple text packed together.
budget.ods (or .zip)
content.xml (Your actual text & numbers)
styles.xml (Your colors & fonts)
meta.xml (Author name & date)
/Pictures/ (Images you added)
ODS vs. Excel (XLSX)
| Feature | .ODS (OpenDocument) | .XLSX (Microsoft Excel) |
|---|---|---|
| Who owns it? | Nobody (Public Standard) | Microsoft |
| Cost to create software for it | Free | Complex rules |
| Best used for | Keeping data forever | Working inside big companies |
| Formulas support | Supports almost all math | Has some exclusive math functions |
Best Tools to Open ODS Files
LibreOffice Calc
#1 CHOICE
This is the best program for ODS. It is 100% free and saves in ODS by default.
Google Sheets
BEST FOR WEB
You can drag and drop an ODS file into your Google Drive to view and edit it online instantly.
Microsoft Excel
COMMERCIAL
Modern Excel can open ODS files. Sometimes complex charts might look a little different.
Apple Numbers
MAC USERS
Mac computers can open ODS files using the built-in Numbers app, though it converts them first.
What Can You Put In An ODS File?
Complex Formulas
From simple addition to deep financial math. If you can calculate it, ODS can store it.
Visual Charts
Create pie charts, line graphs, and bar charts to make your numbers easy to understand.
Rich Formatting
Change text colors, make cells bold, add borders, and highlight important data.
Multiple Worksheets
Keep your whole year of data in one file by using tabs at the bottom of the screen.
Top 3 Must-Know Formulas
ODS files use the exact same formula language as Excel. You type an equals sign
= to start doing math.
SUM
Adds a bunch of numbers together.
=SUM(A1:A10)
VLOOKUP
Finds a value in a large list.
=VLOOKUP(105, A1:B50, 2, 0)
IF
Checks a rule and gives an answer.
=IF(B2>100, "Good", "Bad")
The Magic of Pivot Tables
Imagine you have a list of 10,000 sales records. A Pivot Table (sometimes called a Data Pilot in open-source tools) can summarize that massive list into a small, neat table in three clicks—zero math required.
RAW DATA (10,000 Rows)
Shirt | Blue | $20
Pants | Red | $40
Shirt | Blue | $20
Socks | Red | $10
PIVOT TABLE SUMMARY
Blue Items Total: $40
Red Items Total: $50
Conditional Formatting (Auto-Colors)
You do not need to manually color cells. You can tell your ODS file to color things automatically based on rules.
- Make negative numbers red.
- Make tasks marked "Done" green.
- Highlight blank cells yellow so you do not forget them.
-500
1200
-10
400
0
3000
Stop Typos with Dropdown Menus
Data Validation is a feature that restricts what users can type into a box. Instead of letting someone type "Yes", "yes", "Y", or "Yeah", you can force them to pick from a clean list.
Select Status
Pending
Pending
Approved
Rejected
Printing Without Crying
Spreadsheets are famous for printing terribly. You click print, and it gives you 400 blank pages. Here is how to fix that in an ODS file:
1. Set Print Area
Highlight only the cells you want. Go to Format > Print Ranges > Define.
2. Fit to Page
Go to Format > Page Style > Sheet. Change the scaling to "Fit print range to
width of 1 page".
Defined
Print Area
Print Area
Who Uses ODS Files?
Governments
They use it to save tax money on software licenses.
Schools
Students use it because open-source tools are completely free.
Privacy Fans
People who do not want big companies tracking their personal budgets.
How to Open an ODS File (Step-by-Step)
1
Get Free Software
Go to your web browser and search for "LibreOffice". Download and install it. It works on Windows, Mac, and Linux.
2
Find Your File
Locate the .ods file on your computer. It might be in your Downloads or Documents folder.
3
Double Click
Just double-click the file! LibreOffice Calc will open it automatically. You can now read, edit, and save your data.
Technical Limits & Capacity
1,048,576
Rows Per Sheet
1,024
Columns Per Sheet
That is exactly 1,073,741,824 individual cells of data allowed per worksheet tab!
Track Changes (Collaboration)
When sending an ODS file to a coworker, you can turn on Record Changes. This highlights exactly what they deleted and what they added, so they cannot sneakily change the budget.
Budget_V2.ods - Changes
Cell B4: Office Supplies
- $4,000
+ $5,500 Added by John
Bank-Grade Password Protection
You can lock an ODS file so no one can read it without a password.
When you click "Save As", just check the box that says "Save with password". The file is encrypted using strong AES encryption. If you lose the password, the file is gone forever. No company can unlock it for you.
How to Convert ODS Files
Sometimes you need to send your file to someone who does not know what an ODS file is. Here is how you change it into something else.
file.ods
File > Export as PDF
Best for printing or sharing a file that nobody can edit.
file.ods
File > Save As > .xlsx
Best for sending to a coworker who only uses Microsoft Office.
file.ods
File > Save As > .csv
Best for uploading simple data to a website or database.
Importing Messy Data (CSV to ODS)
If you download bank statements or website data, it usually comes as a raw, ugly .csv text file. You can open that file in LibreOffice to convert it into a beautiful ODS spreadsheet.
date,amount,store
2024-01-01,50.00,Target
2024-01-02,15.50,Starbucks
2024-01-01,50.00,Target
2024-01-02,15.50,Starbucks
Text Import Wizard Fixes It
FIXING PROBLEMS
"The file is corrupted or broken."
The Fix: Remember the secret ZIP trick! Change the file name from
.ods to .zip. Open the zip file. If you see a file called content.xml, your data is
safe. You can extract that text file to get your raw numbers back.
"My phone cannot open it."
The Fix: Install the free "Collabora Office" app or upload the file to your Google Drive app. Both will open it on your phone instantly.
Security Warning: Macros
Just like Excel files, ODS files can contain "Macros" (mini computer programs hidden inside the spreadsheet).
If you download an ODS file from a stranger on the internet and your program asks "Enable Macros?", always click NO unless you trust the person completely. A bad macro can act like a virus. LibreOffice disables these by default to keep you safe.
Automate with your own Macros
If you do the same boring task every day (like deleting blank rows), you can record a Macro to do it for you in one second.
Unlike Excel which only uses VBA, ODS files let advanced users write macros in popular, modern coding languages like Python or LibreOffice Basic.
# Example Python Macro
def clear_cells():
doc = XSCRIPTCONTEXT.getDocument()
sheet = doc.getSheets().getByIndex(0)
cell = sheet.getCellRangeByName("A1")
cell.setString("Cleared!")
doc = XSCRIPTCONTEXT.getDocument()
sheet = doc.getSheets().getByIndex(0)
cell = sheet.getCellRangeByName("A1")
cell.setString("Cleared!")
Future-Proof Your Life
Companies go out of business. Expensive software gets retired. But open standards live forever. Because the rules for .ods are public, programmers 50 years from now will still be able to build tools to read your data. If you want your family budget or business records to last a lifetime, use open formats.
LibreOffice Calc Cheat Sheet
ACTION
KEYBOARD SHORTCUT
Save File
Ctrl + S
Format Cells Menu
Ctrl + 1
Insert Current Date
Ctrl + ;
Start a Formula
=
More in this series
Master more skills with other tutorials from the Spreadsheets series.
Data Engineering
- DB: Generic Database File: The universal data container.
- SQLite: Portable Database: A database in a single file.
- SQL: Structured Query Language: The language of data.
- CSV: Comma-Separated Values: The universal data exchange format.
Spreadsheets
- NUMBERS: Apple Numbers Spreadsheet: Visual data storytelling.
- XLSM: Macro-Enabled Spreadsheet: Excel with automation power.
- ODS: OpenDocument Spreadsheet: The open spreadsheet standard.
- XLS: Legacy Excel Spreadsheet: The foundation of digital spreadsheets.
- XLSX: Modern Excel Spreadsheet: The data powerhouse.
Presentations
- ODP: OpenDocument Presentation: The open standard for slides.
- PPT: Legacy Presentation: The classic slide deck format.
- PPTX: Modern Presentation: The gold standard for slide decks.
Word Processing
- WPS: WPS Office Document: The lightweight contender.
- PAGES: Apple Pages Document: The designer's word processor.
- ODT: OpenDocument Text: The open text standard.
- DOC: Legacy Word Document: The classic document format.
- DOCX: Modern Word Document: The standard for office documents.
- RTF: Rich Text Format: The universal translator.
Digital Publishing
- TEX: LaTeX Document: The mathematician's choice.
- PDF: Portable Document Format: The digital paper standard.
Software Engineering
- TSX: TypeScript XML: The modern web component.
Markdown & Text
- MD: Markdown: The programmer's writer.
- TXT: Plain Text: The simplest file in the world.