How to Switch from Microsoft Office to LibreOffice Without Breaking Your Documents

LibreOffice opens Word, Excel and PowerPoint files well enough that most people never notice a problem. "Most" is the catch. The files that break are usually the ones that matter: the contract with tracked changes, the budget workbook with macros, the deck with a custom template. This guide shows how to switch in an afternoon, find those files before they find you, and know where LibreOffice still falls short.

What you'll end up with: LibreOffice set up for Microsoft file formats, your important documents tested, fonts and macros dealt with, and a safe way to share files with people who still use Office.

What you'll need

• LibreOffice 26.8.1 or 26.2.x, from libreoffice.org/download. 26.8.1 is the first bug-fix release of the newest line, and it fixes PowerPoint files that crashed Impress on open. If you're deploying for a team, 26.2 is supported until 30 November 2026, so plan the move to 26.8 within the next two months.
• Your ten most important documents (more on that in step 1).
• Your Office installation, kept until you're done. Don't uninstall anything yet.

Step 1: Test before you commit

Before changing any settings, run a small impact test, the same approach The Document Foundation recommends to organisations in its migration protocol.

1. Pick your ten most important or most complicated files: a long Word document with tables and tracked changes, your biggest Excel workbook, a PowerPoint deck with charts.
2. Open each one in LibreOffice (File > Open) and compare it side by side with the original.
3. Check tables, headers and footers, page breaks, tracked changes, charts and fonts.
4. Write down what breaks. This is your real to-do list.

LibreOffice's own documentation is upfront that complex files may need manual reformatting, in proportion to how complex they are. A plain letter will be fine. A 90-page report built on a heavily customised template might not be, and it's better to learn that now.

Step 2: Choose your default save format

Go to Tools > Options > Load/Save > General. (On macOS: LibreOffice > Preferences > Load/Save > General.) In the "Default file format and ODF settings" area, pick a document type, then pick the format LibreOffice should save it in.

Which format? The Document Foundation recommends OpenDocument (ODF) as your default because it renders correctly in any application that supports it, and keeping Microsoft formats for exchange only. We agree for your own archive. But if nearly everything you write goes to people using Word or Excel, set the default to DOCX, XLSX and PPTX and stop thinking about it. You can always override the format in the Save As dialog.

To convert an existing folder of old files in one go, use File > Wizards > Document Converter. It copies every Microsoft Office file in a folder to ODF in a destination folder you choose and leaves the originals alone.

Step 3: Fix fonts first

Most "LibreOffice broke my layout" complaints are really missing-font problems. If a document uses a font your computer doesn't have, LibreOffice substitutes another one with different letter widths, so lines wrap differently and pages reflow.

• LibreOffice ships free fonts designed to match common Microsoft ones. Carlito stands in for Calibri, Caladea for Cambria, and the Liberation family for Arial, Times New Roman and Courier New. If your files use those Microsoft fonts, they'll usually look right without you doing anything.
• For your own templates, switch to free fonts, such as ones under the SIL Open Font License, which TDF's migration protocol recommends for the same reason.
• If you send a document that uses unusual fonts, turn on Embed fonts in the document (File > Properties > Font). Some font licences restrict embedding, and LibreOffice reads those flags before it embeds anything.

Step 4: Decide what to do with macros

This is the one place where LibreOffice can't follow you. Microsoft's VBA macros don't run in LibreOffice because it uses a different macro language with different objects and methods. A limited set of Excel VBA can run if you switch it on, but don't plan around it.

Set your policy at Tools > Options > Load/Save > VBA Properties:

• Keep the macros untouched. LibreOffice stores the VBA code as commented text and writes it back when you save in a Microsoft format. If you only edit text, cells or images, the macros still work when the file returns to Office.
• Delete macros on load. This also protects you from macro-based malware in files you receive.

Before you rewrite anything, ask whether you still need it. The Document Foundation's advice is to discard unused macros and re-engineer only the ones that matter. Macros that do matter can be rebuilt in LibreOffice Basic or Python, and 26.8 lets you create and edit Python scripts straight from the Macro manager without installing an extension.

Step 5: Set up Calc for Excel users

Formula syntax. Calc uses its own syntax by default, which can be confusing if you live in Excel. Go to Tools > Options > LibreOffice Calc > Formula and choose "Excel A1" (or "Excel R1C1") in the Formula syntax list. Calc translates between the two when opening and saving.

Modern functions. Calc supports XLOOKUP, XMATCH, FILTER, SORT, SORTBY, UNIQUE, LET, SEQUENCE and RANDARRAY, so most workbooks built on Excel's newer functions will calculate correctly.

Pivot tables. Click a single cell inside your data, then choose Data > Pivot Table > Insert or Edit. Select only one cell, because Calc finds the full data range itself, and make sure the list has no empty rows or columns. 26.8 adds Calculated Fields to pivot tables, which closes one of the longer-standing gaps.

Charts. This is the weak spot. LibreOffice 26.8 can't display or edit Microsoft's newer chart types: box-and-whisker, funnel, Pareto, sunburst, treemap and waterfall. It does preserve them, so a file opened and saved in LibreOffice goes back to Excel intact, but you'll see a placeholder message instead of the chart. Region map charts only keep their type, not most of their data. If a workbook depends on those charts, keep editing it in Excel, or ask your Excel colleagues to avoid those chart types in shared files.

Features with no equivalent. Excel-only tooling such as Power Query has no counterpart in Calc, so workbooks built around it need a different approach.

Step 6: Make the interface familiar

If you're used to the ribbon, go to View > User Interface and pick the Tabbed layout. 26.8 improves it: each application gets its own background colour, the tabs carry category labels, and you can scroll them with the mouse wheel. The classic menu-and-toolbar layout is not going away, so choose whichever suits you.

Step 7: Share files safely

• If the other person only needs to read it, send a PDF. If you want them to be able to edit it in LibreOffice, use Hybrid PDF, which embeds an editable ODF copy inside a normal PDF. Anyone without LibreOffice just sees a regular PDF.
• If they need to edit it in Office, save as DOCX, XLSX or PPTX. Tracked changes are imported and exported, but check anything complicated before sending.
• File > Send can email a document in ODF, PDF or Microsoft format directly.

Common pitfalls

• Upgrade from 26.8.0. 26.8.1 fixes PowerPoint files that closed Impress on open, and improves how DOCX files handle table-of-contents hyperlinks, text alignment and line spacing.
• Real-time co-editing isn't in the desktop app. If your team lives in shared documents, you'll need a server-based option such as Collabora Online with Nextcloud, which is a separate product from the desktop suite.
• There is no AI assistant. LibreOffice 26.8 has no generative AI features and doesn't send documents anywhere. For privacy that's the point. If you rely on Copilot, that's a real change.
• Mixed environments cause most problems. The worst migrations run old Office and old LibreOffice side by side with no agreed format. Pick one exchange format and stick to it.

What you've got now

You've tested your hardest files, set your default formats, sorted fonts and macros, configured Calc for Excel habits, and settled on how to share. Keep your Office installation for a few weeks, and when nothing has made you reach for it, remove it.

LibreOffice won't be a perfect clone of Microsoft Office, and it isn't trying to be. For most documents it's a straight swap, for a few it needs a workaround, and for macro-heavy or chart-heavy workbooks it may never be the right tool. Know which of your files are which, and the switch is a lot less dramatic than it sounds.