Forum Discussion
EXCEL n'ouvre pas bien mon document CSV
Bonjour, J'ai déjà tenté de résoudre le problème avec des personnes de Microsoft. Après 3h de travail de leur part sur mon ordinateur (sans succès) on m'a conseillé de venir ici pour résoudre mon...
Bonjour JMB17
Merci pour votre réponse. J'ai fais la modification mais cela n'a rien changé malheureusement 😞
Voici à quoi ressemble mon excel (voir capture d'écran).
This data can be interpreted by an interface or a program such as Excel. However, problems can arise here: the separator used, in the example above a semicolon, is not the same everywhere.
A semicolon is used by default in Europe. In the USA, however, the country in which Office is developed, a comma is used by default. Why is that?
The answer is as simple as it is complex. In the USA, the period is used as a decimal separator, so the comma is still free there and was thus defined as a separator. In Europa, however, the comma is used as the decimal separator. It is therefore no longer available as a separator. That is why the semicolon is used in Europa (specialy Germany) as a separator.
CSV file with comma instead of semicolon
If you now want to create many user accounts in Office 365, for example, this only works with a comma-separated .CSV file, but not with a semicolon-separated .csv file.
If you want to save a file as .csv in Excel, there is no option to choose between commas or a semicolon as a separator. The region settings in Windows can help here. Simply enter "Region" in the search (in Windows 7 in the start bar, in Windows 10 in the task bar) or open the region settings via the control panel. At the top of the Format window that opens, select “English (United States)” and click Apply.
Region Settings in Windows (10)
Then save your Excel file as a delimited .csv file. This file is now comma separated. Then simply change the region settings back to "French :-)."
If that doesn't work then I can't help.
A semicolon is used by default in Europe. In the USA, however, the country in which Office is developed, a comma is used by default. Why is that?
The answer is as simple as it is complex. In the USA, the period is used as a decimal separator, so the comma is still free there and was thus defined as a separator. In Europa, however, the comma is used as the decimal separator. It is therefore no longer available as a separator. That is why the semicolon is used in Europa (specialy Germany) as a separator.
CSV file with comma instead of semicolon
If you now want to create many user accounts in Office 365, for example, this only works with a comma-separated .CSV file, but not with a semicolon-separated .csv file.
If you want to save a file as .csv in Excel, there is no option to choose between commas or a semicolon as a separator. The region settings in Windows can help here. Simply enter "Region" in the search (in Windows 7 in the start bar, in Windows 10 in the task bar) or open the region settings via the control panel. At the top of the Format window that opens, select “English (United States)” and click Apply.
Region Settings in Windows (10)
Then save your Excel file as a delimited .csv file. This file is now comma separated. Then simply change the region settings back to "French :-)."
If that doesn't work then I can't help.