Discussion :

[alain47]

Bonjour

J'exporte d'une base de données un fichier cvs et j'aimerais savoir comment le convertir en XLS afin que chaque donnée apparaisse clairement dans un champ sans les tabulations.

Exemple de mon fichier :
"Email","Nom","Publié Nom","Prénom","Publié Prénom","Organisation ou employeur","Publié Organisation ou employeur","Profession","Publié Profession","Adresse","Publié Adresse","Ville","Publié Ville","Province","Publié Province","Code postal","Publié Code postal","Téléphone au travail","Publié Téléphone au travail","Télécopieur","Publié Télécopieur","Courriel","Publié Courriel","Tarif régulier","Tarif étudiant","Tarif non-membre","Carte de crédit VISA","PAYPAL","Sandwich viandes froides","Sandwich végétarien","attestation de formation","Champ d'action","Publié Champ d'action"
"alain@azer.ca","planger","","alain","","","","","","","","","","","","","","5145989089","","","","","","","","","","","","","","",""
"alain@demo.com","demo","oui","demo","oui","demo"," oui","demo","oui","demo","oui","demo"," oui","demo","oui","demo","oui","5145989089","oui","demo","oui","","oui","oui","oui","oui","oui","oui","oui","oui","oui","toits verts, marais filtrants,","oui"
"jinfo@vinciconsultants.com","ID","","ID","","","","","","","","","","","","","","0000","","","","","","oui","","","","","","","","test",""
"alain@azer3.ca","planger","oui","alain3","oui","demo"," oui","demo","oui","demo","oui","demo"," oui","demo","oui","demo","oui","demo","","demo","oui","","oui","oui","oui","oui","oui","oui","oui","oui","oui","demo",""
"alain@azer2.ca","planger","","alain2","","","","","","","","","","","","","","5145989089","","","","","","","","","","","","","","",""

Merci

Alain

[MARCELBENH]

Bonjour,

Moi perso pour ne pas m'emmm... je fais comme ça :

1 - je renomme le fichier en txt
2 - j'ouvre excel puis fichier-ouvrir - *.txt
3 - je défini séparateurs et autres caractères
4 - je sauvegarde en xls

[ouisansdoute]

Bonjour,

J'utilise aussi la solution de MARCELBENH.

Si tu ne veux pas renommer le csv en txt et que ton fichier csv s'ouvre avec toutes les données en colonne A, tu peux
sélectionner la colonne et utiliser le menu convertir pour définir les séparateurs de champs