How to Convert CSV to Excel on a Mac (Excel and Numbers)

To convert CSV to Excel on a Mac, open the CSV in Excel for Mac with Data > From Text/CSV, set the delimiter and encoding, then save as .xlsx — or open it in Apple Numbers and export as Excel. The process is almost the same as on Windows, but the buttons live in slightly different places, Numbers handles CSVs its own way, and Mac-specific encoding quirks (like old Mac Roman files) can garble text if you pick the wrong file origin. (If you just need the file converted without touching a spreadsheet app, the free CSV to Excel converter works in any Mac browser.)

Most Mac CSV problems come from one of three habits: double-clicking the file and hoping for the best, saving from Numbers without checking the format, or ignoring the encoding dropdown. Fix those three and the Mac workflow is smooth.

Method 1: Excel for Mac — Data > From Text/CSV (Recommended)

If you have Microsoft 365 or Excel 2021/2024 for Mac installed, this is the best route:

1. Open Excel to a blank workbook. Go to the Data tab on the ribbon.
2. Click From Text/CSV. (On some Mac Excel versions the button is labeled "From Text" — same dialog.)
3. Select your CSV file and click Get Data.
4. Set the delimiter. In the preview window, change the delimiter if the preview shows everything in one column. Comma is the default; European files may need Semicolon. For tab or pipe files, pick the matching option — the guides to tab-delimiter files and pipe-delimiter files cover those in detail.
5. Set the File Origin (encoding). Use 65001: Unicode (UTF-8) unless the preview shows garbled characters. Macs sometimes receive files saved with Windows-1252 or old Mac Roman encoding — if accents look wrong, try the other origins until the preview looks right. (Encoding problems in general are covered in the guide to fixing CSV encoding errors in Excel.)
6. Click Load. The data lands in a proper table.
7. Save as .xlsx. File > Save As, choose "Excel Workbook (.xlsx)". This step matters: if you skip it, you are still editing a CSV.

Why not just double-click? Double-clicking opens the CSV in Excel's default mode, which guesses the delimiter and encoding with no preview. US files usually survive; European files (semicolons, special characters) often do not. The import dialog costs ten seconds and removes the guesswork.

Method 2: Apple Numbers — Open and Export

Numbers is free on every Mac and opens CSVs natively:

1. Open Numbers, then File > Open and select the CSV. Numbers parses it into a table automatically.
2. Check the result. Numbers is good at guessing delimiters but occasionally splits on the wrong character. Scan a few rows — if a column looks merged or split wrong, the file may need Excel's explicit import instead.
3. Export as Excel. File > Export To > Excel. In the export dialog, choose the format and click Next, then Save.

Two Numbers gotchas:

• Formulas and features. Numbers exports the values and basic formatting, but complex Excel features (pivot tables, macros, advanced conditional formatting) do not round-trip. If the workbook needs those, use Excel for Mac, not Numbers.
• Numbers saves .numbers by default. If you click Save instead of Export, you get a Numbers file that Windows Excel cannot open. Always use Export To > Excel when the file must leave the Apple ecosystem.

Fixing Common Mac CSV Problems

Garbled characters (mojibake)

Macs display UTF-8 correctly when the file actually is UTF-8 and Excel knows it. Garbled text like é usually means the file is Windows-1252 or Mac Roman but Excel read it as UTF-8. Re-import with Data > From Text/CSV and cycle the File Origin options until the preview renders correctly. Do not try to fix garbled text with Find & Replace — the underlying bytes are wrong, not the display.

Numbers and dates shifting format

Macs set to a non-US region may interpret 03/04/2026 as 3 April instead of March 4. After import, select the date column, open Format > Cells (Excel) or the Format sidebar (Numbers), and set the date format explicitly. The guide to fixing CSV date formats in Excel walks through this in detail.

Leading zeros disappearing

ZIP codes, product codes, and phone numbers lose leading zeros when Excel guesses the column type as Number. In the import preview, set the column's data type to Text before loading. If the file is already open, format the column as Text and re-enter the values — or re-import, which is cleaner.

Semicolon-delimited files from Europe

European accounting and banking software exports semicolon-separated CSVs. Excel for Mac set to a US region will not split these on double-click. Use the import dialog and set the delimiter to Semicolon explicitly.

Excel for Mac vs Numbers: which to use?

Use Excel for Mac when you need control; use Numbers for quick one-off conversions of clean files.

Saving and Sharing the Result

Once the data is in a workbook:

• Save as .xlsx (Excel) or Export To > Excel (Numbers). Verify the extension is .xlsx before sending the file to a Windows user.
• Check the file size. A CSV that was 50 MB may become a much larger .xlsx with formatting. If email rejects it, compress to .zip or share a link.
• Keep the original CSV as the raw source. If you need to redo the import with different settings, you want the untouched original, not the workbook you already edited.

FAQ

Can I convert CSV to Excel on a Mac without Microsoft Excel?

Yes. Apple Numbers opens CSVs and exports to Excel format (File > Export To > Excel). For a no-install option, the free online CSV to Excel converter works in Safari or Chrome and downloads a real .xlsx.

Why does my CSV look wrong when I double-click it on a Mac?

Double-clicking lets the app guess the delimiter and encoding. It guesses right for simple US files and wrong for files with semicolons, special characters, or non-UTF-8 encoding. Import explicitly with Data > From Text/CSV (Excel) to control both settings.

Does Numbers save real Excel files?

Only through File > Export To > Excel. A plain Save produces a .numbers file that Windows Excel cannot open. Always export, and confirm the file ends in .xlsx before sharing.

How do I fix é and other garbled characters on a Mac?

Re-import the CSV and change the File Origin (encoding) in the preview dialog. The file is probably Windows-1252 or Mac Roman, not UTF-8. Pick the origin that makes the preview display correctly.

Is Excel for Mac's CSV import the same as Windows?

Functionally yes — same dialog, same options. The differences are cosmetic (button labels, ribbon layout) and one real gap: Power Query on Mac is more limited than on Windows, so heavy automated cleaning is harder.

Final Checklist

• Imported with Data > From Text/CSV (Excel) or opened in Numbers — not just double-clicked.
• Delimiter set so every column lands separately; preview verified before loading.
• Encoding set so special characters display correctly.
• Date columns formatted explicitly; code columns set to Text to keep leading zeros.
• Saved/exported as .xlsx and the extension confirmed before sharing.

If all five checks pass, your CSV is now a proper Mac-made Excel workbook — ready to send to anyone, on any platform.