Forum Discussion
Excel 365 (EU) CSV Export on MacOS
Hi I'm running Excel 16.95.1 (build 25031528) on MacOS 15.3.2 I am trying to export a CSV file that uses commas as field separators. It keeps using semicolon as a separator. I often find posts aski...
This worked, but still demonstrates a lack of a basic feature within excel, which is present in Windows version of the app.
Open a terminal within MacOS and type:
defaults write com.microsoft.Excel CSVDecimalSeparator -string ”.”
defaults write com.microsoft.Excel CSVListSeparator -string ”,”Please note the original answer used the same comma for separator and decimal and would make any export with decimals broken.