How to Fix Office 365 and Open CSV Files in Excel on M1 Mac
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.

- 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.
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.
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.
Find any .csv file on your Mac using Finder and single-click to select it.
Right-click the file and select 'Get Info' from the context menu, or press Command (⌘) + I on your keyboard.
Scroll down to the 'Open with:' section, click the dropdown menu, and select 'Microsoft Excel'.
Click the 'Change All...' button right below the dropdown, and confirm your choice in the pop-up prompt.

Update Office 365 to Run Natively on Apple Silicon
Ensure you are using the Apple Silicon-compatible build of Office 365 instead of the Intel version running through Rosetta 2.
Adjust macOS Language and Region for Formula Separators
Fix issues where Excel formulas require commas instead of semicolons by altering your Mac's regional formatting settings.
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. Download and Install: Get the native Mac version of WPS Office from the official website and move it to your Applications folder.
- 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. Work Seamlessly: Enjoy fast, native spreadsheet editing with perfect formatting retention.

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).




