Whether you are preparing data for a web application, migration, or sharing, knowing how to convert excel to csv mac correctly is a fundamental skill. While the task sounds incredibly straightforward, Mac users frequently run into frustrating formatting errors. From scrambled columns and lost accents to the dreaded issue where Excel saves everything with semicolons instead of commas, a simple export can quickly turn into a headache.

In this comprehensive guide, we will cover the absolute best ways to convert Excel to CSV on macOS—both with and without Microsoft Excel installed. We will also address how to convert csv to excel mac (and convert csv to excel on mac) properly to ensure your data, formulas, and special formatting remain completely intact.

1. How to Convert Excel to CSV on Mac Using Microsoft Excel

If you have Microsoft Excel installed on your Mac, using its native interface is the quickest route. However, the exact file format you select in the export menu dictates whether your file will work on other systems or end up broken. Here is the step-by-step process to get it right.

Step-by-Step Native Conversion

1. Open your spreadsheet: Launch Microsoft Excel and open the ".xlsx" or ".xls" file you want to convert.
2. Navigate to Save As: Click on File in the top menu bar of your Mac, and select Save As... (or press Command + Shift + S).
3. Choose your destination: Select the folder on your Mac where you want to save the new file.
4. Select the file format: Click on the File Format dropdown menu at the bottom of the dialog box. This is where you must be careful.
5. Select the correct CSV type: From the dropdown menu, scroll down to the "Common Formats" or "Specialty Formats" section. Choose CSV UTF-8 (Comma delimited) (.csv).
6. Save the file: Click Save. If Excel warns you that some features or formatting might be lost when saving in CSV format, click Yes or Continue.

Understanding the Excel Mac CSV Formats (And Which to Avoid)

When you open the File Format dropdown on Mac, you will see several CSV options. Selecting the wrong one can corrupt your data. Here is what they actually mean:

• CSV UTF-8 (Comma delimited) (.csv): This is the gold standard. It saves your data as a comma-separated values file encoded in UTF-8. UTF-8 ensures that non-English characters, accents (like é, ü, ñ), emojis, and currency symbols are preserved perfectly. Always use this format unless you have a specific reason not to.
• CSV (Comma delimited) (.csv): This is a standard CSV format that uses your system's default local encoding (often Windows-1252 or Mac Roman). If your dataset contains only basic English letters and numbers, it works fine. If it contains foreign characters or accents, they may turn into random gibberish (e.g., "é" instead of "é").
• CSV (Macintosh) (.csv): Avoid this format. This is a legacy format from older classic Macintosh operating systems. It uses a Carriage Return (\\r) instead of the standard Line Feed (\\n or \\r\\n) as a row separator. If you try to upload a Macintosh CSV to modern databases or web platforms (like Salesforce, Shopify, or Mailchimp), the system will likely fail to recognize the rows and treat your entire spreadsheet as a single massive line of text.
• CSV (MS-DOS) (.csv): This is another legacy format designed for old DOS-based systems. It is outdated and should be bypassed.

The Multi-Sheet Limitation

One critical detail many users overlook is that CSV files can only support a single worksheet. If your Excel workbook has multiple tabs (e.g., Sheet1, Sheet2, Sheet3), saving as a CSV will only save the sheet you are currently viewing (the active sheet).

If you need to convert an entire multi-tab Excel file, you must open each tab individually and perform the "Save As" process for each one, renaming them accordingly (e.g., "file-sheet1.csv", "file-sheet2.csv"). If you have dozens of sheets, doing this manually is tedious, which is why we will discuss automation and alternative methods later in this guide.

2. Converting Excel to CSV on Mac Without Excel

You do not need to pay for a Microsoft Office subscription to convert Excel files on your Mac. macOS comes with built-in tools, and several free web-based utilities do a fantastic job.

Method A: Using Apple Numbers (Built-in and Free)

Apple Numbers is pre-installed on every Mac. It handles Excel files beautifully and allows for quick CSV exports.

1. Open the file in Numbers: Right-click your Excel file (".xlsx") in the Finder, select Open With, and choose Numbers.
2. Export the file: Once open, go to File in the top menu bar, hover over Export To, and select CSV....
3. Configure advanced options: In the export dialog box, you can expand Advanced Options. Ensure the Text Encoding is set to Unicode (UTF-8) to prevent character corruption.
4. Set your delimiter: By default, Numbers uses your system's default separator. Click Next....
5. Name and save: Name your file, choose a save location, and click Export.

Method B: Using Google Sheets (Cloud-Based)

If you prefer cloud tools, Google Sheets is a free and reliable option that ensures your formatting matches web standards.

