{"id":1732,"date":"2012-05-06T19:05:34","date_gmt":"2012-05-06T17:05:34","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=1732"},"modified":"2014-05-06T21:58:56","modified_gmt":"2014-05-06T19:58:56","slug":"importer-un-fichier-texte-dans-excel","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=1732","title":{"rendered":"Importer un fichier texte dans EXCEL"},"content":{"rendered":"<p style=\"text-align: justify;\">Les donn\u00e9es extraites des syst\u00e8mes d\u2019information sont g\u00e9n\u00e9ralement obtenues sous forme de fichiers texte. Un fichier texte n\u2019est pas directement lisible pas EXCEL, il n\u00e9cessite auparavant une conversion en feuille de calcul. Pour ce faire, une proc\u00e9dure d\u2019importation doit \u00eatre mise en \u0153uvre.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/05\/EXCEL-Import-ASCII-2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1734\" title=\"EXCEL Import ASCII (\u00e9tape 1 sur 3)\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/05\/EXCEL-Import-ASCII-2.jpg\" alt=\"\" width=\"702\" height=\"420\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/05\/EXCEL-Import-ASCII-2.jpg 702w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/05\/EXCEL-Import-ASCII-2-300x179.jpg 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2012\/05\/EXCEL-Import-ASCII-2-1x1.jpg 1w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">L\u2019importation dans EXCEL se d\u00e9roule en deux \u00e9tapes : tout d\u2019abord identification du type de fichier texte puis importation des donn\u00e9es et identification des champs de donn\u00e9es. La proc\u00e9dure d\u2019importation est d\u00e9crite \u00e9tape par \u00e9tape dans le document \u00e0 t\u00e9l\u00e9charger ci-apr\u00e8s.<\/p>\n<p style=\"text-align: justify;\"><a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"http:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d&#8217;articles Ma\u00eetriser Excel<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Importer%20un%20fichier%20texte%20dans%20EXCEL\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les donn\u00e9es extraites des syst\u00e8mes d\u2019information sont g\u00e9n\u00e9ralement obtenues sous forme de fichiers texte. Un fichier texte n\u2019est pas directement lisible pas EXCEL, il n\u00e9cessite auparavant une conversion en feuille de calcul. Pour ce faire, une proc\u00e9dure d\u2019importation doit \u00eatre mise en \u0153uvre. L\u2019importation dans EXCEL se d\u00e9roule en deux \u00e9tapes : tout d\u2019abord identification &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=1732\" class=\"more-link\">Continue reading &lsquo;Importer un fichier texte dans EXCEL&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Importer%20un%20fichier%20texte%20dans%20EXCEL\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[50,7,8,1326,470],"tags":[166,940,1634,989,990,308,939,988,1633,52,986,109,985,987,1624,663],"class_list":["post-1732","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-breves","category-extractions-de-donnees","category-maitriser-excel","category-techniques-daudit","tag-analyse-de-donnees","tag-ascii","tag-audit-de-donnees","tag-champ-de-donnees","tag-coma-separated-value","tag-conversion-de-fichier","tag-csv","tag-delimite","tag-excel","tag-exploitation-des-donnees","tag-fichier-texte","tag-format-de-fichier","tag-importation-de-donnees","tag-separateur","tag-systeme-dinformation","tag-tutoriel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1732"}],"version-history":[{"count":10,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1732\/revisions"}],"predecessor-version":[{"id":4810,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/1732\/revisions\/4810"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}