> ## Knowledge Base Index > Fetch the complete knowledge base index at: https://support.yuzer.com/sitemap.xml > Use this file to discover available pages before exploring further. > Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash). # Ouvrir un fichier CSV sous Excel sans perdre les formatages des cellules commençant par des 0 # Ouvrir un fichier CSV sous Excel sans perdre les formatages des cellules commençant par des 0 #### [Made by Raphael POCHON with Scribe](https://scribehow.com/shared/Ouvrir_un_fichier_CSV_sous_Excel_sans_perdre_les_formatages_des_cellules_commenant_par_des_0__fH06ZJc8ReCNFGnEuvHy1w) 1\. Cliquer sur [[Données]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/1550e6d2-9b82-4a14-affa-582d6af5d619/user_cropped_screenshot.webp?tl_px=0,0&br_px=1376,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=347,16) 2\. Cliquer sur [[Obtenir des données]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/3efec6d1-1faf-4f16-81ab-80bcd5439e28/ascreenshot.jpeg?tl_px=0,0&br_px=1376,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=18,66) 3\. Cliquer sur [[À partir d’un fichier]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/192870cb-a6ef-4c20-bb0a-50ddfca72522/ascreenshot.jpeg?tl_px=0,0&br_px=1376,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=99,102) 4\. Cliquer sur [[À partir d’un fichier texte/CSV]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/806b44c2-aba2-42c0-9152-f2208602b3f2/ascreenshot.jpeg?tl_px=0,0&br_px=1376,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=321,152) 5\. Sélectionner votre fichier ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/49997037-d6f6-417b-a8f6-4443be955802/ascreenshot.jpeg?tl_px=0,0&br_px=1376,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=195,117) 6\. Cliquer sur [[Importer]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/7ea32051-2f06-48c8-9041-1620eacb00a1/ascreenshot.jpeg?tl_px=165,297&br_px=1542,1066&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=677,277) 7\. Cliquer sur [[Transformer les données]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/daa61fdc-1bad-4406-ad8d-38bb05ebb4af/ascreenshot.jpeg?tl_px=0,0&br_px=882,662&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=861,757) 8\. Faites un clic droit sur [[Numéro de compte]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/da33c2da-857f-4df5-99aa-ed7d626b1f1a/ascreenshot.jpeg?tl_px=158,0&br_px=1534,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=662,122) Tip: Vérifier le formatage des colonnes et passer les au format texte pour conserver les [[0]] 9\. Cliquer sur [[Modifier le type]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/4050361a-c677-4085-9c7e-050201ad5d31/ascreenshot.jpeg?tl_px=158,0&br_px=1534,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=760,268) 10\. Cliquer sur [[Texte]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/67b14968-ca29-497b-b135-43a167d20e41/ascreenshot.jpeg?tl_px=158,209&br_px=1534,978&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=998,277) 11\. Cliquer sur [[Remplacer l'actuelle]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/d5ac6575-4329-42cd-852d-b5dcc4a54047/ascreenshot.jpeg?tl_px=0,0&br_px=462,204&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=400,349) Tip: Recommencer sur chaque colonne mal formatée 12\. Cliquer sur [[Fermer et charger]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/65056e6c-9cf2-452d-b3dd-93f4346e2f4d/ascreenshot.jpeg?tl_px=0,0&br_px=1376,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=0,24) 13\. Cliquer sur [[Fermer le volet]] ![](https://ajeuwbhvhr.cloudimg.io/colony-recorder.s3.amazonaws.com/files/2025-04-11/20ae3735-7a50-47af-ab70-c31fba6af9ca/ascreenshot.jpeg?tl_px=165,0&br_px=1542,769&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=1053,189) Tip: Votre fichier et alors importer sans perte de caractère Alpha