An Excel alternative for Mac that works in .xlsx and CSV files

Office Alternative opens .xlsx workbooks and CSV files, recalculates formulas as you type, and saves the workbook as .xlsx again. Older .xls workbooks open for reading.

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.

A budget workbook open in Office Alternative, with monthly costs and a column chart.

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 .xls workbooks open for reading only. To edit one, save it as .xlsx in 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.