Choix séparateur virgule pour fichier *.csv

%3CLINGO-SUB%20id%3D%22lingo-sub-1927690%22%20slang%3D%22fr-FR%22%3EChoice%20comma%20separator%20for%20file%20'.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1927690%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EWith%20Excel%202007%2C%20I%20want%20to%20save%20an%20excel%20file%20in%20.cvs%20file%20with%20comma%20separator.%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%202007%20only%20offers%20.csv%20with%20comma%20separator%2C%20which%20the%20destination%20outlook%20365%20app%20does%20not%20handle%20well.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20successfully%20record%20.csv%20with%20comma%20separator%20and%20not%20comma%20with%20Excel%202007%3F%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20answers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1927690%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1927789%22%20slang%3D%22de-DE%22%3ESubject%3A%20Choix%20s%C3%A9parateur%20virgule%20pour%20fichier%20*.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1927789%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F880259%22%20target%3D%22_blank%22%3E%40Tatane%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShort%20tip%3A%20Separated%20CSV%20file%20with%20comma%20instead%20of%20semicolon%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20you%20want%20to%20create%20many%20user%20accounts%20in%20Office%20365%20at%20once%2C%20this%20only%20works%20with%20a%20comma-separated%20.%20CSV%20file%2C%20but%20not%20with%20a%20semicolon-separated%20.csv%20file.%20Separated%20CSV%20file%20with%20comma%20instead%20of%20semicolon%2C%20here%20you%20can%20see%20how%20it%20works%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Office%20365%20administrators%20and%20certainly%20also%20for%20many%20other%20admins%2C%20it%20happens%20again%20and%20again%20that%20data%20has%20to%20be%20imported%20or%20exported%20in%20bulk.%20The%20method%20of%20choice%20is%20often%20a%20comma-separated%20CSV.%20What%20exactly%20does%20that%20mean%3A%20A%20file%20is%20written%20that%20creates%20a%20line%20for%20each%20data%20record%2C%20just%20like%20in%20a%20simple%20text%20file.%20The%20individual%20fields%20per%20line%20are%20separated%20with%20a%20separator.%20It%20looks%20something%20like%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20name%3B%20last%20name%3B%20address%3B%20post%20code%3B%20city%3B%20telephone%20number%3B%20mobile%20phone%20number%3B%20age%3B%20email%20address%3B%20...%20Etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20data%20can%20be%20interpreted%20by%20an%20interface%20or%20a%20program%20such%20as%20Excel.%20Problems%20can%20arise%20here%2C%20however%3A%20the%20separator%20used%2C%20a%20semicolon%20in%20the%20example%20above%2C%20is%20not%20the%20same%20everywhere.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Germany%2C%20a%20semicolon%20is%20used%20by%20default.%20In%20the%20USA%2C%20however%2C%20the%20country%20in%20which%20the%20Office%20is%20developed%2C%20a%20comma%20is%20used%20by%20default.%20Why%20is%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20answer%20is%20as%20simple%20as%20it%20is%20complex.%20In%20the%20USA%2C%20the%20point%20is%20used%20as%20the%20decimal%20separator%2C%20so%20the%20comma%20is%20still%20free%20there%20and%20was%20defined%20as%20a%20separator.%20In%20Germany%2C%20for%20example%2C%20the%20comma%20is%20used%20as%20the%20decimal%20separator.%20It%20is%20therefore%20no%20longer%20available%20as%20a%20separator.%20That%20is%20why%20the%20semicolon%20is%20used%20as%20a%20separator%20in%20Germany.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20Germany%20and%20America%20as%20countries%20to%20make%20the%20differences%20clear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECSV%20file%20with%20comma%20instead%20of%20semicolon%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20now%20want%20to%20create%20many%20user%20accounts%20at%20once%20in%20Office%20365%2C%20for%20example%2C%20this%20only%20works%20with%20a%20comma-separated%20.%20CSV%20file%2C%20but%20not%20with%20a%20semicolon-separated%20.csv%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20save%20a%20file%20as%20.csv%20in%20Excel%2C%20there%20is%20no%20option%20to%20choose%20between%20a%20comma%20or%20a%20semicolon%20as%20a%20separator.%20The%20region%20settings%20in%20Windows%20provide%20a%20remedy%20here.%20Simply%20enter%20%22Region%22%20in%20the%20search%20(in%20Windows%207%20in%20the%20start%20bar%2C%20in%20Windows%2010%20in%20the%20task%20bar)%20or%20open%20the%20region%20settings%20via%20the%20control%20panel.%20At%20the%20top%20of%20the%20window%20that%20opens%2C%20under%20Format%2C%20select%20%22English%20(United%20States)%22%20and%20click%20Apply.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EThen%20save%20your%20Excel%20file%20as%20a%20comma-separated%20.csv%20file.%20This%20file%20is%20now%20separated%20by%20commas.%20Then%20simply%20change%20the%20regional%20settings%20back%20to%20%22German%20(Germany.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3ESource%3A%3CA%20href%3D%22https%3A%2F%2Fso-arbeiten-wir-morgen.de%2Fkurztipp-trennzeichengetrennte-csv-datei-mit-komma-statt-mit-semikolon%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fso-arbeiten-wir-morgen.de%2Fkurztipp-trennzeichengetrennte-csv-datei-mit-komma-statt-mit-semikolon%2F%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E-----------------------------------------------------------------%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPour%20info%3A%20l'utilisateur%20ne%20parle%20pas%20fran'ais%2C%20traduction%20par%20logiciel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPetite%20astuce%3A%20fichier%20CSV%20s%C3%A9par%C3%A9%20par%20une%20virgule%20au%20lieu%20d'un%20point-virgule%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPar%20exemple%2C%20si%20vous%20souhaitez%20cr%C3%A9er%20plusieurs%20comptes%20d'utilisateurs%20dans%20Office%20365%20la%20fois%2C%20cela%20ne%20fonctionne%20qu'avec%20un%20fichier%20.%20CSV%20s%C3%A9par%C3%A9%20par%20des%20virgules%2C%20mais%20pas%20avec%20un%20fichier%20.csv%20s%C3%A9par%C3%A9%20par%20des%20points-virgules.%20Fichier%20CSV%20s%C3%A9par%C3%A9%20par%20une%20virgule%20au%20lieu%20d'un%20point-virgule%2C%20vous%20pouvez%20voir%20ici%20comment%20cela%20fonctionne%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPour%20les%20administrateurs%20Office%20365%20et%20certainement%20aussi%20pour%20de%20nombreux%20autres%20administrateurs%2C%20il%20arrive%20encore%20et%20encore%20que%20les%20donn%C3%A9es%20doivent%20%C3%A9tre%20import%C3%A9es%20ou%20export%C3%A9es%20en%20masse.%20La%20m%C3%A9thode%20de%20choix%20est%20souvent%20un%20CSV%20s%C3%A9par%C3%A9%20par%20des%20virgules.%20Qu'est-ce%20que%20cela%20signifie%20exactement%3A%20Un%20fichier%20est%20%C3%A9crit%20qui%20cr%C3%A9e%20une%20ligne%20pour%20chaque%20enregistrement%20de%20donn%C3%A9es%2C%20comme%20dans%20un%20simple%20fichier%20texte.%20Les%20champs%20individuels%20par%20ligne%20sont%20s%C3%A9par%C3%A9s%20par%20un%20s%C3%A9parateur.%20A%20ressemble%20quelque%20chose%20comme%20a%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPr%C3%A9nom%3B%20nom%20de%20famille%3B%20address%3B%20code%20postal%3B%20ville%3B%20num%C3%A9ro%20de%20t%C3%A9l%C3%A9phone%3B%20num%C3%A9ro%20de%20t%C3%A9l%C3%A9phone%20portable%3B%20%22Ge%3B%20address%20e-mail%3B%20...%20Etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECes%20donn%C3%A9es%20peuvent%20%C3%A9tre%20interpr%C3%A9t%C3%A9es%20par%20une%20interface%20ou%20un%20programme%20tel%20qu'Excel.%20Des%20probl%20mes%20peuvent%20cependant%20surgir%20ici%3A%20le%20s%C3%A9parateur%20utilis%C3%A9%2C%20un%20point-virgule%20dans%20l'exemple%20ci-dessus%2C%20n'est%20pas%20le%20m%20me%20partout.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEn%20Allemagne%2C%20un%20point-virgule%20est%20utilis%C3%A9%20par%20d%C3%A9faut.%20Aux%20etats-Unis%2C%20cependant%2C%20le%20pays%20dans%20lequel%20l'Office%20est%20d%C3%A9velopp%C3%A9%2C%20une%20virgule%20est%20utilis%C3%A9e%20par%20d%C3%A9faut.%20Pourquoi%20donc%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELa%20r%C3%A9ponse%20est%20aussi%20simple%20que%20complexe.%20Aux%20%C3%A9tats-Unis%2C%20le%20point%20est%20utilis%C3%A9%20comme%20s%C3%A9parateur%20d%C3%A9cimal%2C%20donc%20la%20virgule%20y%20est%20toujours%20libre%20et%20a%20%C3%A9t%C3%A9%20d%C3%A9finie%20comme%20s%C3%A9parateur.%20En%20Allemagne%2C%20par%20exemple%2C%20la%20virgule%20est%20utilis%C3%A9e%20comme%20s%C3%A9parateur%20d%C3%A9cimal.%20Il%20n'est%20donc%20plus%20disponible%20en%20tant%20que%20s%C3%A9parateur.%20C'est%20pourquoi%20le%20point-virgule%20est%20utilis%C3%A9%20comme%20s%C3%A9parateur%20en%20Allemagne.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUtilisez%20l'Allemagne%20et%20l'Am%C3%A9rique%20comme%20pays%20pour%20clarifier%20les%20diff%C3%A9rences.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFichier%20CSV%20avec%20virgule%20au%20lieu%20de%20point-virgule%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESi%20vous%20souhaitez%20maintenant%20cr%C3%A9er%20plusieurs%20comptes%20d'utilisateurs%20la%20fois%20dans%20Office%20365%2C%20par%20exemple%2C%20cela%20ne%20fonctionne%20qu'avec%20un%20fichier%20.%20CSV%20s%C3%A9par%C3%A9%20par%20des%20virgules%2C%20mais%20pas%20avec%20un%20fichier%20.csv%20s%C3%A9par%C3%A9%20par%20des%20points-virgules.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESi%20vous%20souhaitez%20enregistrer%20un%20fichier%20au%20format%20.csv%20dans%20Excel%2C%20il%20n'y%20a%20pas%20d'option%20pour%20choisir%20entre%20une%20virgule%20ou%20un%20point-virgule%20comme%20s%C3%A9parateur.%20Les%20param%20%C3%A9rgion%20dans%20Windows%20fournissent%20un%20rem%20%C3%A9de%20ici.%20Entrez%20simplement%20%22R%C3%A9gion%22%20dans%20la%20recherche%20(sous%20Windows%207%20dans%20la%20barre%20de%20d%C3%A9marrage%2C%20sous%20Windows%2010%20dans%20la%20barre%20des%20t%20ches)%20ou%20ouvrez%20les%20param'tres%20de%20r%C3%A9gion%20via%20le%20panneau%20de%20configuration.%20En%20haut%20de%20la%20fen%20tre%20qui%20s'ouvre%2C%20sous%20Format%2C%20s%C3%A9lectionnez%20%22Anglais%20(Etats-Unis)%22%20et%20cliquez%20sur%20Appliquer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnregistrez%20ensuite%20votre%20fichier%20Excel%20en%20tant%20que%20fichier%20.csv%20s%C3%A9par%C3%A9%20par%20des%20virgules.%20Ce%20fichier%20est%20maintenant%20s%C3%A9par%C3%A9%20par%20des%20virgules.%20Ensuite%2C%20modifiez%20simplement%20les%20param'tres%20r%C3%A9gionaux%20sur%20%22Allemand%20(Allemagne)%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJe%20serais%20heureux%20de%20savoir%20si%20je%20pouvais%20aider.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EJe%20sais%20que%20je%20ne%20sais%20rien%20(Socrate)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Veuillez%20marquer%20et%20voter%20pour%20cette%20r%C3%A9ponse%20si%20cela%20vous%20aide%2C%20car%20elle%20sera%20b%C3%A9n%C3%A9fique%20pour%20plus%20de%20membres%20de%20la%20communaut%C3%A9%20qui%20liront%20ici.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour

