In Numbers on Mac, export your spreadsheet using File > Export To > CSV, then check that values with commas or quotation marks remain single fields in the resulting file. CSV uses quotation marks around special fields and doubles any quotation mark that is part of the value. Numbers documents CSV export options for tables, table names, and text encoding, but does not document a setting for choosing how fields are quoted; use the export workflow and verify the output rather than looking for a “quote fields” control. (Apple’s Numbers export guide, RFC 4180)

What CSV does with commas and quotation marks

A comma normally separates one CSV field from the next. If a value itself contains a comma, the field is enclosed in double quotation marks. If the value contains a literal double quote, that quote is written twice inside the quoted field. RFC 4180 also describes enclosing fields containing line breaks and notes that CSV implementations can differ, so the receiving app’s expectations matter. (RFC 4180, Section 2)

For example, suppose a row has three values: North, Smith, Lee, and She said "ready". A valid CSV representation is:

North,"Smith, Lee","She said ""ready"""

The outer quotes mark the second and third fields. The doubled quotes inside the last field represent the quotation marks that belong to its value. When a CSV reader parses this row, those field-enclosing quotes and escape pairs are structural; the values should be Smith, Lee and She said "ready".

Export a CSV from Numbers on Mac

  1. Open the spreadsheet in Numbers and review the table you intend to export. If the workbook has several tables, note whether you need a separate file for each table or one combined file.

  2. Choose File > Export To > CSV from the menu bar.

  3. In the export options, choose whether to create a file for each table or combine tables in one file. Select Include table names only if the recipient needs them. Open Advanced Options if you need to change text encoding; Apple documents these as CSV export options. (Apple Support)

  4. Continue through the save dialog, choose a destination and filename, then click Export. Numbers saves an exported copy; changes to that copy do not change the original spreadsheet. Keep the Numbers file if you need the editable workbook as well. (Apple Support)

Numbers’ documented CSV options do not include a text qualifier or an “always quote fields” checkbox. Do not add quotation marks manually to cell values simply to protect commas: export should encode the value as CSV structure, while manual quotes become literal data and may themselves need escaping. Apple’s guide describes CSV as values separated by commas but does not specify the exact quoting behavior for every case. If a particular recipient requires a specific CSV dialect, confirm its requirements and check the exported file against them.

Check the exported file before sending

Open the .csv copy in a plain-text viewer if you need to inspect its actual characters. Confirm that commas inside a value appear within a quoted field and that embedded double quotes are doubled. Do not judge the result by counting commas alone: commas that occur inside quoted fields are part of the value, not separators.

You can also open the exported CSV in a spreadsheet app and check whether the affected value remains in one cell. That is a practical parsing check, though the receiving system may follow different CSV conventions. If a value appears split across columns, or quotation marks appear as extra text, stop and check the raw CSV and the recipient’s import requirements before relying on the file.

For an exact-format requirement that Numbers’ documented controls do not expose, use an exporter that explicitly supports the recipient’s delimiter, quote, and encoding requirements, or ask the recipient for its accepted format. Avoid repairing a CSV with broad find-and-replace: replacing commas or quotes without parsing fields can alter both separators and legitimate cell content.

The goal is a CSV whose parsed fields preserve the original values. Export from Numbers, inspect a representative row containing punctuation, and confirm the recipient can read it before sending a file with important data.

Sources