Guide to migrating from proprietary formats to ODF

In the digital world, document formats are essential. Proprietary formats such as Microsoft Word’s DOCX or Excel’s XLSX dominate the workplace, but at the same time they lock users into a specific vendor and its business strategies, which tend to exploit users to the maximum in every way. The Open Document Format (ODF) offers an open, standard alternative that protects users and their privacy, promotes interoperability, long-term access and data ownership.

Migrating documents from proprietary formats to ODF is the solution, and although vendors who rely on proprietary formats – not only Microsoft, but also its freeware clones such as OnlyOffice or WPS Office – do everything they can to prevent it, it is very easy and represents a fundamental step forward for users in terms of privacy and digital sovereignty (i.e., ownership of their own content).

This guide breaks down the migration process to make the transition smooth, efficient and sustainable, both at the individual level (where problems are virtually non-existent) and at the enterprise level, where problems exist due to the lock-in strategies of proprietary formats.

Step 1: Understand ODF and its advantages

  • No dependence on a single vendor: freedom to use any compatible software
  • Better long-term accessibility, robustness and stability of storage
  • Transparency and security, thanks to full compliance with open specifications
  • Better interoperability between platforms and tools

Step 2: Document inventory to define conversion priorities and estimate the effort required for migration

  • Identification of file types (DOCX, XLSX, PPTX) and their number
  • Analysis of documents to distinguish between active (used periodically) documents, those that can be archived and obsolete documents
  • Analysis of documents with complex formatting or embedded multimedia content

Step 3: plan the migration workflow

  • Convert documents in bulk or gradually as needed?
  • Pilot phase with a small group of users to identify any issues with the documents before the mass conversion
  • User training on the migration and creation of a support service for conversions and backup management

Step 4: Converting documents to ODF format

  • Use the LibreOffice export function (‘Save As’)
  • Use batch conversion tools for large volumes (LibreOffice command line scripts)
  • Validate converted files to ensure formatting and data integrity
  • Back up original files until migration is successfully completed

Step 5: Monitoring the migration

  • Updating internal policies to make ODF the default format for document creation and sharing, and to prevent a return to proprietary formats
  • Monitoring user feedback and trends in document creation, and resolving issues in a timely manner
  • Integrating ODF support into enterprise software platforms, and using automatic conversions where possible

Conclusion

Migrating from proprietary formats to ODF is a strategic move, both individually and for businesses, towards openness, content control and document protection for the future. In a business environment, it requires careful planning and user involvement, but the benefits in terms of flexibility, interoperability and cost savings are well worth the effort.

Best practices for creating and editing Open Document Format (ODF) files

Adhering to these guidelines can enhance productivity and guarantee that documents remain consistent, robust and accessible over time, irrespective of the platform.

Firstly, use an editor such as LibreOffice that natively supports the format without conversion. This preserves the nuances of the ODF XML structure, supports all its features and reduces the risk of formatting issues or data loss. It also ensures that documents are fully compatible with the ISO standard.

Secondly, use an up-to-date version of LibreOffice to benefit from continuous improvements in ODF feature management, avoid bugs that could cause file corruption (a rare event thanks to the robustness of the ODF format, but still possible) and enjoy the highest level of security in file management.

Thirdly, use LibreOffice document templates and styles for all elements, such as headings, fonts, paragraphs, and tables, to ensure consistent formatting throughout the document. This allows you to make global changes quickly by changing the style rather than each individual element, and improves accessibility, as screen readers and other assistive technologies rely on a consistent structure. This also results in smaller, more robust ODF files.

Creating and reusing LibreOffice templates is an excellent practice for companies that produce many similar documents (such as invoices or monthly reports). Once all the characteristics of the document have been defined, simply save it in ‘template’ format to obtain a blank copy with all repetitive elements already in place.

The fourth condition is to save and back up documents frequently and regularly. ODF files are compressed XML files, which makes them robust and reliable, but not immune to problems. In a business environment, it is advisable to use a cloud storage solution with a version history, such as Nextcloud, which allows you to revert to an earlier version of a file.

The fifth recommendation is to avoid overly complex formatting to ensure maximum compatibility when sharing ODF files with a diverse audience or converting them to other formats, such as Microsoft Office proprietary formats, because complicated layouts, embedded objects or macros may not work or appear differently.

