Office for Mac Issues

How to Fix Office 365 and Open CSV Files in Excel on M1 Mac

Emma BrownEmma Brown Nov 3, 2026 869 views

Question details

The user needs to properly configure Microsoft Office 365 on an Apple Silicon (M1) Mac, adjusting regional settings for formula separators, ensuring native performance without Rosetta, and making Excel the default app for CSV files.

How to Fix Office 365 and Excel CSV Issues on an M1 Mac
Product
Microsoft Excel / Office 365
Device & OS
macOS (Apple Silicon M1)
Scenario
Setting up and optimizing Microsoft Office 365 for native performance on an M1 Mac and managing default file associations.
Observed behavior
CSV files open in Apple Numbers by default, Excel uses incorrect formula separators based on region, and Office apps may run through the Rosetta translation environment rather than natively.
Before you start

Ensure your macOS is updated to the latest version compatible with your M1 chip (Big Sur 11.5 or later) to guarantee the best application performance.

Solution 1Recommended

Set Microsoft Excel as the Default Application for CSV Files

Change your macOS file associations so that all CSV files automatically open in Microsoft Excel instead of the default Apple Numbers app.

By default, macOS links spreadsheet formats like CSV to Apple Numbers. Changing this setting globally ensures a smoother workflow for data analysis in Excel.

1
Locate a CSV File

Find any .csv file on your Mac using Finder and single-click to select it.

2
Open Get Info

Right-click the file and select 'Get Info' from the context menu, or press Command (⌘) + I on your keyboard.

3
Change the Default Application

Scroll down to the 'Open with:' section, click the dropdown menu, and select 'Microsoft Excel'.

4
Apply to All Files

Click the 'Change All...' button right below the dropdown, and confirm your choice in the pop-up prompt.

Set Microsoft Excel as the Default Application for CSV Files
Association Complete: All future CSV files downloaded or created on your Mac will now directly open in Excel.
Free Microsoft Office alternative

Try WPS Office for Mac – Fast, Free, and Fully Native on Apple Silicon

If you are tired of dealing with regional settings conflicts, high subscription costs, or performance quirks with Microsoft Office on your M1 Mac, switch to WPS Office. It provides a native, lightweight, and highly compatible alternative for opening Excel and CSV files without the hassle.

  1. 1. Download and Install: Get the native Mac version of WPS Office from the official website and move it to your Applications folder.
  2. 2. Set as Default: Right-click any CSV or XLSX file, choose 'Get Info', select WPS Spreadsheets under 'Open with', and click 'Change All'.
  3. 3. Work Seamlessly: Enjoy fast, native spreadsheet editing with perfect formatting retention.
Native Apple Silicon (M1/M2/M3) support for maximum speed and lower battery consumption.Seamless compatibility with Microsoft Excel formats, including .xlsx, .xls, and .csv.Free to use with a familiar, tabbed interface that requires zero learning curve.Lightweight installation that frees up valuable disk space on your Mac.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my CSV files keep opening in Apple Numbers instead of Excel?

macOS associates CSV files with its native Numbers application by default. You can permanently change this behavior by right-clicking a CSV file, selecting 'Get Info', changing 'Open with' to Excel, and clicking 'Change All'.

How do I check if Excel is running via Rosetta or natively on my M1 Mac?

Open the 'Activity Monitor' application on your Mac, navigate to the 'CPU' tab, and look for 'Microsoft Excel'. Check the 'Kind' column: if it says 'Apple', it is running natively; if it says 'Intel', it is using the Rosetta translator.

Why do I get a 'Data source reference is not valid' error when creating a PivotTable from my CSV data?

This error typically occurs if the CSV file contains unsupported characters, blank header columns, or regional separator conflicts. To resolve it, save the CSV file as a standard Excel Workbook (.xlsx) first, ensure all columns have clear headers, and try generating the PivotTable again.

How can I fix Excel formula separators without changing my Mac's entire region?

Go to 'System Preferences' > 'Language & Region', click the 'Advanced' button, and manually change the 'List separator' or 'Decimal' symbol to match your preferred Excel formula style (e.g., changing the list separator to a comma).