Module 6 · Office Suite — Word, Excel & PowerPoint replacements 25 min

The big worry: "If I switch to Linux, can I still open the Word document my boss just emailed me?" Yes. Two free programs on Linux open and save .docx, .xlsx and .pptx files perfectly: LibreOffice and OnlyOffice. Your colleagues won't be able to tell the file ever touched Linux. This module shows you which one to pick, how to set it up so it saves in Microsoft format by default, and the five things to know when you send a file back.

By the end of this module, you will:

  • Choose between LibreOffice (classic menus, already on Ubuntu) and OnlyOffice (ribbon UI, free download), and know when each one fits
  • Know which LibreOffice app replaces each Microsoft app: Writer = Word, Calc = Excel, Impress = PowerPoint, and which file extensions each opens
  • Open a .docx attachment from Thunderbird, edit it, save it back as .docx, and email it to a Windows-using colleague, for a full round-trip with no formatting loss
  • Turn off the "Use Word?" save pop-up permanently via Tools → Options → Load/Save → General
  • Open Excel spreadsheets in Calc: formulas (=SUM, =VLOOKUP, =IF), charts and conditional formatting all round-trip to .xlsx
  • Open PowerPoint decks in Impress: slides, animations, speaker notes; press F5 to present full-screen
  • Install the Microsoft core-fonts pack (ttf-mscorefonts-installer + Carlito + Caladea) so Linux renders Word docs at the exact same width as Windows
  • Use the Microsoft 365 web apps at office.com as an alternative: Word / Excel / PowerPoint in the browser, full-featured
  • View, export, annotate, sign, reorder and edit PDFs using Evince, LibreOffice, Xournal++, PDF Arranger and LibreOffice Draw
  • Know the 5% of files that don't round-trip cleanly (heavy VBA macros, exotic PowerPoint transitions, niche corporate fonts, real-time co-authoring) and the workaround for each

There isn't one Linux Office. There are two.

On Windows you get one Office, Microsoft's. On Linux you choose between two free programs. Both open Word, Excel and PowerPoint files, and both save back to Microsoft format. Same job, slightly different feel. Here is how to choose.

LibreOfficeOnlyOffice
Looks like…Old Office 2003, with a menu bar at the top, then a toolbarOffice 365, with the "ribbon" you know from modern Word/Excel
Made byThe Document Foundation (a free-software charity)Ascensio System SIA (a Latvian company)
Ships with Ubuntu?Yes, already installedNo, one-click install from Ubuntu Software
Best for…People who never loved the ribbon. Students. Lots of .odt work.People who use Microsoft 365 every day and want the same buttons in the same places
.docx round-tripExcellentExcellent (slightly closer to Microsoft because OnlyOffice uses the same Office Open XML core)
CostFree foreverFree (desktop version)

If you are not sure, start with LibreOffice. It is already installed, takes nothing extra, and 9 out of 10 people stay with it. If you spend all day in Microsoft 365 and miss the ribbon, install OnlyOffice too. You can keep both, opening each file with whichever you prefer.

Try it: LibreOffice vs OnlyOffice, same document, different UI Step 1 of 2
LibreOffice Writer — report.docx File Edit View Insert Format Styles Table Tools Window Help 📄 🗁 💾 │ ↶ ↷ │ B I U │ ¶ ☰ │ • 1. │ A̲ A̱ │ 🔍 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Q1 Project Report Alex Smith · 18 May 2026 In Q1 the team shipped four major features, hit the revenue target two weeks early, and onboarded six new enterprise customers. The full breakdown follows. Highlights • Shipped GNOME-Linux migration module • 4× growth in enterprise pipeline • Customer NPS up 12 points CLASSIC MENUS + TOOLBAR
LibreOffice ships with Ubuntu and uses a classic menu + toolbar interface — same as Office 2003.

The three apps inside LibreOffice: what each one does

The Microsoft appThe LibreOffice appFiles it opens and saves
Microsoft Word (documents)LibreOffice Writer.docx, .doc, .odt, .rtf
Microsoft Excel (spreadsheets)LibreOffice Calc.xlsx, .xls, .ods, .csv
Microsoft PowerPoint (slides)LibreOffice Impress.pptx, .ppt, .odp

Bonus apps you also get for free (do not worry about them on day one): Draw for diagrams, Base for simple databases (like Access), Math for typesetting equations.

Open a Word document from email: the five-minute walk-through

Your colleague sends a file called Q1-report.docx and you are on Linux. Here is the full round-trip, start to finish.

Try it: Open and edit a Word document from email Step 1 of 4
Thunderbird · Inbox FOLDERS 📥 Inbox 3 Sarah Hughes Q1 report — please review 📎 Q1-report.docx · 1.2 MB Q1 report — please review From: Sarah Hughes · 09:42 Hi Alex — here is the Q1 report. Could you make the suggested edits and send back by Friday? W Q1-report.docx 1.2 MB · Word document DOUBLE-CLICK → Linux opens .docx files in LibreOffice Writer.
Sarah emails you Q1-report.docx. Double-click the attachment in Thunderbird — Linux opens it in LibreOffice Writer.

