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
| Area | Microsoft Office | LibreOffice |
|---|---|---|
| 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 module | Access (expensive) | ✓ Base (free) |
| Formulas & functions | ✓ extensive | ✓ almost identical |
| Pivot tables | ★★★★★ | ★★★☆☆ — available, less convenient |
| Licence costs | from €69/year/user | €0 — forever |
| GDPR / revFADP (revDSG) | Telemetry data sent to MS | No 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.
Topics
- IT Migration
- Linux & Open Source
- IT migration
- LibreOffice
- Linux
- Microsoft 365
- Open Source
- Windows
