IT MigrationLinux & Open Source

LibreOffice vs. Microsoft Office: what really works — lessons from 50+ migrations

Can LibreOffice really replace Microsoft Office? After more than 50 migrations in German and Swiss companies, we know: for 90% of office users — yes, completely. For the remaining 10% there are workarounds. What works, what doesn't, and where the limits honestly lie.

Erdea SolutionsPublished on 5 min read

First of all: an honest assessment

LibreOffice is not a perfect Microsoft Office clone. Anyone expecting that will be disappointed. LibreOffice is an independent, mature office suite that is fully sufficient for the vast majority of office tasks — and in some areas is even better than Microsoft Office.

After more than 50 migrations in companies of different sizes, we can say: about 90% of employees no longer notice any difference after two weeks. The remaining 10% have specific requirements that need workarounds — or, in rare cases, Microsoft Office after all.

"To be honest, after a week I'd forgotten that I didn't have Word any more."

— Office manager, trade business, 8 employees, Zurich

Feature by feature — the honest comparison

AreaMicrosoft OfficeLibreOffice
Word processing★★★★★★★★★☆ — sufficient for 95%
Spreadsheets★★★★★★★★★☆ — basic functions identical
Presentations★★★★★★★★☆☆ — simpler, fewer animations
.docx/.xlsx compatibility★★★★★★★★★☆ — good; watch out for complex formatting
Macros (simple)✓ VBA✓ Basic (similar, not identical)
Macros (complex)✓ full✗ VBA macros have to be adapted
PDF export✓✓ very good, built in
Database moduleAccess (expensive)✓ Base (free)
Formulas & functions✓ extensive✓ almost identical
Pivot tables★★★★★★★★☆☆ — available, less convenient
Licence costsfrom €69/year/user€0 — forever
GDPR / revFADP (revDSG)Telemetry data sent to MSNo data exchange

What really works without problems

These are the tasks for which we have never seen problems after a migration:

  • Writing letters, reports, quotations and contracts
  • Opening, editing and saving Word files (.docx)
  • Excel spreadsheets for accounting, stock and planning
  • Email templates and mail merge
  • Exporting PDF directly from any document
  • Creating invoices and forms
  • Simple presentations for customer meetings

Where the limits are — honestly

There are scenarios in which LibreOffice reaches its limits. You should know them before you migrate:

Complex VBA macros

Companies that work intensively with Word or Excel macros (VBA) have to adapt them. LibreOffice uses its own macro language (Basic), which is similar but not identical. Simple macros often run unchanged; complex ones have to be reworked. That takes effort — which we can help with.

Special PowerPoint animations

Presentations with elaborate animations and transitions sometimes look different in LibreOffice Impress than in PowerPoint. For companies that mainly create simple business presentations, this is not a problem. For design agencies or marketing teams with complex decks, it is relevant.

Microsoft 365 integration

Teams, SharePoint integration and real-time collaboration via Microsoft 365 naturally do not work in LibreOffice. As a replacement, we recommend Nextcloud with Collabora Online — it offers comparable features on your own infrastructure.

Very complex Excel models

Financial models with hundreds of formulas, nested IF functions and Power Query generally run in LibreOffice Calc — but Power Query and Power Pivot do not exist in LibreOffice. For standard SME spreadsheets this is not a problem. For specialised finance departments it may be relevant.

Practical tip: how to make the switch a success

The most important factor is not the software — it is the employees. This approach has proven itself in practice:

  • Step 1: install LibreOffice alongside Microsoft Office — one week to try it out
  • Step 2: open and check frequently used documents in LibreOffice
  • Step 3: settings: set the default save format to .docx/.xlsx
  • Step 4: 2-hour group briefing — we show the most important differences
  • Step 5: uninstall Microsoft Office — after 2 weeks of parallel use

Frequently asked questions about LibreOffice

Can I send LibreOffice files to customers who use Microsoft Office?

Yes — without any problems. We configure LibreOffice to save in .docx/.xlsx/.pptx format by default. Your customers see a normal Word/Excel file and notice no difference. For documents you only want to send, we generally recommend PDF — it looks identical on all devices.

Is LibreOffice also available for Windows, or only for Linux?

LibreOffice runs on Windows, macOS and Linux. This is particularly useful for step-by-step migrations: you can first introduce LibreOffice on Windows computers, get employees used to it — and only then switch to Linux. That way you avoid two transitions at once.

How long does it take employees to get used to it?

In our experience, 3–5 working days for initial familiarisation and 2–3 weeks to reach normal working speed. Employees who mainly handle standard tasks (emails, letters, simple spreadsheets) are often productive after one day. The biggest challenge is keyboard shortcuts and menu structures, which differ slightly.

Is there professional support for LibreOffice?

The LibreOffice community provides excellent free documentation. For companies, we take care of support — as part of an agreed flat monthly fee or billed by time spent. Practically all questions that arise after a migration are resolved in 5–15 minutes. After the first 2–3 weeks, support requests about LibreOffice become very rare in our experience.

Replacing Microsoft Office — we support you

A free analysis of your Office usage — we show whether and how LibreOffice suits your company. In person on-site in Baden-Württemberg and German-speaking Switzerland, including staff training.

Request a free initial consultation ›

Topics

‹ All articles