1. Upload your Excel file: Open Google Drive and upload your Excel sheet.
2. Open with Google Sheets: Double-click the uploaded file to open it in the Google Sheets interface.
3. Download as CSV: Go to File > Download and select Comma-separated values (.csv).
4. Google Sheets will instantly download the active sheet as a clean, UTF-8 encoded CSV file to your Mac's Downloads folder.

Method C: Using the Mac Terminal (For Developers and Power Users)

If you need to batch-convert dozens of files or prefer the command line, you can use the Terminal. This bypasses GUI software entirely and is extremely fast.

First, you can install gnumeric (which includes ssconvert) via Homebrew. If you do not have Homebrew, install it first, then run: brew install gnumeric

Once installed, you can convert any Excel file to CSV instantly with this command: ssconvert input_file.xlsx output_file.csv

To batch-convert every Excel file in a folder, you can run a simple bash loop in Terminal: for f in *.xlsx; do ssconvert "$f" "${f%.xlsx}.csv"; done

Alternatively, if you have Python installed with the pandas library, you can use a quick one-liner: python3 -c "import pandas as pd; pd.read_excel('input.xlsx').to_csv('output.csv', index=False, encoding='utf-8')"

3. Fixing the Infamous Comma vs. Semicolon Delimiter Bug on macOS

One of the most frustrating issues Mac users experience when they convert excel to csv mac is that the resulting file uses semicolons (";") instead of commas (",") to separate data.

Why Does This Happen?

Excel and macOS determine the CSV separator character based on your system's Regional Settings.

• In English-speaking regions (like the US, UK, and Australia), a period (".") is used as a decimal separator (e.g., 12.50), which means a comma (",") is free to be used as the list separator in CSVs.
• In many European and South American countries, a comma (",") is used as the decimal separator (e.g., 12,50). Because the comma is already busy separating decimals, Excel automatically defaults to using a semicolon (";") as the CSV list separator to avoid confusion.

If you send a semicolon-separated file to a database or software that expects a standard comma-separated file, the import will fail completely, often stuffing all of your data into a single scrambled column.

The Excel Preferences Fix (The Fastest Workaround)

Instead of changing your entire Mac's regional formatting, you can force Excel to use standard US-style separators directly within the application's preferences:

1. Open Microsoft Excel on your Mac.
2. In the menu bar at the top, click on Excel and select Preferences... (or press Command + ,).
3. Under the Authoring section, click on Edit.
4. Look for the setting that says Use system separators and uncheck it.
5. In the Decimal separator box, type a period (".").
6. In the Thousands separator box, type a comma (",").
7. Close the Preferences window.
8. Save your spreadsheet as a CSV file. Excel will now write it using standard commas, regardless of your Mac's region.

The macOS System Settings Fix (The Global Workaround)

If you are using Apple Numbers or want a system-wide change so that all applications use commas for CSVs, you must adjust your macOS System Settings. The steps vary slightly depending on your version of macOS (Ventura, Sonoma, Sequoia, etc.):

1. Click the Apple menu () in the top-left corner of your screen and select System Settings.
2. Scroll down on the left sidebar and select General.
3. Click on Language & Region on the right side.
4. Look for the Number format dropdown.
5. Select the format that uses a period for decimals and a comma for thousands (e.g., 1,234,567.89).
6. Close System Settings.
7. Important: You must quit and restart Excel or Numbers for this system change to take effect.

The "sep=" Workaround

If you have a CSV file that is already saved with semicolons and you want Excel to open it correctly on your Mac without changing settings, you can open the file in TextEdit and type sep=; on the very first line of the document, then save. When Excel opens that file, it reads the instruction and automatically splits the columns correctly.

4. How to Convert CSV to Excel on Mac Without Losing Data

Now, let's look at the reverse process: how to convert csv to excel mac and convert csv to excel on mac correctly.

Simply double-clicking a CSV file to open it in Excel is the worst way to handle it. Excel will try to automatically format your data, which leads to several well-known data destruction bugs:

• Leading zeros are deleted: ZIP codes (like 02108) or phone numbers with leading zeros are converted to numbers, stripping the zero (2108).
• Long numbers become scientific notation: Large ID numbers or credit card numbers are converted to scientific notation (like 4.5E+15), permanently destroying the raw numbers.
• Dates are scrambled: Dates formatted in European or custom layouts get misread and auto-converted into incorrect standard date formats.
• Special characters break: Foreign characters or accented letters display as gibberish because Excel did not use the proper text encoding.

The Proper Import Wizard Method

To convert csv to excel on mac while preserving every single piece of data, always use the Import tool. This acts as a protective shield for your data.

