Exporting .csv with separator ,?

[Jan Aukes]

When I export a Excel file as .csv the separator is always a semicolon ;
But I would like to see "abc","abc".
How can I do this?
I know, with Windows you can in Configurations change this, but on a
Mac?
My purpose: importing files in Bento, the new Filemaker offspring, which
only accepts separations with commas.

 

[Carl Witthoft]

When I export a Excel file as .csv the separator is always a semicolon ;
But I would like to see "abc","abc".
How can I do this?
I know, with Windows you can in Configurations change this, but on a
Mac?
My purpose: importing files in Bento, the new Filemaker offspring, which
only accepts separations with commas.

Ya got me -- my Excels (every version every used) exports csv with
commas, as the name would suggest.
You don't have some corruption in your font library, do you?

 

[Corentin Cras-Méneur]

Ya got me -- my Excels (every version every used) exports csv with
commas, as the name would suggest.
You don't have some corruption in your font library, do you?

I'm not 100% sure but I suspect it has something to do with the decimal
separator selected in the system preferences.
If the decimal separator is set on a period (US for instance), then
Excel generates the cvs file with a coma as the separator.
If the decimal separator is a coma (France for instance), then it can't
use a coma as the separator and uses the semi-colon instead.

I fear that the only workaround in this case would be to change the
decimal separator to a period system-wide.

Corentin

 

[Jan Aukes]

Ya got me -- my Excels (every version every used) exports csv with
commas, as the name would suggest.
You don't have some corruption in your font library, do you?

As far as I know there is no corruption.

 

[Jan Aukes]

I'm not 100% sure but I suspect it has something to do with the decimal
separator selected in the system preferences.
If the decimal separator is set on a period (US for instance), then
Excel generates the cvs file with a coma as the separator.
If the decimal separator is a coma (France for instance), then it can't
use a coma as the separator and uses the semi-colon instead.

I changed the country from Netherlands into American and restarted. But
Excel still produces semicolons.

 

[Guest]

I'm trying to do the opposite, i've got commas and i need semi-colons, I've a US machine set up for UK spec. Maybe try changing your international settings to UK, and time to UK - Windows is far easier, you just change the comma to the semi-colon! macs!!!!

 

[Guest]

I've managed to change it back and forth a few times so i can get comma or semi-colon. Set your Time to be UK Format within your international settings, and you may also need to set your keyboard to be british. You will have to reset in order for the settings to be valid, if you change the settings after reset you should still get commas instead of semi-colons but the next time you boot up it will revert to the opposite.

 

[Bob Greenblatt]

I've managed to change it back and forth a few times so i can get comma or
semi-colon. Set your Time to be UK Format within your international settings,
and you may also need to set your keyboard to be british. You will have to
reset in order for the settings to be valid, if you change the settings after
reset you should still get commas instead of semi-colons but the next time you
boot up it will revert to the opposite.

Yes, Excel looks at these setting s only when it loads. So if you change
them, you will have to quit and restart Excel for them to take effect.