How to Clean ODF Metadata in LibreOffice and OpenOffice Files

You just finished a sensitive report in LibreOffice, which is a popular open-source office suite used for word processing, spreadsheets, and presentations. You hit save, emailed the file to a client, and realized three hours later that the document still contained your internal notes, the total time you spent editing it, and even your real name hidden inside the code. It happens more often than you might think. Every time you type, delete, or format text in an OpenDocument Format (ODF) file-like .odt or .ods-you are leaving behind a digital trail of breadcrumbs.

Unlike Microsoft Word's proprietary formats, ODF files are essentially transparent ZIP archives filled with XML code. This makes them great for interoperability but risky for privacy if you don't know how to scrub them properly. Whether you are using LibreOffice or Apache OpenOffice, cleaning this metadata isn't as simple as hitting one "Delete History" button. You have to dig into several menus to ensure no personal data slips through.

Why ODF Metadata Matters for Your Privacy

Metadata is data about your data. In an ODF file, it tells the story of who created the document, when it was edited, and on what computer. While this sounds harmless, it can be problematic. If you share a draft contract, a resume, or a research paper, you usually want the recipient to see only the content you intend them to read. You likely do not want them to see that you spent forty-five minutes rewriting a specific paragraph because you were unsure of the legal wording, or that the initial creator field lists your home address.

The OpenDocument Format standard, managed by OASIS, stores this information in specific XML files within the package. The most critical file is meta.xml, which holds core properties like author names and creation dates. Another file, content.xml, contains the actual text but also hides tracked changes and comments. Understanding where this data lives helps you understand why simply saving the file doesn't erase the past edits.

Step-by-Step: Cleaning Metadata in LibreOffice Writer

LibreOffice does not have a single "Inspect Document" button like Microsoft Office does. Instead, you need to perform a manual sweep across different settings. Here is the most effective workflow to sanitize an .odt file before sharing it.

1. Clear User Data Settings: Go to Tools > Options > LibreOffice > User Data. Here you will see fields for your name, initials, and company. If these contain your real identity, change them to generic placeholders like "Author" or leave them blank. This prevents new documents from automatically tagging your real name.
2. Reset Document Statistics: Open your target file. Go to File > Properties. Click the General tab. You will see a "Reset" button. Clicking this clears the total editing time and revision count. Uncheck the box labeled "Apply user data" if you want to ensure the current profile's name isn't stamped onto the document properties during this save.
3. Wipe Description Fields: Still in the Properties window, switch to the Description tab. Delete anything in the Title, Subject, Keywords, and Comments fields. These are often filled out accidentally or left over from templates.
4. Remove Custom Properties: Click the Custom Properties tab. If you see any custom fields added by previous software or macros, delete them. These can sometimes contain project codes or internal identifiers.

After completing these steps, click OK and save the document. This removes the high-level metadata visible in the file explorer, but there is still hidden content inside the document structure itself.

Handling Hidden Content: Changes, Comments, and Versions

Metadata cleaning is useless if you leave behind a trail of edits that reveal your thought process. Tracked changes and comments are stored directly in the content.xml file and travel with the document unless explicitly removed.

• Accept or Reject Changes: Go to Edit > Changes > Accept or Reject. Review every change. If you want a clean final version, accept all changes so they become part of the main text without showing the markup. If you want to hide that a change was ever made, reject them. Do not just turn off tracking; existing marks remain visible to anyone who opens the file.
• Delete Comments: Comments often contain casual remarks, internal jokes, or sensitive feedback. Right-click each comment bubble and select "Delete." There is no bulk-delete option for comments in the standard interface, so you must remove them individually.
• Check for Hidden Paragraphs: Go to View > Formatting Marks and ensure hidden paragraphs are visible. Sometimes users hide text instead of deleting it. If you see any hidden sections, delete them manually.
• Purge Embedded Versions: LibreOffice allows you to save multiple versions of a document within the same file. Go to File > Versions. If you see older snapshots listed, delete them. These old versions may contain earlier drafts with sensitive information that you thought you had discarded.

Cleaning Spreadsheets and Presentations

The process for Calc, the spreadsheet component of LibreOffice, and Impress, the presentation tool, follows similar logic but has unique pitfalls.

In Calc (.ods files), pay close attention to hidden sheets. Go to Format > Sheet > Hide and check if any sheets are currently hidden. Right-click on sheet tabs at the bottom of the screen and select "Show" for any hidden ones. Often, people keep raw data, formulas, or backup calculations on hidden sheets. Once revealed, decide if those sheets should be deleted entirely before sharing the file. A recipient could easily unhide them and access data you didn't mean to share.

In Impress (.odp files), check for speaker notes. Notes are intended for the presenter but are included in the file. If your notes contain confidential context, delete them. Also, review the slide masters and layouts under Slide > Master Slide to ensure no default branding or internal logos remain embedded in the template structure.

Automating the Process for Batch Files

If you only send one or two documents a month, the manual method above works fine. But if you are a consultant, journalist, or researcher handling dozens of files, clicking through menus is inefficient and error-prone. Human error is the biggest risk here; it is easy to forget to check the "Versions" tab or miss a hidden sheet.

For batch processing, dedicated tools are necessary. Commercial software like BatchPurifier exists, but it requires installation and licensing. For users who prefer a lightweight, privacy-focused approach, browser-based utilities have emerged as a strong alternative. Tools like Vaulternal's document metadata remover allow you to strip metadata from ODF files (as well as DOCX and PDF) entirely within your browser. Because the processing happens locally via WebAssembly, the file never uploads to a server. This is crucial for maintaining confidentiality when dealing with sensitive drafts. You can drag and drop multiple .odt or .ods files, and the tool will scrub author names, editing times, and custom properties instantly.

Another option for technical users is the Metadata Anonymisation Toolkit (MAT2), a command-line tool available on Linux systems. MAT2 is powerful for automated scripts but has a steeper learning curve and lacks a graphical interface for quick visual verification.

Comparison: Manual vs. Automated Cleaning

Notice the distinction between browser-based tools that process files locally and traditional online services that upload files to a cloud server. When cleaning sensitive metadata, uploading the file to a third-party server defeats the purpose of removing traces. Always verify that the tool you use processes data client-side. This ensures that even while you are cleaning the file, the content itself remains private.

Preventing Metadata Leaks in the Future

Cleaning up after the fact is good practice, but prevention is better. You can configure LibreOffice to minimize metadata accumulation from the start.

Go to Tools > Options > LibreOffice > Security. Look for the option "Remove personal information on saving." Enable this checkbox. When active, LibreOffice will automatically strip user names from comments and changes and reset editing statistics every time you save the file. This setting significantly reduces the amount of residual data left in the document.

Additionally, regularly audit your User Data settings. If you work on multiple projects for different clients, consider creating separate profiles or clearing your user data fields before starting a new confidential project. This habit stops the leakage of your personal identity into professional documents before it begins.

Frequently Asked Questions