It is recommended that you use basic styles and standard LibreOffice fonts (open source and available to all users), or fonts that can be installed by any user, independently of the operating system, even if backed by an End User Licence Agreement (such as Microsoft Aptos, which can only be downloaded from the Microsoft website). You should also avoid excessive use of tables or nested text boxes.

The sixth condition is to integrate multimedia content sensibly, optimising images or videos used in presentations to reduce their size without compromising quality.

The seventh and final condition is to always save the original file in ODF format, even when sharing with users who insist on using Microsoft Office’s proprietary format — thereby handing over ownership of their files to Microsoft. Once the document is finalised, save a copy in OOXML format and share this with Microsoft users.

Similarly, when receiving an OOXML document from a Microsoft user, immediately save a copy in ODF format for editing until the document is finalised and the OOXML copy can be shared again.

When sharing a document within a team, it is advisable to use comments to provide feedback instead of editing the body of the document, enabling change tracking so that changes can be reviewed before acceptance or rejection. Where possible, collaborate on a shared ODF platform based on LibreOffice technology and the cloud, such as Collabora Online.

Open standard formats such as ODF allow you to avoid dependence on a single supplier, maintain ownership and control of your documents, and future-proof your work — but only if used wisely. Following best practices will enable you to manage ODF documents more smoothly and conveniently without sacrificing any of the advantages of the ISO standard format.

What’s new in ODF 1.3 and 1.4

ODF ensures that documents remain accessible, portable, and free from restrictions. Now that version 1.3 has been widely adopted and version 1.4 is on the horizon, it’s time to have a look at the new features and upcoming releases.

ODF 1.3: What’s New

ODF 1.3 was finalised in January 2021 by OASIS. It introduced a number of long-awaited improvements, particularly in the areas of security, digital signatures, and document integrity.

1. Digital signatures and document security:

One of the most significant enhancements in ODF 1.3 was the formal specification for digital signatures:

  • It now supports XAdES (XML Advanced Electronic Signatures).
  • You can sign entire documents, individual parts (e.g. only spreadsheets), or even multiple sections.
  • Improved metadata provides information about who signed, when and under what circumstances.

This is a significant development for public administrations and organisations that require reliable document verification.

2. OpenPGP support for encryption

  • ODF 1.3 now offers optional OpenPGP-based encryption in addition to the traditional Blowfish method.
  • Higher cryptographic standards and better integration with tools such as GnuPG are also included.
  • It encourages key-based encryption for personal and business documents.

3. Change management:

  • The format now offers greater granularity for change management.
  • Supports change tracking in tables, which was previously a weak point.
  • Improves compatibility with editing tools that handle collaborative workflows.

4. Metadata:

  • Improved management of custom metadata fields using RDF.
  • Greater richness of semantic descriptions of content (e.g. for archival or academic purposes).
  • Encourages integration with deep graphs and linked data systems.

5. Other changes:

  • New chart types and charting features.
  • Improved text formatting options.
  • Improved compliance with accessibility standards.

ODF 1.3 introduced two new compliance modes: Strict, for clean documents that comply with the specifications, and Extended, which allows specific enhancements by a company for broader feature support.

What’s new in ODF 1.4

ODF 1.4 is still under active development, with the first drafts already implemented in the latest versions of LibreOffice. Although the specifications are not final, the following is planned:

1. Change tracking:

  • Support for tracking style changes (e.g. switching from bold to italic).
  • Better differentiation between insertions, deletions and formatting changes.
  • Change IDs and support for real-time conflict resolution for collaborative editing.

2. Charts:

  • More flexibility in charts, including custom colours, gradient fills, multiple axes and formatted data labels.
  • Better alignment with modern expectations and improved interoperability with Excel.

3. Accessibility:

  • Clearer semantics for assistive technologies.
  • Improved navigation for screen readers.
  • Structural tags for headings, lists and tables make documents easier to analyse programmatically.

4. Form controls:

  • More robust form field types, such as date pickers, drop-down menus and sliders.
  • Better interaction support for forms within spreadsheets and presentations.
  • Cross-platform consistency.

5. Improved spreadsheet features:

  • Native support for named ranges in the sheet.
  • Improved formula representation for functions in edge cases.
  • More complex conditional formatting rules.

6. Compatibility:

  • Mapping of Microsoft Office formats (DOCX, XLSX and PPTX) to reduce conversion issues.
  • Improved handling of embedded media and OOXML-style layouts.

Final considerations

