How to change the default app for CSV files on Mac
A CSV file is a table saved as plain text, one row per line. A Mac usually opens .csv files in Numbers, or in Excel once Excel is installed. Spreadsheet apps are often the wrong tool for a CSV: they reformat what they read. Many people prefer a text editor or a dedicated CSV viewer as the default, and open a spreadsheet only when they need one.
Change it in Finder
- In Finder, select any
.csvfile. - Choose File → Get Info, or press ⌘ I.
- Expand Open with and pick the app. If it isn't listed, choose Other….
- Click Change All… and confirm.
Without Change All…, only that one file changes. Since macOS 26.4, Finder also asks you to confirm before a file-type default changes.
Apps that open CSV files on Mac
- Numbers, Microsoft Excel. Good for sorting and charts. Both reinterpret values when they open the file.
- Visual Studio Code, Sublime Text, BBEdit. Show the file exactly as it is. Best for data you will import somewhere else.
- TextEdit. Built in, and safe: it changes nothing.
Why a spreadsheet can damage a CSV
When Excel or Numbers opens a CSV, it guesses the type of each column. Leading zeros disappear from postcodes and IDs, long numbers turn into scientific notation, and anything that looks like a date is rewritten. If you then save, the original values are gone. Opening CSVs in a text editor by default avoids this.
Change it from Terminal
The free command-line tool duti sets defaults without Finder. Install it with Homebrew:
brew install duti
Then, to make Visual Studio Code open every .csv file:
duti -s com.microsoft.VSCode .csv all
The first argument is the app's bundle identifier. To find it for any app:
osascript -e 'id of app "Visual Studio Code"'
macOS may still ask you to confirm the change.
macOS identifies this file type as public.comma-separated-values-text.
Change it in Defaultify
- Open Defaultify and choose Documents & Office, or search for
.csv. - On the CSV Data Files (.csv) row, open the app menu and choose the app you want.
- Confirm in the Finder dialog.
This type can be changed in the free version. You can also drag any file onto the Defaultify window to see what opens 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.
If it changes back
Some apps claim file types again when they update. See how to stop apps from changing your defaults, and what to check when a change doesn't stick.