Numbers: Export CSV with different separator

Solution 1:

You can export as TSV instead of CSV. TSV is Tab Separated Values, so it's exactly what you're looking for.

Solution 2:

For those who want to export from numbers to csv with separators other than ones that numbers choose for you (and tabs) e.g. semicolons. Also if you want to quote your csv columns e.g. with double quotes.

The painless method is to open file in Libre office and export to csv from there. Choose 'Save As', select 'Text CSV', and tick 'edit filter settings' you will be able to set field delimeter and string delimeter in the following dialog. Note that only active sheet will be exported.

I was trying to convert spreadsheet to csv with comma separated, quoted columns in Numbers prior to finding this solution, I think it's not possible.