Office for Mac Issues

How to Fix Excel for Mac CSV Options Opening a Password Dialog

Phi Hung Vo Oct 10, 2026 869 views

Question details

The user is unable to access CSV formatting and delimiter settings because the Options button triggers a password prompt instead.

How to Fix Excel for Mac CSV Options Opening a Password Dialog

Product: Microsoft Excel for Mac
Device & OS: Mac
Scenario: Saving a spreadsheet as a CSV file and attempting to modify delimiter settings using the Options button.
Observed behavior: Selecting the CSV Options button incorrectly opens a dialog with unusable 'Password to open' and 'Password to modify' fields rather than the expected CSV delimiter options.

Before you start

Ensure your Excel for Mac application is updated to the latest version, as Microsoft frequently patches user interface bugs in routine updates.

Solution 1Recommended

Test Alternative CSV File Formats

Check if the bug is isolated to a specific CSV format by testing the other available CSV export options in the Save As dialog.

Excel for Mac offers multiple variations of the CSV format. In some software versions, the bug may only affect the default CSV option while the others function normally.

Open the Save As dialog

Click on 'File' in the top menu bar and select 'Save As' to open the saving preferences.

Change the File Format

Click the 'File Format' dropdown menu and locate the 'Specialty Formats' or 'Common Formats' section.

Select a different CSV format

Choose an alternative like 'CSV UTF-8 (Comma-delimited)' or 'MS-DOS Comma Separated'.

Check the Options button

Click the 'Options' button again to see if the correct delimiter formatting settings appear instead of the password dialog.

Restart Required: If the password dialog still appears for all four CSV formats, completely quit and restart Excel before trying again.

Solution 2

Report the Bug to Microsoft Support

Since this is a recognized application bug in specific Mac builds, reporting it ensures the development team can log and patch the issue.

Free Microsoft Office alternative

Export CSVs Seamlessly with WPS Office

If Excel's CSV options are broken on your Mac, WPS Office provides a lightweight, free alternative. It handles CSV exports with custom delimiters flawlessly, completely bypassing this frustrating bug while maintaining full compatibility with your existing Excel files.

1. Open your file in WPS Office: Launch WPS Spreadsheet and open your existing workbook.
2. Access the Save As menu: Go to Menu > Save As and choose the CSV file format.
3. Configure CSV Options: Click the options button to seamlessly select your preferred delimiters and text encoding.

Native support for custom CSV delimiters without UI bugs.Fully compatible with Microsoft Excel (.xlsx) file formats.Free, lightweight, and highly optimized for Mac users.

microsoft office alternative - wps office

Frequently Asked Questions

Does the CSV file format support password encryption?

No, CSV (Comma-Separated Values) is a plain-text format that cannot store passwords, formatting, or formulas. If you need to secure your data with a password, you must save the file in the standard Excel Workbook (.xlsx) format.

How do I change the default CSV delimiter on a Mac without using Excel options?

You can change your system-wide list separator by going to macOS System Settings > General > Language & Region. Adjusting your number formatting preferences here will change how applications, including Excel, generate CSV files by default.

What should I do if updating Excel does not fix this bug?

If the issue persists after installing the latest Office updates, you can use a free alternative like WPS Office to safely export your spreadsheets to CSV with the correct delimiter settings until Microsoft releases a patch.

Office App Problems