{"id":23637,"date":"2026-08-21T11:43:38","date_gmt":"2026-08-21T11:43:38","guid":{"rendered":"https:\/\/help.traceparts.com\/?post_type=docs&#038;p=23637"},"modified":"2026-09-28T08:34:51","modified_gmt":"2026-09-28T08:34:51","slug":"renseigner-le-template","status":"publish","type":"docs","link":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/","title":{"rendered":"Renseigner le template"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"23637\" class=\"elementor elementor-23637\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5efbb19 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5efbb19\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3665c55\" data-id=\"3665c55\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-769339a elementor-widget elementor-widget-docly_alerts_box\" data-id=\"769339a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"docly_alerts_box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t        \n        \n        \n        \n                    <div class=\"note-with-icon nic-alert nic-alert-info\">\n                <div class=\"nic-content-wrap\">\n                                        <div class=\"info-tab note-icon\" title=\"Important Notes\">\n                        <div class=\"icon-wrapper\">\n                            <i aria-hidden=\"true\" class=\" icon_lightbulb_alt\"><\/i>                        <\/div>\n                    <\/div>\n                                        <div class=\"note-box\">\n\t                    \t                    <p>Par d\u00e9faut Windows bloque l\u2019utilisation de macros dans Excel, il faudra donc d\u00e9bloquer celui-ci en ouvrant ses propri\u00e9t\u00e9s dans un explorateur windows.<\/p>\n                    <\/div>\n                <\/div>\n            <\/div>\n        \n        \n        \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-008bb78 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"008bb78\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-36dec44\" data-id=\"36dec44\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-78a772e elementor-widget elementor-widget-text-editor\" data-id=\"78a772e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Le fichier du template contient une macro, con\u00e7ue pour cr\u00e9er la structure de fichier correspondant \u00e0 vos besoins. Pour ce faire, il appelle une bo\u00eete de dialogue contenant un certain nombre de questions auxquelles vous devez r\u00e9pondre.<\/p><ul><li>Double-cliquez sur le fichier pour l\u2019ouvrir dans Microsoft Excel.<\/li><li>Si un message d\u2019avertissement appara\u00eet au sujet de la macro, cliquez sur le bouton \u00ab Activer les macros \u00bb.<\/li><li>Cliquez sur le bouton \u00ab Cr\u00e9er la structure \u00bb pour ex\u00e9cuter la macro.<\/li><li>Une bo\u00eete de dialogue, comme celle ci-dessous, appara\u00eetra \u00e0 l\u2019\u00e9cran. (Si ce n\u2019est pas le cas, ce doit \u00eatre parce que vous avez d\u00e9sactiv\u00e9 les macros. Consultez alors la documentation de Microsoft Excel pour savoir comment r\u00e9activer les macros.)<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-75a6401 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"75a6401\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6bfc23b\" data-id=\"6bfc23b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-009b4f8 elementor-widget elementor-widget-image\" data-id=\"009b4f8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"602\" height=\"629\" src=\"https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf.png\" class=\"attachment-large size-large wp-image-23618\" alt=\"\" srcset=\"https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf.png 602w, https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf-287x300.png 287w, https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf-16x16.png 16w, https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf-18x18.png 18w, https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf-20x20.png 20w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Par d\u00e9faut Windows bloque l\u2019utilisation de macros dans Excel, il faudra donc d\u00e9bloquer celui-ci en ouvrant ses propri\u00e9t\u00e9s dans un explorateur windows. Le fichier du template contient une macro, con\u00e7ue pour cr\u00e9er la structure de fichier correspondant \u00e0 vos besoins. Pour ce faire, il appelle une bo\u00eete de dialogue contenant un certain nombre de questions [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"parent":23605,"menu_order":2,"template":"","doc_tag":[],"doc_badge":[],"class_list":["post-23637","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Help Center TraceParts - Renseigner le template<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Help Center TraceParts - Renseigner le template\" \/>\n<meta property=\"og:description\" content=\"Par d\u00e9faut Windows bloque l\u2019utilisation de macros dans Excel, il faudra donc d\u00e9bloquer celui-ci en ouvrant ses propri\u00e9t\u00e9s dans un explorateur windows. Le fichier du template contient une macro, con\u00e7ue pour cr\u00e9er la structure de fichier correspondant \u00e0 vos besoins. Pour ce faire, il appelle une bo\u00eete de dialogue contenant un certain nombre de questions [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center TraceParts\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-28T08:34:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/renseigner-le-template\\\/\",\"url\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/renseigner-le-template\\\/\",\"name\":\"Help Center TraceParts - Renseigner le template\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/renseigner-le-template\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/renseigner-le-template\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/help.traceparts.com\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Excel_wizarf.png\",\"datePublished\":\"2026-08-21T11:43:38+00:00\",\"dateModified\":\"2026-09-28T08:34:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/renseigner-le-template\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/renseigner-le-template\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/renseigner-le-template\\\/#primaryimage\",\"url\":\"https:\\\/\\\/help.traceparts.com\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Excel_wizarf.png\",\"contentUrl\":\"https:\\\/\\\/help.traceparts.com\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Excel_wizarf.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/renseigner-le-template\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/help.traceparts.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TraceParts Publishing Studio\",\"item\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Cr\u00e9ation de produits\",\"item\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Par batch\",\"item\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Pr\u00e9paration des donn\u00e9es\",\"item\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/docs\\\/traceparts-publishing-studio\\\/creation-de-produits\\\/par-batch\\\/preparation-des-donnees\\\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Renseigner le template\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/\",\"name\":\"Help Center TraceParts\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/help.traceparts.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Help Center TraceParts - Renseigner le template","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"fr_FR","og_type":"article","og_title":"Help Center TraceParts - Renseigner le template","og_description":"Par d\u00e9faut Windows bloque l\u2019utilisation de macros dans Excel, il faudra donc d\u00e9bloquer celui-ci en ouvrant ses propri\u00e9t\u00e9s dans un explorateur windows. Le fichier du template contient une macro, con\u00e7ue pour cr\u00e9er la structure de fichier correspondant \u00e0 vos besoins. Pour ce faire, il appelle une bo\u00eete de dialogue contenant un certain nombre de questions [&hellip;]","og_url":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/","og_site_name":"Help Center TraceParts","article_modified_time":"2026-09-28T08:34:51+00:00","og_image":[{"url":"https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/","url":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/","name":"Help Center TraceParts - Renseigner le template","isPartOf":{"@id":"https:\/\/help.traceparts.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/#primaryimage"},"image":{"@id":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/#primaryimage"},"thumbnailUrl":"https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf.png","datePublished":"2026-08-21T11:43:38+00:00","dateModified":"2026-09-28T08:34:51+00:00","breadcrumb":{"@id":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/#primaryimage","url":"https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf.png","contentUrl":"https:\/\/help.traceparts.com\/wp-content\/uploads\/2026\/08\/Excel_wizarf.png"},{"@type":"BreadcrumbList","@id":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/renseigner-le-template\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/help.traceparts.com\/"},{"@type":"ListItem","position":2,"name":"TraceParts Publishing Studio","item":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/"},{"@type":"ListItem","position":3,"name":"Cr\u00e9ation de produits","item":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/"},{"@type":"ListItem","position":4,"name":"Par batch","item":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/"},{"@type":"ListItem","position":5,"name":"Pr\u00e9paration des donn\u00e9es","item":"https:\/\/help.traceparts.com\/fr\/docs\/traceparts-publishing-studio\/creation-de-produits\/par-batch\/preparation-des-donnees\/"},{"@type":"ListItem","position":6,"name":"Renseigner le template"}]},{"@type":"WebSite","@id":"https:\/\/help.traceparts.com\/fr\/#website","url":"https:\/\/help.traceparts.com\/fr\/","name":"Help Center TraceParts","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.traceparts.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"}]}},"author_avatar":"https:\/\/secure.gravatar.com\/avatar\/92e5061e97b62f1e64ac1cdff2e7c016e50a92e5cdfb9c55613d7c45b185ccb3?s=96&d=mm&r=g","author_name":"Yoann Tiennot","_links":{"self":[{"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/docs\/23637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/users\/8"}],"version-history":[{"count":6,"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/docs\/23637\/revisions"}],"predecessor-version":[{"id":24248,"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/docs\/23637\/revisions\/24248"}],"up":[{"embeddable":true,"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/docs\/23605"}],"wp:attachment":[{"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/media?parent=23637"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/doc_tag?post=23637"},{"taxonomy":"doc_badge","embeddable":true,"href":"https:\/\/help.traceparts.com\/fr\/wp-json\/wp\/v2\/doc_badge?post=23637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}