Avec Excel 2007, je souhaite enregistrer un fichier excel en fichier .cvs avec séparateur virgule. 

Excel 2007 ne  propose que .csv avec séparateur point virgule, ce que ne gère pas bien l'application destinataire outlook 365.

Y a-t'il un moyen de réussir l'enregistrement en .csv avec séparateur virgule et non point virgule avec Excel 2007 ?

Merci de vos réponses

 

1 Reply

@Tatane 

Short tip: Separated CSV file with comma instead of semicolon

 

For example, if you want to create many user accounts in Office 365 at once, this only works with a comma-separated .CSV file, but not with a semicolon-separated .csv file. Separated CSV file with comma instead of semicolon, here you can see how it works:

 

For Office 365 administrators and certainly also for many other admins, it happens again and again that data has to be imported or exported in bulk. The method of choice is often a comma-separated CSV. What exactly does that mean: A file is written that creates a line for each data record, just like in a simple text file. The individual fields per line are separated with a separator. It looks something like this

 

First name; last name; address; post code; city; telephone number; mobile phone number; age; email address; ... etc.

 

This data can be interpreted by an interface or a program such as Excel. Problems can arise here, however: the separator used, a semicolon in the example above, is not the same everywhere.

 

In Germany, a semicolon is used by default. In the USA, however, the country in which the 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 point is used as the decimal separator, so the comma is still free there and was defined as a separator. In Germany, for example, the comma is used as the decimal separator. It is therefore no longer available as a separator. That is why the semicolon is used as a separator in Germany.

 

