export excel to csv

Copper Contributor


I'm having trouble converting my Excel file to CSV where each box is separated with semicolons instead of commas. I'm not sure if it's just a MacBook thing. but I would appreciate some help.

Screenshot 2024-02-02 at 6.53.49 AM.png

1 Reply


Which separator will be used depends on your regional settings. Most probably semicolon is your default one. The means formula in your environment looks like =IF(true;1;2), not =IF(true,1,2).

Ways to change are here How to change Excel CSV delimiter to comma or semicolon (ablebits.com) . Above is for Windows but for Mac it shall be similar.