Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.

Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >

You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

theoryforce Author

Level 1

8 points

How to change CSV Export field delimiter in Mac Numbers

I rely on the CSV to be comma-delimited (there is no way around that) but Mac Numbers gives the fields semicolon-delimited:

Boost VC;Silicon Valley, USA;Investor;XXX;ccc;;;;;;;;
First Star Ventures;Cambridge;Investor;;;;;;;;;;

The software that reads these CSVs only accepts them like this:

LP,Name,Location,Market,Focus,Tags,Website
Fintech,Bitrefill,Stockholm,Ecommerce,"Shopping, Ecommerce","Poseidon Group, Fulgur Ventures, BHB Network, Chainside, inbitcoin",2000000,,yes,no

There is no option in the export dialog to set the delimiter, just encoding.

How can I set the delimiter to comma for CSV exports? (*.numbers -> *.csv)

Mac Pro

Posted on Sep 30, 2019 7:13 AM

Top-ranking reply

Wayne Contello

Level 7

26,583 points

Posted on Sep 30, 2019 7:23 AM

usually, when the comma is the delimiter you are in a locale where the period is the decimal separator. When the semicolon is used, that may be an indication the file originated in a locale where the comma is the decimal separator.

what is your physical location as set in the Language and & regions settings for the file you are working on?

I the screenshot below, you would be able to change the region. I shared the document, so I cannot change it until I stop sharing. Choose a region where the period is used as the decimal separator

View in context

How to change CSV Export field delimiter in Mac Numbers

Similar questions