ODF 1.3 represented a significant advancement in terms of security and interoperability. ODF 1.4 adds usability improvements, more modern features, and better alignment with current office suite trends.

With an increasing number of governments and organisations adopting open standards, the evolution of ODF is crucial. The focus is not on competing with Microsoft; it’s about ensuring that your documents remain yours.

Understanding ODF File Types: .odt, .ods, .odp, and Beyond

If you’ve ever wondered what those .odt, .ods, or .odp files are all about – or if you’ve stumbled across them and weren’t sure what to do – this post is for you.

.odt: The Open Document Text File

Think of .odt as the open counterpart to .docx. It’s the default file format for LibreOffice Writer. You can use it for everything from a quick grocery list to a dissertation.

What’s great about .odt is that it’s built on open standards. That means anyone can build software to read or write it without jumping through legal hoops. It also means you’re not tied to one company’s ecosystem, which is increasingly important when you think about long-term access to your own data.

Yes, you can open .odt files in Word – and yes, the formatting usually holds up pretty well. Not perfect, but usable.

.ods: Spreadsheets Without Strings Attached

Spreadsheets aren’t just for accountants anymore. Whether you’re managing a budget, tracking tasks, or planning a trip, you’re probably using rows and columns for something. .ods is the ODF version of .xlsx, and it’s handled by tools like LibreOffice Calc.

If you’re used to Excel, Calc will feel familiar enough. Basic formulas, charts, conditional formatting – it’s all there. Advanced Excel users might bump into limits (especially with macros or highly specific plugins), but for everyday work, .ods gets the job done.

And again, it’s open. Your data isn’t buried in a proprietary format you need a subscription to access five years from now.

.odp: Presentations Without PowerPoint

Then there’s .odp, the ODF format for presentations. It works like PowerPoint’s .pptx. You’ve got slides. You’ve got transitions. You’ve got bullet points. Even if you’re trying to build the next TED Talk with embedded video and flashy animations, it’s more than enough.

LibreOffice Impress opens and edits .odp files easily, and you can usually open them in PowerPoint too, though some visual effects might not translate perfectly. For most professional or academic presentations, it’s a reliable option – especially when you don’t know what software will be available on the receiving end.

Other File Types in the ODF Family

ODF isn’t limited to just text, spreadsheets, and slides. There are a few lesser-known formats worth mentioning:

  • .odg – for vector graphics and diagrams. Think flowcharts, not Photoshop.
  • .odf – confusingly, this one’s for formulas (as in math), used by LibreOffice Math.
  • Templates like .ott (text), .ots (spreadsheets), and .otp (presentations) make it easy to standardize layouts and branding across documents.

These formats are all part of the same ecosystem. They’re modular, open, and designed to work well together.

Why It Matters

It’s easy to dismiss file formats as a technical detail, but they shape who controls access to your work. When you rely only on proprietary formats, you’re tied to that company’s tools, updates, subscriptions and limitations. You’re renting your own documents.

ODF flips that script. It’s not just a format – it’s a philosophy. One that says your work belongs to you, and you should be able to access it any time, on your terms.

If you’re already using open-source tools, chances are you’re already working in ODF whether you realized it or not. If not, it’s worth considering – especially if you want to keep your documents open, portable and future-proof.

An artificially complex XML schema as a lock-in tool

A document format is a tool for sharing knowledge and, as such, should be as simple and accessible as possible in relation to the complexity of the document content itself. This remains true even when the format is based on an XML schema that is hidden from users when the document is displayed on screen.

Unfortunately, while an XML schema can be simple, it can also be unnecessarily complex, bloated, convoluted and difficult to implement without specific knowledge of its features. This is true even if the on-screen documents are identical. In this case, complexity is an intentional tactic used to lock users into a vendor, as is the case with the Microsoft 365 document format.

An XML schema comprises the structure, data types and rules of an XML document and is described in an XML Schema Definition (XSD) file. This tells the PC what to expect and checks that the data follows the rules. In theory, XML and XSD together form the basis of the concept of interoperability. However, in practice, an XML schema can be made so complex that it becomes a barrier rather than a bridge.

An “artificially complex” XML schema goes beyond the level of complexity needed to display even the most intricate content on screen. In fact, it is completely disconnected from the actual complexity of the content, to the extent that even a simple sentence such as “To be, or not to be, that is the question” becomes an inextricable sequence of tags that users cannot access.

