How to change default program for CSV files Mac

Back in the pre-Mac OS X and macOS days, Apple’s System 9 and earlier relied on hidden metadata to associate files with apps. File extensions, those bits of text that follow a period at the end of a file (like .doc, .html, or .jpg) were optional, although often used for compatibility with other platforms and with web. On the web, file extensions are effectively mandatory so a browser knows how to handle a file appropriately.

Macworld reader Rick would like to monkey with that. He has a number of HTML templates, but to differentiate them from his production .html files, he puts the suffix .tt on them instead. Browsers don’t recognize these files by default. There’s a way to force an association between a file type and an application, but that application still has to recognize the extension.

If you have an extension that’s simply not mapping correctly, you can follow these steps:

  1. Select the file in the Finder and choose File > Get Info.
  2. In the Open With section, if there’s an appropriate app in the list, you can select it and click Change All and confirm, and now all files with that extension open in that app. You can stop here. But if the app you want doesn’t appear in the list, select Other.
  3. Choose the app from the list that shows. In the Enable pop-up menu, you can choose All Applications, and it will let you pick any app. Check the Always Open With box to force an association.
  4. Click Add.
How to change default program for CSV files Mac
IDG

While you can assign apps to file types, the apps may refuse to open them.

If you’re using, for example, .tt as your HTML template extensions like Rick, you could go through steps 1 to 4, and pick Safari as the app to open .tt files. The trouble is that Safari doesn’t know that a .tt file contains HTML.

In the olden days, when everything to do with the web was more in a state of flux, you could modify and add content mappings, usually in the form used by MIME, a decades-old method of associating actions and formats with file extensions. (You’ll see MIME mentioned explicitly in email programs’ headers. Some kinds of documents also embed MIME information into their headers, so software can read a few characters of the file to figure out what it is.)

How to change default program for CSV files Mac
IDG

The Tags editor lets you create your own, which you can assign to files to sort and find them.

Unfortunately, there’s no way I can find to change file associations in Safari or Chrome. Firefox exposes more of this mapping information, but you can’t add new file types.

Might I suggest instead using macOS’s Tags feature? In the Finder, select Finder > Preferences and click the Tags icon. You can add an HTML Templates tag and assign that to all your templates. Then you can use a Smart Folder to gather them together, or use various Arrange By/Sort By options to group by tags.

Ask Mac 911

We’ve compiled a list of the questions we get asked most frequently along with answers and links to columns: read our super FAQ to see if your question is covered. If not, we’re always looking for new problems to solve! Email yours to including screen captures as appropriate, and whether you want your full name used. Every question won’t be answered, we don’t reply to email, and we cannot provide direct troubleshooting advice.

  1. Home
  2. News

MORE: How to Force Quit an App in Mac OS X

One of the nice things about the Mac is that when you double click on a file, it automatically opens in a default application. For example, double clicking on a Microsoft Word file should open that document in Word. Sometimes, however, the default setting isn't very helpful. Perhaps every JPG photo you double click is opening in Photoshop when you just want to preview it. Fortunately, it's easy to change your file associations in Mac OS X, if you follow these steps.

  • Here's What to Do If Your MacBook Pro's Audio Is Going Bad
  • See how to Find Your MAC Address on Your Mac Computer
  • These are the Best MacBook Air cases
  • This is how to Fix Logitech Mouse Scrolling in macOS Mojave

1. Select a file with the format you want to change (ex: an MP3, a JPG picture, an HTML file) in the Finder.

select the file in Finder

2. Right click on the file and choose “Get Info.”

Get Info

3. Change the application in the “Open with:” drop down. If you just want to change it for just this file, then stop here.

Change the Open With App

4. Click the Change All button and then choose “Continue.” This will cause all files of that type to open in the new application.

If you're ready to move on from your current Mac, check out our guide for how to reset a MacBook, which you'll want to handle before you sell or give away yours. We're also tracking the MacBook Pro 2019 rumors.

  • How to Enable Parental Controls on a Mac
  • How to Install and Uninstall Software on a Mac
  • How to Replace Your MacBook Pro's Hard Drive with an SSD

Get instant access to breaking news, the hottest reviews, great deals and helpful tips.

Jennifer Kyrnin has been building websites since 1995, and teaching others how to do it since 1997. She's written several books on the topic, and is probably working on another one right now. And she does it all on her beloved iMac and sometimes her MacBook Air.

How do I change my default program to CSV?

Summary – How to open CSV files in Excel by default.
Click the Start button..
Click Default programs..
Click the Associate a file type or protocol with a program link..
Select the . csv option..
Click the Change program button..
Click Microsoft Excel..
Click the OK button..

How do I make sure CSV opens Excel on Mac?

These steps will apply to both Mac and PC versions of Excel. Click the Data tab, then From Text. Select the CSV file that has the data clustered into one column. Select Delimited, then make sure the File Origin is Unicode UTF-8.

How do I change the default application for a file type on Mac?

Permanently change the app used to open a file.
On your Mac, click the Finder icon in the Dock to open a Finder window..
Select the file, then choose File > Get Info. ... .
In the Info window, click the arrow next to “Open with.”.
Click the pop-up menu, then choose the app..

How do I change the default CSV separator in Excel Mac?

In the Region dialog box, on the Formats tab, click Additional settings… In the Customize Format dialog box, on the Numbers tab, type the character you want to use as the default CSV delimiter in the List separator box. For this change to work, the List separator should not be the same as Decimal symbol.