Use Germany and America as countries to make the differences clear.

 

CSV file with comma instead of semicolon

 

If you now want to create many user accounts at once 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 a comma or a semicolon as a separator. The region settings in Windows provide a remedy 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 window that opens, under Format, select “English (United States)” and click Apply.

Then save your Excel file as a comma-separated .csv file. This file is now separated by commas. Then simply change the regional settings back to "German (Germany.

Quelle:https://so-arbeiten-wir-morgen.de/kurztipp-trennzeichengetrennte-csv-datei-mit-komma-statt-mit-semik...

-----------------------------------------------------------------

Pour info: l'utilisateur ne parle pas français, traduction par logiciel.

 

Petite astuce: fichier CSV séparé par une virgule au lieu d'un point-virgule

 

Par exemple, si vous souhaitez créer plusieurs comptes d'utilisateurs dans Office 365 à la fois, cela ne fonctionne qu'avec un fichier .CSV séparé par des virgules, mais pas avec un fichier .csv séparé par des points-virgules. Fichier CSV séparé par une virgule au lieu d'un point-virgule, vous pouvez voir ici comment cela fonctionne:

 

Pour les administrateurs Office 365 et certainement aussi pour de nombreux autres administrateurs, il arrive encore et encore que les données doivent être importées ou exportées en masse. La méthode de choix est souvent un CSV séparé par des virgules. Qu'est-ce que cela signifie exactement: Un fichier est écrit qui crée une ligne pour chaque enregistrement de données, comme dans un simple fichier texte. Les champs individuels par ligne sont séparés par un séparateur. Ça ressemble à quelque chose comme ça

 

