Forum Discussion
export excel to csv
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.
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.
