How to make Microsoft Excel the default spreadsheet app on Mac
With both Numbers and Excel on a Mac, spreadsheets can end up split: .xlsx in one app and .csv in the other. Each extension has its own default, so each has to be set.
The file types involved: .xlsx, .xls, .csv.
In Finder, one type at a time
- Select a file of the first type in Finder and press ⌘ I.
- Under Open with, choose Microsoft Excel.
- Click Change All… and confirm.
- Repeat with a file of each other type. You need one sample file per extension.
From Terminal, all at once
The free command-line tool duti sets defaults without Finder. Install it with Homebrew:
brew install duti
for ext in xlsx xls csv; do duti -s com.microsoft.Excel .$ext all; done
The first argument is the app's bundle identifier. To find it for any app:
osascript -e 'id of app "Microsoft Excel"'
macOS may still ask you to confirm the change.
In Defaultify
- Open Defaultify and search for the extension, or drag a file onto the window.
- Choose Microsoft Excel from the app menu on each row.
- Confirm in the Finder dialog.
With Defaultify Pro, a profile changes a whole set of types together, and you can switch back with one click.
Think twice about CSV
Excel reinterprets CSV values when it opens them: leading zeros vanish and long numbers change form. If you handle data exports, consider leaving .csv with a text editor and opening Excel only when you need it.
Manage every default in one place
Defaultify for Mac shows all your file-type and link defaults in one window, flags missing ones, and with Pro warns you when an app takes one over.