Can Mac Open CSV with Excel default?

Home → Wiki → Mac → Changing Regional Setting in a MAC (CSV imports)

Table of Contents Show

Excel as Default for Other Formats
Opening Numbers File with Excel
How do I open a CSV file in Excel by default Mac?
How do I make a CSV file open in Excel by default?
How do I change the default CSV separator in Excel Mac?
How do I open a CSV file on a Mac?

This solution will assist where clients are trying to import reports from a CSV file and they appear on the first column:

For Mac OS version 10.7.4, please follow these instructions:

Close the Excel application
Click on the Apple button
Select System Preferences
Select Text and Language
Click on Formats
Under Numbers select Customize
Change the Decimal separator from a comma (,) to a full stop (.)
Then click on Ok/Save
Test the Excel import again

For Mac OS version 10.8.3, please follow these instructions:

Close the Excel application
Click on the Apple button
Select System Preferences
Select Language and Text
Click on Region
Under Numbers select Customize
Change the Decimal separator from a comma (,) to a full stop (.)
Then click on Ok/Save
Test the Excel import again

For Mac OS version 10.10.1, please follow these instructions:

Close the Excel application
Click on the Apple button
Select System Preferences
Select Language and Region
Click Advanced
Change the Decimal separator from a comma (,) to a full stop (.)
Then click on Ok/Save
Test the Excel import again

NB: If it does not work, try rebooting the machine, and test again.

Asked 1 year, 4 months ago

Viewed 2k times

Is there a way to have MacOS open CSV and Excel files in Google Sheets when you double-click them? I've tried associating the Google Sheets shortcut in Applications but that doesn't work.

asked Jul 21, 2021 at 19:36

Install the Office Editing for Docs, Sheets & Slides Chrome Extension and then register the file types that you want to open with Chrome. You can use either Finder or SwiftDefaultApps.

Using Finder

You have to do this once per file extension you want to associate:

Select a file (ie, some-sheet.xlsx) in Finder
Press ⌘ + i
Change the Open with: option to Google Chrome.app
Click Change All...
Now all your .xlsx will open with Chrome
Repeat for other file types (see supported file types)

Using SwiftDefaultApps

You can install using brew install swiftdefaultappsprefpane --cask. It installs as a Pref Panel, meaning you will find it in System Preferences.

More instructions on how to use it are available on the readme.

answered Jul 23, 2021 at 3:18

Home / Advanced Excel / How to Make Excel Default on Mac

In Mac, if Microsoft Excel is Installed you don’t need to make it default as it’s the default application to open spreadsheet files that are in xlsx format. But, if you still face a problem while opening these files with Excel, in this tutorial ahead, I have shared simple steps to make Excel default on Mac.

First, make sure to have one Excel workbook in the xlsx format.
After that, right-click on it and click on the “Get Info” option.
Next, in the “Info” dialog box, go to the “Open” dropdown and select Microsoft Excel from the drop down.
From here, click on the “Change All” button to apply this setting to all the files.
Now, click on “Continue” to apply.
In the end, close the “Info” dialog box.

Now whenever you open any file with the same extension files, it will get open with Microsoft Excel.

Excel as Default for Other Formats

If you have other formats like (CSV, XLSB, and others), and you want to use Excel use these files.

Just follow the steps we used earlier in this post. This means you need to change the default application for each of these formats one by one.

But, if you have Excel installed on your Mac, you don’t need to do this, your Mac will do it for you automatically.

Opening Numbers File with Excel

Mac has Numbers as a Default Application for Spreadsheets.

And there is one thing that you need to know, Numbers application has its own file format and it’s not possible to open a spreadsheet file that is saved in “Numbers” Application format.

When you change numbers to Excel for Number’s files, it will show you a dialog box that asks you if you want to open it.

But when you click “Yes” it will show you that this file is Corrupt.

How do I open a CSV file in Excel by default Mac?

Procedure:.

Right-click on an Excel File (. xlsx, . xls, . csv, etc).

Click on Get Info in the pop-up..

Click Open With if the section isn't already expanded..

Click the dropdown and choose Microsoft Excel..

Click Change All....

Click Continue when the Finder asks you if you're sure..

How do I make a CSV file open in Excel by default?

To set Excel as the default program for CVS files, here are the steps to perform:.

Right-click any . csv file in Windows Explorer, and then select Open with… > Choose another app from the context menu..

Under Other options, click Excel, check off the Always use this app to open . csv files box, and click OK..

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.