How to Edit and Save a CSV as UTF-8 in Excel for Mac
Question details
The user needs to know how to properly import, edit, and save a CSV file using UTF-8 encoding in Excel for Mac to ensure special characters and data alignment are preserved.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Importing, editing, and exporting a plain-text CSV file containing special characters that require UTF-8 encoding.
- Observed behavior
- When a saved CSV file is reopened, unexpected columns or garbled characters may display if the encoding, delimiter, or regional settings do not match the original file.
Verify the original delimiter used in your CSV file (such as a comma or semicolon) and remember that saving a file as CSV will inherently strip out any standard workbook formatting like highlights or formulas.
Import and Save as CSV UTF-8 via Get Data
Use Excel's Get Data tool to explicitly set the UTF-8 encoding and delimiter before making edits, then save specifically as a CSV UTF-8 file.
Opening a CSV file directly by double-clicking it relies on Excel's default encoding and system region settings, which often causes text corruption. Importing the data manually ensures you can specify the exact parameters needed for UTF-8 compatibility.
Open a blank workbook in Excel for Mac, navigate to the 'Data' tab on the ribbon, and click 'Get Data' (or 'From Text/CSV'). Browse your Mac to select the target CSV file and click 'Get Data'.
In the Text Import Wizard or Power Query preview, locate the 'File Origin' or 'Encoding' drop-down menu and select 'UTF-8'. Then, choose the correct delimiter (e.g., Comma) so your data is displayed cleanly in the preview window.
Click 'Load' to bring the properly formatted data into your spreadsheet. You can now edit the data safely without garbled characters.
Once edits are complete, go to 'File' > 'Save As'. In the 'File Format' drop-down menu, explicitly choose 'CSV UTF-8 (Comma delimited) (.csv)'. Click 'Save' and confirm the format if Excel displays a warning about formatting loss.
Maintain an Excel Workbook (.xlsx) Working Copy
If you need to preserve your formatting, formulas, and multiple sheets while working, keep a master Excel workbook and export a CSV copy only when needed.
Seamlessly Handle UTF-8 CSV Files in WPS Office
WPS Spreadsheet provides a highly intuitive text import wizard that automatically detects CSV encoding and delimiters upon opening. It is fully compatible with Microsoft Excel formats, making it effortless to manage plain-text files and complex workbooks natively on your Mac.
- 1. Open the CSV in WPS Spreadsheet: Launch WPS Office, click on 'Spreadsheet', go to 'Menu' > 'Open', and select your CSV file from your Mac.
- 2. Configure the Import Settings: The 'Text Import' dialog box will automatically appear. Select 'UTF-8' under the file encoding drop-down and check the appropriate delimiter box to preview your data correctly.
- 3. Edit the Data: Modify the contents in the spreadsheet as needed. Your special characters will remain intact.
- 4. Save with UTF-8 Encoding: Click 'Menu' > 'Save As', select 'CSV File' from the file type drop-down, and confirm that your encoding preference is still set to UTF-8.
Frequently Asked Questions
Why do special characters look garbled when opening a CSV in Excel on Mac?
This occurs when Excel misinterprets the file's text encoding. If a file was saved in UTF-8 format but Excel automatically opens it using a different default local encoding (like Mac OS Roman or ANSI), special characters, accents, and symbols will fail to display properly.
Can I save formulas or highlighted cells in a CSV file?
No, CSV (Comma-Separated Values) is strictly a plain-text format designed to store raw text and numbers. Any formulas, cell formatting, column widths, or multiple sheets will be permanently lost when saving. To keep your formatting, save your file as a standard Excel Workbook (.xlsx).
Is there a difference between 'CSV' and 'CSV UTF-8' in the Save As menu?
Yes. Choosing 'CSV UTF-8' specifically enforces the UTF-8 encoding standard, which guarantees that international characters and complex symbols are preserved across different software and operating systems. The standard 'CSV' option relies on the system's local default encoding, which can vary widely.
How do I change the default CSV delimiter from a comma to a semicolon in Excel for Mac?
Excel relies on your Mac's system-wide regional settings to determine the default list separator. To change it from a comma to a semicolon, you must go to Apple menu > System Settings > General > Language & Region, and adjust your advanced number formatting options.
