Spreadsheets that arrive on a Mac are usually budgets, price lists, timesheets, exports from another system and tables someone wants filled in. Office Alternative opens them as Excel workbooks, without turning them into another kind of document, and saves them in the same format, so the person who sent the file can open your version in Excel.

Formulas
About 340 of Excel’s functions are calculated, including the lookup, text, date, logical and statistical functions most workbooks use. Results update on every edit, and Sheet > Calculate Now (F9) recalculates everything. Insert > Function and the Formulas tab list the functions it calculates.
If a workbook uses a function Office Alternative doesn’t calculate, the cell keeps the result stored in the file and is marked as not recalculated, so you can tell which numbers are current. Error values such as #REF! and #NAME? come with a plain explanation in the formula bar, and a circular reference names its cell in the status bar.
Working in the sheet
The ribbon has Home, Insert, Formulas, Data and View tabs, laid out the way Excel’s are.
- Formatting. Fonts, fills, borders, alignment, wrapping, number formats, Excel’s built-in cell styles, merged cells and the Format Painter.
- Rows and columns. Insert and delete them, and formulas, charts and names that refer to them move along. Hide, group, resize and AutoFit them, and freeze the top row or the first column.
- Sort and filter. Sort a block with its header row, sort by several columns, and filter by values, text, comparisons, top or bottom items and blanks. SUBTOTAL follows the filter.
- Tables. Format as Table, header and total rows, structured references and calculated columns.
- Data tools. AutoSum, Fill Series and the fill handle, Remove Duplicates, Text to Columns, Goal Seek, Subtotal, data validation rules, and conditional formatting with data bars, colour scales and icon sets.
- Charts. Column, bar, line and pie charts from a selection, plus stacked, area, scatter and doughnut charts.
- Sheets. Add, rename, move, hide, colour and delete sheets. Renaming a sheet updates the formulas that use it.
- Printing. Print area, page breaks, headers and footers, and print titles. File > Export To > PDF exports the current sheet, the selected sheets or all of them.
CSV files
A CSV file opens as a table. Office Alternative keeps a value as it was written, so a code that starts with zero keeps its zero and a long number is shown digit for digit. Numbers still sort as numbers, and the header row stays on top.
You can save it as CSV again, or as an Excel workbook with File > Export To > Excel Workbook. Saving a CSV copies the lines you didn’t change as they were, and files of 500,000 rows open and save quickly. CSV can’t store formatting, filters or frozen rows, so those are for viewing only in a CSV file. The guide to opening a CSV file on a Mac explains the usual problems.
What it doesn’t do
- Older
.xlsworkbooks open for reading only. To edit one, save it as.xlsxin another app first. - PivotTables are shown and kept, but you can’t create or change them. Summarize Data builds an editable summary with formulas instead.
- Macros are kept in the file and never run.
- A workbook protected with a password to open it can’t be opened. A sheet protected without a password can be unprotected.
- Shapes and text boxes on a sheet show as labelled boxes, and a few chart types Office Alternative doesn’t draw show as placeholders. Both are kept in the file.
- Pictures can be added but not moved or resized once placed.
- There is no real-time editing with other people.
For a workbook built around macros, PivotTables you need to change, or data connections, use Excel itself.
Your files stay on your Mac
Workbooks and CSV files are opened and saved on your Mac and never uploaded. Large workbooks are saved in the background, so the window keeps responding. The app needs an internet connection to sign in and, now and then, to check your purchase, but not to work in a file.
Price
Office Alternative costs $20 once to edit files, and it also handles Word, PowerPoint and PDF files. Without buying it you can still open, read, print and export your workbooks to PDF. See Pricing.
How Office Alternative compares with other apps for spreadsheets: Microsoft 365, Numbers, Google Sheets and ONLYOFFICE. All the comparisons are on one page.
Questions
Will Excel users be able to open the workbook I save?
Yes. It is saved as an .xlsx file. The parts of the workbook you didn’t change are copied from the original as they were, so charts, names and formatting you didn’t touch stay as they were.
Does it keep leading zeros in a CSV file?
Yes. A value in a CSV file is kept as it was written, so 00123 stays 00123, and a cell formatted as Text in a workbook keeps exactly what you typed.
Can I edit an .xls file?
Not in that format. An .xls workbook opens for reading. Save it as .xlsx in another app to edit it here.
Can it run macros?
No. Macros are kept in the file so they still work in Excel, but they never run in Office Alternative.
Can I turn a CSV file into an Excel workbook?
Yes. Open the CSV file, then choose File > Export To > Excel Workbook.
Which Macs does it run on?
Any Mac with macOS 14 Sonoma or later, with Apple silicon or an Intel processor.
Read next
-
How to open and edit an Excel file on a Mac without Excel
Ways to open and edit an .xlsx file on a Mac without Excel, what happens to formulas and charts in each one, and how to send the file back as .xlsx.
-
How to open a CSV file on a Mac so the columns line up
Why a CSV file opens as one long line or in a single column on a Mac, how to open it as a table, and how to keep leading zeros and long numbers.
-
A Microsoft 365 alternative for Mac that works offline, $20 once
Edit Word, Excel, PowerPoint and PDF files on a Mac, offline, for $20 paid once. What you get, what you give up, and how offline works.
-
Microsoft Office alternatives for Mac: what each one costs and does
Microsoft 365, Apple’s iWork, Google Docs, LibreOffice, ONLYOFFICE and Office Alternative on a Mac: what each costs, if it works offline, who needs Office.