I'm saving a CSV file on Numbers and it's not separating the columns, instead it's bringing all the data into one column. When I open the file on a text editor normally columns in a CSV are separated by commas (,) and in the CSV I export from Numbers the columns are separated by semi-colons (;). Does anyone know why this is happening?
MacBook Pro 15″, OS X 10.10
Your computer (System Preferences) is set to a region that uses the comma as the decimal separator. In those places, CSV files often use semicolons. Otherwise, numeric data would need quotes around it so the decimal separator would not be mistaken as a column separator.
Your computer (System Preferences) is set to a region that uses the comma as the decimal separator. In those places, CSV files often use semicolons. Otherwise, numeric data would need quotes around it so the decimal separator would not be mistaken as a column separator.
You can go into System Preferences/Language & Region/Advanced and set the decimal separators to a dot. It will then export with commas as the column separator. It will also change all your numbers in your spreadsheet (and elsewhere) so they use the dot as the decimal separator. Set them back when you are done.
Or you can use find/replace twice in the CSV file with it opened in a text editor, but it may be less than perfect.
I may be forgetting other ways to go about this. This question comes up from time to time.
Do you know how I can change this?
Number not saving CSV file correctly