Make LibreOffice save as Word by default: turn off the "Use Word?" pop-up

By default, LibreOffice nags you every time you save a Word document. Easy fix: Tools → Options → Load/Save → General. Three "Always save as" rows at the bottom of the panel:

  • Text document → set to Word 2007–365 (.docx)
  • Spreadsheet → set to Excel 2007–365 (.xlsx)
  • Presentation → set to PowerPoint 2007–365 (.pptx)

Click OK. From now on, Ctrl+S saves quietly in Microsoft format. No pop-up, no thinking. Your files round-trip exactly. (You can still pick .odt from Save As when you specifically want it.)

Why does it ask in the first place?

LibreOffice's own native format is .odt / .ods / .odp (Open Document, an international standard). It is a tiny bit safer for archival and shares perfectly between Linux/Mac/Windows people who all have LibreOffice. The downside: nobody else uses it. So most office workers set the default to Microsoft format and forget about it.

Try it: Set the default save format to Microsoft .docx / .xlsx / .pptx Step 1 of 2
LibreOffice Writer File Edit View Insert Format Styles Table Tools Window Help Spelling… Thesaurus… Word Count… AutoCorrect Options… Macros… Forms… Options… Alt+F12 CLICK
In any LibreOffice app: click Tools → Options (or press Alt+F12).

Spreadsheets: Calc opens Excel files with formulas and charts intact

LibreOffice Calc is the Excel replacement. Same grid of cells. Same column letters and row numbers. Same =SUM(A1:A10), =VLOOKUP, =IF, =COUNTIF, =AVERAGE. Calc speaks the exact same formula language as Excel. Open an .xlsx file and the formulas keep working, the charts keep drawing, the conditional formatting keeps highlighting.

In Excel you press…In Calc you press…Result
F2F2Edit the current cell
Ctrl+Shift+LCtrl+Shift+LToggle autofilter on a table
Ctrl+1Ctrl+1Format Cells dialog
Alt+Enter (inside a cell)Ctrl+EnterLine break inside a cell. The only common shortcut that differs.
F9F9Recalculate
Ctrl+Page DownCtrl+Page DownSwitch to the next sheet tab

One gotcha worth flagging: heavy Excel macros (the VBA scripting kind your accountant might use) sometimes do not translate cleanly. If your job depends on a complex .xlsm macro file, open it once on Linux to check it works before you commit. For 95% of spreadsheets (invoices, schedules, simple reports), no problem at all.

Try it: LibreOffice Calc, open an Excel file and the formulas keep working Step 1 of 1
Q1-budget.xlsx — LibreOffice Calc File Edit View Insert Format Sheet Data Tools Help 💾 ↶ ↷ │ B I U │ Σ ƒx │ 📊 chart │ 🔍 D8 ƒx =SUM(D2:D7) A B C D E 1 Item Budget Actual Variance 2 Engineering120,000115,4004,600 3 Marketing45,00052,800-7,800 4 Sales80,00082,100-2,100 5 Operations35,00033,2001,800 6 R&D60,00059,100900 7 Travel12,0009,8002,200 8 TOTAL 352,000 352,400 -400 📊 CHART · BUDGET vs ACTUAL Charts render the same as Excel — they round-trip cleanly when saved as .xlsx. Q1 Q2 + new sheet Sheet 1 of 2 · =SUM works · 352,400
Open an .xlsx file in Calc. The grid, the formulas (=SUM, =VLOOKUP, =IF), the conditional formatting and the charts all work — and round-trip back to .xlsx intact.

Slideshows: Impress opens PowerPoint files

LibreOffice Impress is the PowerPoint replacement. Open a .pptx, the slides look the same. Click Slide Show (or press F5), the presentation runs full-screen with your speaker notes on the second monitor. Same outline view on the left, same slide thumbnails. Save back to .pptx and your colleague gets exactly the deck you built.

Two small "but"s: some PowerPoint animations do not translate one-to-one (the simple fade-in / fly-in ones work; the elaborate "morph" transitions sometimes simplify). And a handful of Microsoft-only fonts (e.g. Calibri Light, Cambria) are not on Linux by default. See the font tip below.

Try it: LibreOffice Impress, open a .pptx and present with F5 Step 1 of 1
Q1-deck.pptx — LibreOffice Impress File Edit View Insert Format Slide Slide Show Tools Help 💾 ↶ ↷ │ T B I │ + slide │ ▶ F5 present │ 🎬 transitions SLIDES Q1 review Cover 1 Highlights • Migration • 4× pipeline • NPS +12 2 📊 Chart 3 + new slide Q1 Highlights A great quarter for the team • Shipped Windows-to-Linux migration module • 4× growth in enterprise pipeline • Customer NPS up 12 points • 6 new enterprise customers onboarded NOTES Mention the customer NPS jump came after migration shipped — direct causation, not coincidence.
Open a .pptx in Impress — slides, fonts, layout intact. Slide thumbnails on the left, speaker notes at the bottom, press F5 to present full-screen. Save back to .pptx and your colleague gets exactly the deck you built.

Microsoft fonts: the one easy install that fixes most "looks different" complaints

