{"id":3610,"date":"2017-08-21T14:43:42","date_gmt":"2017-08-21T14:43:42","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-empecher-excel-de-reformater-les-donnees-csv-lors-de-limportation\/"},"modified":"2026-07-28T18:25:55","modified_gmt":"2026-07-28T18:25:55","slug":"comment-empecher-excel-de-reformater-les-donnees-csv-lors-de-limportation","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-empecher-excel-de-reformater-les-donnees-csv-lors-de-limportation\/","title":{"rendered":"Comment emp\u00eacher Excel de reformater les donn\u00e9es CSV lors de l&rsquo;importation"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"D\u00e9couvrez la m\u00e9thode pr\u00e9cise pour importer des fichiers CSV dans Excel, en veillant \u00e0 ce que les z\u00e9ros non significatifs, les num\u00e9ros de carte bancaire et les autres formats de donn\u00e9es critiques soient conserv\u00e9s.","ga_short_answer":"Pour emp\u00eacher Excel de reformater automatiquement les donn\u00e9es CSV, utilisez l\u2019Assistant d\u2019importation de texte. Ouvrez une nouvelle feuille Excel, acc\u00e9dez \u00e0 l\u2019onglet \u00ab Donn\u00e9es \u00bb, puis s\u00e9lectionnez \u00ab \u00c0 partir de texte (ancienne m\u00e9thode) \u00bb ou une option similaire. Configurez l\u2019assistant de mani\u00e8re \u00e0 ce que toutes les colonnes soient trait\u00e9es au format \u00ab Texte \u00bb, afin de garantir la conservation exacte des donn\u00e9es telles que les z\u00e9ros non significatifs et les num\u00e9ros de carte bancaire.","ga_scenario":"Lorsqu\u2019ils ouvrent des fichiers CSV directement dans Excel, les utilisateurs sont souvent confront\u00e9s \u00e0 un reformatage automatique des donn\u00e9es. Cela peut entra\u00eener des pertes de donn\u00e9es critiques, telles que la suppression des z\u00e9ros non significatifs dans les valeurs num\u00e9riques ou <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/can-customer-credit-card-sublist-data-be-updated-via-csv-import-in-netsuite\/\">la conversion des num\u00e9ros de carte bancaire en notation scientifique<\/a>, ce qui compromet l\u2019int\u00e9grit\u00e9 des donn\u00e9es.","ga_solution":"Pour emp\u00eacher Excel de reformater les donn\u00e9es lors de l'importation d'un fichier CSV, proc\u00e9dez comme suit :\n\n1. Ouvrez un nouveau classeur Excel vierge.\n2. Acc\u00e9dez \u00e0 l\u2019onglet `Data` dans le ruban Excel. Dans la section `Get & Transform Data`, s\u00e9lectionnez `From Text\/CSV` ou, pour acc\u00e9der \u00e0 l\u2019ancien Assistant d\u2019importation de texte, recherchez `From Text (Legacy)`. (Remarque : pour acc\u00e9der \u00e0 GA_KEEP_0005, il peut \u00eatre n\u00e9cessaire d\u2019activer l\u2019option \u00ab Afficher les assistants d\u2019importation de donn\u00e9es h\u00e9rit\u00e9s \u00bb dans les Options d\u2019Excel, selon votre version d\u2019Excel.)\n3. Recherchez et s\u00e9lectionnez votre fichier CSV, puis cliquez sur `Import`.\n4. Si l\u2019Assistant d\u2019importation de texte s\u2019ouvre (g\u00e9n\u00e9ralement \u00e0 partir de `From Text (Legacy)`) :\n    * \u00c0 l\u2019\u00e9tape 1, choisissez `Delimited` et cliquez sur `Next`.\n    * \u00c0 l\u2019\u00e9tape 2, assurez-vous que seule l\u2019option GA_KEEP_0010 est coch\u00e9e comme d\u00e9limiteur, et d\u00e9cochez toutes les autres options. Cliquez sur `Next`.\n    * \u00c0 l\u2019\u00e9tape 3, s\u00e9lectionnez toutes les colonnes dans la fen\u00eatre `Data Preview`. Pour ce faire, cliquez sur la premi\u00e8re colonne, puis maintenez la touche GA_KEEP_0013 enfonc\u00e9e et cliquez sur la derni\u00e8re colonne. Toutes les colonnes devraient d\u00e9sormais \u00eatre mises en surbrillance.\n    * Une fois toutes les colonnes s\u00e9lectionn\u00e9es, choisissez `Text` comme `Column data format`.\n    * Cliquez sur `Finish` pour importer vos donn\u00e9es en conservant leur format d\u2019origine.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:43:42-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"SOL0083 Opening a CSV File Without Excel Reformatting it","ga_ans_id":"ANS-1871","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The 'Get External Data' section name is less prominent or has been replaced by 'Get & Transform Data'.; The direct 'From Text' option under the Data tab is now often replaced by 'Get & Transform Data' and requires enabling 'Show legacy data import wizards' in Excel Options to access 'From Text (Legacy)'.","ga_final_category":"CSV Import & Data Migration","footnotes":""},"ga_category":[20,96,96],"ga_audience":[89],"ga_difficulty":[93],"class_list":["post-3610","qa_entry","type-qa_entry","status-publish","hentry","ga_category-csv-import-data-migration","ga_category-import-csv-et-migration-de-donnees","ga_audience-administrateur-netsuite","ga_difficulty-debutant"],"taxonomy_info":{"ga_category":[{"value":20,"label":"CSV Import & Data Migration"},{"value":96,"label":"Import CSV et migration de donn\u00e9es"},{"value":96,"label":"Import CSV et migration de donn\u00e9es"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3610\/revisions"}],"predecessor-version":[{"id":5530,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3610\/revisions\/5530"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3610"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3610"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3610"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}