1. Open a blank workbook: Launch Excel on your Mac and open a fresh, empty spreadsheet.
2. Start the Import tool: In the top menu bar, select File > Import....
3. Select file type: In the dialog box that appears, select CSV file and click Import.
4. Locate your file: Browse your Mac's files, select the CSV you want to convert, and click Get Data.
5. Configure Delimiters (Text Import Wizard):
   • Choose Delimited under original data type.
   • Set File origin to Unicode (UTF-8). This is key to preventing broken accented characters.
   • Click Next.
6. Choose separators: Uncheck Tab and check Comma (or Semicolon, if your file was generated in Europe). Verify the preview at the bottom to ensure the data splits cleanly into vertical columns. Click Next.
7. Protect your data types (The Crucial Step): In the preview window, look at the columns of your data. Click on any column that contains zip codes, ID numbers, serial numbers, or phone numbers with leading zeros. In the "Column data format" box above, change the selection from General to Text. This forces Excel to treat those values as raw text, preventing them from being truncated or formatted as numbers.
8. Finish and Save: Click Finish. Select where you want the imported data to go (e.g., Existing sheet, $A$1) and click OK.
9. Save as Excel: Now that your data is cleanly imported, go to File > Save As..., change the format to Excel Workbook (.xlsx), and save. You have successfully converted your CSV to Excel on Mac without losing any data!

The Apple Numbers "Bypass" Trick

If the Excel Import Wizard feels too complicated, Apple Numbers offers an incredibly elegant workaround. Numbers is significantly smarter than Excel when it comes to auto-detecting data types. It rarely destroys leading zeros or breaks UTF-8 characters when opening CSVs.

1. Right-click your CSV file in Finder, choose Open With, and select Numbers.
2. Numbers will open the CSV instantly, formatting your columns, leading zeros, and accents perfectly.
3. Go to File > Export To > Excel....
4. Under Advanced Options, you can leave it as default and click Next....
5. Save the new .xlsx file. When you open this newly exported file in Excel, your data will be clean, formatted, and fully intact.

5. Frequently Asked Questions (FAQ)

Why does Excel for Mac keep saving my CSV with semicolons instead of commas?

This is caused by your system's regional settings. If your macOS decimal separator is set to a comma (common in European regions), Excel will use a semicolon as the default list separator. You can fix this by going to Excel > Preferences > Edit and unchecking "Use system separators," then manually setting the decimal separator to a period (".") and the thousands separator to a comma (",").

Why did all my worksheet tabs disappear after saving Excel as a CSV on Mac?

CSV (Comma Separated Values) is a plain-text format that does not support multiple worksheets, tabs, formulas, or formatting. It can only store a single sheet of raw text. When you save an Excel file as a CSV, Excel only exports the currently active tab and discards the rest. To save other tabs, you must select them and save each one individually as its own CSV file.

How do I stop accented or foreign characters from turning into gibberish (e.g., "é" instead of "é")?

This is an encoding mismatch. To fix this, always choose CSV UTF-8 (Comma delimited) (.csv) when exporting from Excel. When importing a CSV back into Excel, ensure the File origin in the Text Import Wizard is set to Unicode (UTF-8) instead of Macintosh or Windows Latin.

What is the difference between "CSV (Macintosh)" and standard CSV?

Legacy "CSV (Macintosh)" utilizes a Carriage Return (\\r) line terminator, which was the old Mac OS standard before OS X. Standard CSV (including UTF-8) uses Line Feed (\\n) or Carriage Return Line Feed (\\r\\n), which are universally recognized by modern operating systems and web browsers. Always use CSV UTF-8 instead of the Macintosh option.

Can I convert CSV to Excel on Mac for free?

Yes. You can open any CSV file using Apple Numbers (which is free and pre-installed on all Macs) or Google Sheets. From there, you can export or download the file directly in the Excel (.xlsx) format without needing a Microsoft Office subscription.

6. Best Practices and Final Takeaways

Managing data conversions between Excel and CSV on Mac does not have to be a trial-and-error process. By adhering to a few industry-standard rules, you can guarantee clean transitions every time:

• Standardize on UTF-8: Whether exporting or importing, always verify that your text encoding is set to UTF-8. This is the single best way to protect your special characters from breaking.
• Protect Numeric Text: Never open raw CSVs directly in Excel if they contain zip codes, phone numbers, or credit card numbers. Use the Import Wizard or run them through Apple Numbers first to secure leading zeros.
• Verify Delimiters: If you operate in a multi-lingual team across the US and Europe, double-check your application's edit settings to ensure your commas and semicolons are aligned with your database requirements.

By adding these methods to your workflow, you will save hours of manual cleanup and maintain absolute data integrity across all of your projects.