Office file compatibility on a Mac: what to check before sending

Every app that isn’t Microsoft’s can open a Word, Excel or PowerPoint file, and every one of them can change something on the way back. Usually it is small, like a line break in a new place. Sometimes it is a lost tracked change or a formula that now shows an error. This guide lists what tends to move, by file type, and gives a short test to run before you trust an app with a file that matters.

How each app handles an Office file

The biggest difference is whether an app works on the Office file itself or converts it to its own format and back.

How it saves an Office fileOld .doc, .xls, .pptExcel macros (VBA)Known weak spots
Pages, Numbers, KeynoteConverts it to Apple’s format; you export a new copy to send backOpened and convertedNot runNumbers lacks some Excel functions; Pages doesn’t keep every Word feature
Google Docs, Sheets, SlidesEdits it in Drive and saves it in the same format, or converts it to Google’s formatConverted; only .docx, .xlsx and .pptx are saved backNot supportedIn Google’s own editors, embedded charts and videos become pictures
LibreOfficeReads and writes Office formats; its own format is OpenDocument, and it can warn each time you save in anotherOpened and savedOnly in partSome newer Excel chart types, such as funnel and waterfall, aren’t shown, though they are kept
ONLYOFFICE Desktop Editors.docx, .xlsx and .pptx are its own formatsConvertedNot confirmedComplex Word layouts can move
Office AlternativeSaves in the same format and rewrites only the parts you changed.xls read only; .doc and .ppt don’t openKept in the file, never runCharts and SmartArt inside Word documents show as labelled boxes; slide animations don’t play

None of these reproduces every Word layout exactly. The table shows where to look first. For prices and offline use, see the comparison of Office alternatives for Mac.

Word documents: what to check

Page count and line breaks. If the document uses a font your Mac doesn’t have, the app puts in a substitute, and a slightly wider font pushes text onto the next page. Compare the page count with the original. If the sender used a font you can install, install it before editing.

Tracked changes and comments. These are the features most likely to be lost when an app converts a file. Before you edit, check that you can still see who changed what. If not, use an app that keeps them, or ask the sender to accept them first.

Table of contents and page numbers. In Word these are fields that update themselves. A converted file can keep the text and lose the field, so the contents look right but no longer update. Click an entry in the contents: if it doesn’t go to its heading, the field has probably become plain text.

Headers, footers and sections. A different first page, odd and even pages, or one landscape page in a portrait document all live in section settings. Check the pages where the layout changes.

Charts, SmartArt, equations and embedded objects. These are hard for every app. Some redraw them, some show a picture or a box instead. What matters is whether the object is still there when the Word user opens the file again.

Excel workbooks: what to check

Formulas. An app that doesn’t know a function shows an error, such as #NAME?, or keeps the last result Excel saved without recalculating it. Search the workbook for #NAME? and #REF! after opening it, then change one input and see whether the totals follow.

Macros, PivotTables and data connections. If the workbook depends on any of these, use Excel. Other apps keep or drop them, but can’t run or change them reliably.

Conditional formatting and drop-down lists. These usually survive, but newer Excel rules are sometimes kept without being shown. Check a few cells.

Dates and leading zeros. These go wrong mostly in CSV files; see opening a CSV file on a Mac.

PowerPoint presentations: what to check

Animations and transitions. Other apps support fewer effects. Some play a simpler version, some show each slide in its final state. Find out before you present.

Text that no longer fits. A substituted font can make a title wrap to two lines or overflow its box. Page through every slide at full size.

Video, audio, charts and notes. Check that media still plays, that charts are still charts and not pictures, and that the speaker notes are still there.

A five-minute round-trip test

Run this once with a real file before you rely on an app:

  1. In Finder, select a real document you have received and choose File > Duplicate. Keep the original untouched.
  2. Open the copy in the app you want to test, change one word, and save it in the same format.
  3. Look at the original and the edited copy one after the other. Quick Look (select the file in Finder and press Space) is enough for a first look. Better still, open both in Word, Excel or PowerPoint for the web, which are free with a Microsoft account: they are the closest you can get to what the Office user will see without Office.
  4. Compare the page count, a page with a table, a page with a picture, the headers and footers, and any tracked changes or comments.
  5. For a workbook, compare a few totals. For a presentation, page through every slide.

If something important moved, try another app, or send a PDF along with the file so the reader sees the layout you intended. The guide to converting a Word document to PDF on a Mac shows how.

Where Office Alternative fits

We make Office Alternative, so read this part with that in mind. It opens .docx, .xlsx, .pptx and .csv files and saves them in the same format. Only the parts you changed are rewritten, and the rest is copied from the original as it was, so features it can’t edit, such as macros, PivotTables and slide animations, are still there when the file goes back.

It keeps comments and tracked changes in Word files, with Accept and Reject. It recalculates about 340 Excel functions; formulas it doesn’t know keep Excel’s last result and are marked as not recalculated. It doesn’t open files protected with a password. The other limits are on the pages for Word, Excel and PowerPoint files, and like every app here, it is worth the test above.

It needs macOS 14 Sonoma or later and runs on Apple silicon and Intel Macs. It costs $20 once to edit files. Without buying it you can still open, read, print and export them to PDF. It is made by JOV and isn’t affiliated with Microsoft.