Prénom; nom de famille; adresse; code postal; ville; numéro de téléphone; numéro de téléphone portable; âge; adresse e-mail; ... etc.

 

Ces données peuvent être interprétées par une interface ou un programme tel qu'Excel. Des problèmes peuvent cependant surgir ici: le séparateur utilisé, un point-virgule dans l'exemple ci-dessus, n'est pas le même partout.

 

En Allemagne, un point-virgule est utilisé par défaut. Aux États-Unis, cependant, le pays dans lequel l'Office est développé, une virgule est utilisée par défaut. Pourquoi donc?

 

La réponse est aussi simple que complexe. Aux États-Unis, le point est utilisé comme séparateur décimal, donc la virgule y est toujours libre et a été définie comme séparateur. En Allemagne, par exemple, la virgule est utilisée comme séparateur décimal. Il n'est donc plus disponible en tant que séparateur. C'est pourquoi le point-virgule est utilisé comme séparateur en Allemagne.

 

Utilisez l'Allemagne et l'Amérique comme pays pour clarifier les différences.

 

Fichier CSV avec virgule au lieu de point-virgule

 

Si vous souhaitez maintenant créer plusieurs comptes d'utilisateurs à la fois dans Office 365, par exemple, cela ne fonctionne qu'avec un fichier .CSV séparé par des virgules, mais pas avec un fichier .csv séparé par des points-virgules.

 

Si vous souhaitez enregistrer un fichier au format .csv dans Excel, il n'y a pas d'option pour choisir entre une virgule ou un point-virgule comme séparateur. Les paramètres de région dans Windows fournissent un remède ici. Entrez simplement «Région» dans la recherche (sous Windows 7 dans la barre de démarrage, sous Windows 10 dans la barre des tâches) ou ouvrez les paramètres de région via le panneau de configuration. En haut de la fenêtre qui s'ouvre, sous Format, sélectionnez «Anglais (États-Unis)» et cliquez sur Appliquer.

 

Enregistrez ensuite votre fichier Excel en tant que fichier .csv séparé par des virgules. Ce fichier est maintenant séparé par des virgules. Ensuite, modifiez simplement les paramètres régionaux sur "Allemand (Allemagne)".

 

Je serais heureux de savoir si je pouvais aider.

 

Nikolino

Je sais que je ne sais rien (Socrate)

 

* Veuillez marquer et voter pour cette réponse si cela vous aide, car elle sera bénéfique pour plus de membres de la communauté qui liront ici.