This artificial complexity is characterised by a deeply nested tag structure with excessive abstraction, dozens or even hundreds of optional or overloaded elements, non-intuitive naming conventions, the widespread use of extension points and wildcards, the multiple import of namespaces and type hierarchies, and sparse or cryptic documentation.

In the case of the Microsoft 365 document format, the only characteristic not present is sparse or cryptic documentation, given that we are talking about a set of documents totalling over 8,000 pages. All the other characteristics are present to a greater or lesser extent, making life almost impossible for a developer trying to implement the schema.

To illustrate how this translates into a lock-in strategy, consider a railway system where the tracks are accessible to all, but the main train manufacturer imposes its own incredibly complicated control system. In theory, anyone could build a train compatible with the tracks, but the control system specifications are so convoluted that only the main train manufacturer can ultimately offer rail services.

The worst thing is that passengers don’t realise they are being held hostage by technical constraints that they cannot understand until ticket prices rise or the number of cities served declines. At this point, the main manufacturer can dictate its terms, which passengers are forced to accept.

This is very similar to what is happening in the world of information technology, where Microsoft is effectively forcing its customers to switch from Windows 10 to Windows 11 against their will. This switch has no technical justification and locks customers into using Windows 11 and Microsoft 365. This is because customers have completely ignored the problems that arise from using proprietary technologies.

If, over the years, the millions of Microsoft users who uncritically accepted a narrative that was credible to non-technical users but divorced from technological reality had taken a critical stance towards this monopoly, which would have raised doubts in any other sector, we would be in a very different situation today.

Instead, these users – including governments and supranational organisations – have allowed lock-in strategies, in which Microsoft 365’s artificially and unnecessarily complex XML document schema plays a fundamental strategic role, to become increasingly sophisticated and pervasive.

Therefore, if you are developing or choosing an XML-based system, bear in mind that complexity imprisons people, whereas simplicity and clarity set them free.

XML: a technology at the heart of our daily lives

In my last article, I mentioned XML several times, perhaps assuming that all users had a basic understanding of it. Rereading it, I realised that an introduction to XML was needed for non-technical users, those who use XML every day without realising it, when they open a document, check the weather, place or receive an order online, or issue a digital invoice. XML works silently behind the scenes.

But what exactly is XML and why should it matter to non-techies? I will try to explain it in simple terms.

XML stands for eXtensible Markup Language, a way of organising information in a format that is easy for both people and computers to understand, helping different applications communicate and exchange data using a common language. Put simply, XML is a digital container that clearly labels information.

For example, this is a shopping list in XML format:


<groceryList>
  <item>
    <name>Bread</name>
    <quantity>1 loaf</quantity>
  </item>
  <item>
    <name>Milk</name>
    <quantity>2 litres</quantity>
  </item>
</groceryList>

Labelling helps computers and software understand exactly what each piece of information means.

In a hyperconnected world like ours, where apps and systems share data, XML allows that data to move between very different systems, such as credit card management apps and online shops. Without a common language like XML, communication between these systems would be much more complicated and slower, or even impossible.

So, XML is integrated into most everyday activities, even though it is completely hidden from users:

  • All documents created by all office suites use XML, in some cases to facilitate transparency and interoperability, and in other cases to create a hidden layer of complexity with the aim of preventing transparency and interoperability.
  • All apps that provide weather forecasts obtain updates by reading XML data issued by weather agencies.
  • Almost all e-commerce applications use XML to manage communication between the website, the payment system, the bank and the shipping service.
  • All blogs and news sites use XML to automatically transmit new content to readers.

XML is clear and easy to read because it organises data in an orderly manner with labels that are understandable to both humans and computers; it is flexible, as it is not limited to a single type of information and can be customised for different scenarios, from cooking recipes to flight schedules; and it is compatible with all platforms.

To appreciate the value of XML, you don’t need to have a deep understanding of the language, just know that it exists and that – when used properly, as in the case of the ODF format – it has the potential to help users achieve and protect their digital sovereignty.

Of course, it is equally important to know that XML can be used in exactly the opposite way, as is the case with Microsoft 365’s OOXML format (and previously Office), to limit users’ digital sovereignty and perpetuate lock-in through artificial file complexity.

In summary, XML is a silent enabler that ensures that users’ apps, services and data all speak the same language.

The next time you open a document, check your favourite news site or follow an online delivery, remember that XML is working silently behind the scenes to ensure that everything runs smoothly. And try to imagine a digital world without XML, where a single company controls the data and, through it, the users.