If you open a Word document and the text reflows ever so slightly, it is almost always because Linux does not have the Microsoft font the doc was using (Calibri, Cambria, Arial, Times New Roman). Linux substitutes a similar free font, which is nearly the same width, but not quite, so a heading might wrap differently. The five-second fix:

Try it: Install the Microsoft core-fonts pack to make Linux render Word docs at the exact same width Step 1 of 3
App Centre (Ubuntu Software) mscorefonts A Microsoft Core Fonts Arial · Times New Roman · Verdana · Calibri-equivalent (Carlito) · Cambria-equiv (Caladea) Ubuntu (multiverse) · font pack Install No terminal needed — search, then click Install. App Centre downloads the fonts plus the Calibri- and Cambria-equivalent metrics. (Carlito and Caladea match Calibri/Cambria width exactly.) [next: accept the Microsoft licence on the blue screen →]
Open App Centre (Ubuntu Software), search mscorefonts, and click Install on Microsoft Core Fonts.

Need the Microsoft 365 web apps? They work too.

If your company gives you a Microsoft 365 subscription, you can use the web versions of Word, Excel and PowerPoint on Linux. Go to office.com, sign in, click Word (or Excel or PowerPoint). Full-featured editing in the browser, same as on Windows. The only thing you cannot do in the browser is open files that are not already in your OneDrive (you would upload them first).

Tip: in Firefox or Chrome on Linux, right-click the tab and pick "Pin Tab". Word/Excel/PowerPoint live as pinned tabs the way they live as taskbar icons on Windows. Or "Install" the PWA (browser menu → "Install Office") to get a real dock icon.

PDFs: view, fill, sign, edit, combine

Almost every office document gets exported to PDF eventually: to send, to sign, to archive. On Linux, the everyday PDF actions are covered by a handful of small apps. Most are already installed.

What you want to doLinux appNotes
Read a PDFDocument Viewer (Evince)Pre-installed. Double-click any .pdf in Files; it opens. Same key shortcuts as Acrobat Reader: Ctrl+F search, Ctrl+P print.
Export ANY document to PDFFile → Export as PDF (in LibreOffice) or Ctrl+P → Print to File (in any app)Built in. No extra software needed.
Annotate: highlight, sticky notesXournal++Install from App Centre (search “Xournal++”). Highlights, freehand notes, stamps. Saves back as PDF.
Fill in a PDF formFirefox (built-in form filler) or Xournal++Drag the PDF into Firefox, fill it in, save back out.
Sign a PDFXournal++ → Insert image of signatureTake a photo of your signature on white paper, crop it, drop it onto the doc. Save as PDF. Done.
Combine / split / reorder pagesPDF ArrangerInstall from App Centre (search “PDF Arranger”). Drag-and-drop pages between PDFs.
Edit text inside an existing PDFLibreOffice DrawOpen the PDF in Draw (yes, Draw, not Writer). Most text becomes editable. Save back as PDF via Export.
Compress a big PDFps2pdf -dPDFSETTINGS=/ebook in.pdf out.pdfCommand-line one-liner. Cuts file size 50–80% on scan-heavy docs.
Try it: PDF toolkit on Linux: view, export, annotate, reorder, edit Step 1 of 5
Document Viewer — contract.pdf ⌕ search · ⬇ download · 🖨 print · ▤ thumbnails · ⊞ zoom 1 / 5 PAGES 1 2 3 4 Service Agreement This agreement is between Customer Co. and Supplier Ltd. for the provision of cloud services from 1 June 2026 to 31 May 2027. 1. Scope The Supplier will provide hosting, monitoring and support to Customer Co's production environment as detailed in Schedule A. 2. Fees Monthly fees of GBP 8,500 invoiced in advance, payable within 30 days. See Schedule B for additional usage charges.
View: Document Viewer (Evince) ships pre-installed. Double-click any .pdf in Files; it opens. Ctrl+F search, Ctrl+P print.

Things that do NOT round-trip perfectly: the short, honest list

Being straight with you. For 95% of office work (letters, reports, school essays, invoices, simple spreadsheets, regular slide decks), no difference at all. The 5% that does not translate perfectly:

  • Heavy VBA macros in .xlsm/.docm files. Some basic ones run; complex ones do not. If your accounting workflow depends on a 2,000-line Excel macro, test it on Linux before you switch, or keep one Windows machine just for that file.
  • Fancy PowerPoint transitions (Morph, 3D, certain camera-zoom effects). Simple fades, wipes and fly-ins all work fine.
  • Microsoft-only fonts not in the core-fonts pack. Most documents are fine after you install the fonts above. Some exotic corporate fonts may need to be manually copied across from your old Windows machine to ~/.fonts/.
  • Co-authoring with a colleague in real time in .docx via the desktop apps. For real-time co-edit, use the web version of Word at office.com in your browser, or Google Docs.

The safe rule: if your job depends on a specific super-complex Office file, open a copy of it on Linux before you commit to the switch. For everyone else (students, regular office workers, freelancers), LibreOffice and OnlyOffice handle every document you are likely to send or receive.