Apple Numbers to CSV: Export, Import, and Excel Handoffs

Numbers Is Great — Until a Windows Colleague Needs the File

Apple Numbers is common on Mac and iPad among freelancers, schools, and small teams in the US, UK, Canada, and Australia. Partners still ask for CSV or Excel. Numbers can export both — but multi-table sheets, merged headers, and locale date formats create handoff bugs that look like “your Mac broke my data.”

This guide covers clean Numbers → CSV exports, CSV → Numbers imports, and how to prep files so Excel and Google Sheets behave.

Step-by-Step: Export Numbers to CSV

Desktop Numbers on Mac is the most controllable path.

• Put one rectangular table on the sheet you will export (or know which table Numbers will export).
• Remove title text boxes above the table; keep headers in row 1 of the table.
• File → Export To → CSV…
• Choose encoding UTF-8 when offered (best for £, é, ü, and non-English names).
• Save; reopen the CSV in the Online CSV Editor or TextEdit to verify columns.
• Send CSV — or convert CSV to Excel if the recipient refuses CSV.

One Sheet, One Table, One Header

Numbers encourages multiple tables on a canvas. CSV does not.

• CSV exporters typically flatten a single table — extra tables may be ignored or produce surprise files.
• Do not rely on Categories / grouped summaries for machine-readable exports; expand to flat rows first.
• Unmerge header cells; merged titles become uneven column counts.
• Delete blank spacer columns used for layout aesthetics.

sku,product,price,qty
MUG-01,Stoneware Mug,28.00,12
MUG-02,Espresso Cup,16.00,20

Dates, Numbers, and Locales on Mac

macOS region settings shape what Numbers writes into CSV cells.

• Format date columns to YYYY-MM-DD before export when sharing internationally.
• Format amount columns as numbers without currency symbols for QuickBooks/Xero/Shopify templates.
• Keep ZIP/postcodes and SKUs as text to preserve leading zeros.

Import CSV into Numbers

Opening CSV should be deliberate.

• File → Open the .csv, or drag onto Numbers.
• Check that columns split correctly — if not, the delimiter may be semicolon (EU) or tab.
• Set column data formats after import (date, text, number).
• For messy files, clean in Online CSV Editor first, then open the cleaned CSV in Numbers.

Numbers → Excel Without Tears

Sometimes XLSX is required, not CSV.

• Numbers can export Excel directly — useful for formatting-heavy workbooks.
• For data pipelines, CSV is still safer: less formatting noise, clearer types.
• If you export Excel and the colleague’s Windows Excel swaps dates, go back to ISO CSV.
• Convert CSV Online’s CSV to Excel tool helps when you already have a clean CSV.

iCloud Numbers Collaboration Caveats

Browser Numbers is convenient and slightly different.

• Confirm export options in the version you use (Mac app vs iCloud).
• Agree on a single “source of truth” table before anyone exports.
• Avoid editing CSV round-trips in three tools at once without version dates in filenames.

Common Mistakes

Mac-to-Windows classics.

• Exporting a dashboard canvas with charts and three tables as if it were one CSV grid.
• Sending MacRoman/legacy encoded CSV with UK/EU names.
• Assuming Windows Excel will honor UK dates from a Numbers export.
• Using Categories summaries as the export without flattening.
• Renaming .numbers to .csv.

Best Practices

Design a machine-readable table from the start.

• Keep a hidden “Export” sheet that is flat and ISO-dated.
• Name files with locale when needed (prices-uk.csv).
• Verify exports in a non-Apple tool before client delivery.
• Archive both .numbers and .csv for audits.
• Use browser cleanup when Excel is not installed on the Mac.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. After Numbers export, preview CSV in the Online CSV Editor, fix delimiters, and convert to Excel for Windows stakeholders. Works in Safari, Chrome, and Firefox on Mac — and on Windows/Linux when the handoff continues there.

Conclusion

Numbers to CSV is reliable when you export one flat table as UTF-8 with explicit date and number formats. Treat the Mac region as part of the file contract — especially when UK/AU day-first dates meet US Excel.