export excel to csv

Copper Contributor

Hi,

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

@Slimeguy361 

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.