I have Excel 2011 on my Mac, and when I try to export a .xls file into .csv I end up having a semicolon separated file instead of .csv.
p.s. The System preferences for my keyboard input is Italian
What is the matter?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
Excel for Mac currently has no setting to change the CSV separator from the app itself.
The chosen value separator depends on your Region and your region's default number separators. To change them, go to “System Preferences” > “Language & Region”:
Then you need to verify the number separators in “Advanced …” > “General”.
Here are the rules Excel uses to determine how it saves CSV files:
,) for decimal separation (i.e., π (pi) is displayed as
3,1416), then Excel will save using semi-colons (
., a.k.a. full stop or period), then it will delimit with commas (
,for decimal separation), Excel will always use
;for CSVs, even when changing the decimal point under “Advanced” settings. You could, for example, if you want
,as a CSV separator, choose the United States as a region.