How do I open ODT, ODS and ODP files without LibreOffice?

Somebody sends you a file ending in .odt. You double-click it and Windows asks what to open it with. Nothing on the list works.

You are not missing anything obvious. These are OpenDocument files, and the reason they are awkward has more to do with history than with the format being unusual.

What these files are

OpenDocument Format is an open standard for office documents, published as an international standard and used by LibreOffice, OpenOffice, Google Docs on export, and a long list of government and public-sector systems in Europe and elsewhere.

Three extensions cover almost everything you will meet:

Underneath, each is a ZIP archive containing XML. Structurally the same idea as a .docx. They are not obscure, damaged, or a trick. They are simply from a different office suite than the one on your machine.

Why Word and Excel are unreliable with them

Modern Word and Excel can open ODF files. Whether they open them well is a different question.

Support is real but partial: the two formats express things differently, and anything without a clean equivalent gets approximated. In practice that means tracked changes, complex tables, embedded charts and unusual styles are where it goes wrong. Simple documents come through fine; the ones you actually need to be careful with are the ones most likely to shift.

Then there are the machines where the question does not arise: a work laptop with no admin rights, a borrowed computer, a phone, a public terminal. You cannot install LibreOffice, and Word may not be there either.

The straightforward answer

Convert it to PDF. A PDF opens in every browser on every device with nothing installed, and it is a faithful record of the document's layout with the fonts embedded.

• ODT to PDF for text documents
• ODS to PDF for spreadsheets
• ODP to PDF for presentations

This is the right answer whenever your goal is to read the document, print it, forward it, or file it. It is the wrong answer if you need to edit it, and it is worth being clear about which of those you actually need before converting.

What survives, per file type

ODT. Text, headings, lists, tables, images, footnotes and page breaks all come across. What you lose is editability and anything interactive. Tracked changes become either invisible or permanently applied, depending on how the document was saved.

ODS. Every sheet becomes pages. This is the one that needs a thought before you convert: a spreadsheet has no natural page size, so a wide sheet has to be split across pages or scaled down. Check the result and, if a sheet is genuinely wide, consider whether landscape or a narrower column selection would read better. Formulas are gone: you get the values they produced, which is usually what a reader wants anyway.

ODP. One slide per page, exactly as the deck would print. Animations and transitions do not exist in a PDF, so a build that revealed four bullets one at a time becomes one page with four bullets.

If you need to edit rather than read

Two honest options.

Install LibreOffice. It is free, it is the native application for these files, and it opens them perfectly because the format is its own. If you can install software, this is simply the correct answer and no conversion beats it.

Use an online office suite. Google Docs and similar can import ODF. Expect the same approximation problems as Word, for the same reasons.

A practical rule

Ask what you are going to do with the file in the next ten minutes.

Reading, checking a figure, printing it, sending it on, keeping it for the record. Convert to PDF and move on.

Rewriting a section, changing formulas, re-presenting the deck. Get the native application, or ask the sender for a .docx, .xlsx or .pptx. That request is not unreasonable, and every ODF application can export those formats in one step.

Where these files come from

Knowing the source usually tells you whether to convert or to ask for a different format.

European public bodies. Several countries mandate open formats for government documents, so forms, guidance and templates arrive as ODT. If it is a form you have to fill in, you need an application, not a PDF.

LibreOffice and OpenOffice users. These save as ODF by default, and plenty of people have never changed that setting. If a colleague sent it, asking for a .docx takes one message and costs them one click.

Google Docs exports. Docs offers ODF alongside Microsoft formats, and somebody in a hurry picks the wrong one. Same fix.

Older archives. Public-sector document stores from the 2010s are full of ODF. Nobody is going to re-export those, so converting is the answer.

Asking for a different format is not rude

There is a reflex against asking a sender to redo something. It is worth resisting here, because for them it is genuinely trivial: File, Save As, pick Word, send. Ten seconds.

Compare that to converting, discovering the tracked changes did not survive, and going back and forth about which version is current. The ask is smaller than the workaround.

The exception is a document that is deliberately in an open format (a government form, an archival record) where ODF is the point and there is nothing else to send.

One thing to check after converting a spreadsheet

Open the PDF and look at the last column on the right of each page.

A wide sheet is either scaled down or split across pages, and the failure people miss is a final column that was cut off entirely rather than moved to a second page. It is invisible unless you know the sheet had, say, eleven columns and you count ten.

If a column is missing, convert again in landscape, or hide the columns you do not need before exporting.