excel create csv without semicolon office for mac

Mostly EU colonies, which consist of half of the world, another half follow UK standard (how the hell UK so big OO) so in turn make using comma for database that include number create much of the headache because Excel refuse to recognize it as delimiter.

Easiest solution was to use;, which is automatically recognized both in Ubuntu and Windows, without me having to dictate any specific setting(s).

This is the char Windows applications expect to be the CSV separator.

All applications that use Windows regional settings will have this behavior.

If you want to make more compatible for windows CSV file, put sep; on top of the CSV file.

I was pulling my hair out because I couldnt make a csv that Photoshop recognized.

I changed region option back to US english and it all worked fine again.

How can format of the csv be different across regions, this means my colleagues cannot open or save csv for guys with a pc in another region.

The comma is not only used for decimals or thousands separator, but also very often in text, unlike the semicolon.

Semicolon would have been a better choice because its much more rare.

Excel opens CSV files and treats them as spreadsheets, and can save spreadsheets in CSV format, but a CSV file saved by Excel in the US (for example) will not work if someone in France or Belgium tries to open it, and vice versa.

Whatever standard is OK for me, as long as theres a standard that works for everybody.

Unfortunately, RFC 4180 is a request for comments, NOT a standard.

It says right at the top -- does not specify an Internet standard of any kind.

Later, it says that RFC 4180 documents the format that seems to be followed by most implementations.

It appears that this was created by a small private company, not associated with any standards body.

Its an excellent starting point, but there are unfortunately lots of CSV files out there in the wild that dont follow this standard.

Instead, they have a number of normative sections within, which is not the case of RFC 4180.

You may want to re-link to en.wikipedia.orgwikiComma-separatedvaluesBasicrules, This has a passage on locales: Adjacent fields must be separated by a single comma.

However, CSV formats vary greatly in this choice of separator character.

In particular, in locales where the comma is used as a decimal separator, semicolon, TAB, or other characters are used instead.

Generally the delimiter is a comma, but I have seen many other characters used as delimiters.

Is the file specific to your applicationprogram, or does this need to work with other programs.

In Excel 2013, select the first column, go to DATA - Text To Columns - Choose Delimited, click Next then choose only Comma on Delimiters and you will see changes immediately in the Data preview and finally click Finish.

Excel Create Csv Without Semicolon Office For Mac