{"id":6519,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/urlencodage\/"},"modified":"2021-02-26T08:05:41","modified_gmt":"2021-02-26T08:05:41","slug":"encodeurl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/encodeurl\/","title":{"rendered":"URLENCODAGE"},"content":{"rendered":"

Description de la Fonction<\/h2>\n

La fonction ENCODEURL<\/code> dans Microsoft Excel et URLENCODAGE<\/code> dans Google Sheets permettent d’encoder une URL. Cette op\u00e9ration est essentielle lors de l’int\u00e9gration d’URLs dans des requ\u00eates web ou leur envoi \u00e0 travers Internet, garantissant ainsi que tous les caract\u00e8res sp\u00e9ciaux sont convertis de mani\u00e8re \u00e0 \u00eatre correctement interpr\u00e9t\u00e9s par les serveurs web. Voici la syntaxe g\u00e9n\u00e9rale de la fonction :<\/p>\n

ENCODEURL(texte)<\/code><\/pre>\n
Dans Excel :<\/p>\n
ENCODEURL(\"http:\/\/www.example.com\")<\/code><\/pre>\n
Retourne : http%3A%2F%2Fwww.example.com<\/p>\n
Dans Google Sheets :<\/p>\n
URLENCODAGE(\"http:\/\/www.example.com\")<\/code><\/pre>\n
Retourne : http%3A%2F%2Fwww.example.com<\/p>\n
Exemples Pratiques d’utilisation<\/h2>\n
1. Pr\u00e9paration des URLs pour une Requ\u00eate GET<\/h3>\n
Supposez que vous devez envoyer une requ\u00eate GET via une API web et incorporer des param\u00e8tres comportant des espaces ou des caract\u00e8res sp\u00e9ciaux. ENCODEURL<\/code> vous permet de pr\u00e9parer l’URL de mani\u00e8re s\u00e9curis\u00e9e :<\/p>\n
=ENCODEURL(\"http:\/\/api.example.com\/data?query=le\u00e7on de Fran\u00e7ais\")<\/code><\/pre>\n
R\u00e9sultat :<\/p>\n
\"http:\/\/api.example.com\/data?query=le%C3%A7on%20de%20Fran%C3%A7ais\"<\/code><\/pre>\n
Cette URL encod\u00e9e peut \u00eatre utilis\u00e9e sans craindre de malinterpretation due aux espaces ou diacritiques tels que ‘\u00e7’ dans les requ\u00eates web.<\/p>\n
2. \u00c9crire des URLs dans des documents Web s\u00e9curis\u00e9s<\/h3>\n
Pour un projet impliquant la g\u00e9n\u00e9ration dynamique de documents HTML ou d’autres types de documents web, il est crucial de veiller \u00e0 ce que tous les URLs soient correctement encod\u00e9s pour \u00e9viter des probl\u00e8mes de s\u00e9curit\u00e9 tels que les attaques XSS (Cross-Site Scripting). Voici comment encoder dynamiquement des URLs en utilisant les valeurs des cellules Excel ou Google Sheets :<\/p>\n
Dans Excel :<\/p>\n
=\"Lien vers le site: \" & ENCODEURL(\"http:\/\/www.exemple.com\/page?ref=\" & A1)<\/code><\/pre>\n
Dans Google Sheets :<\/p>\n
=\"Lien vers le site: \" & URLENCODAGE(\"http:\/\/www.exemple.com\/page?ref=\" & A1)<\/code><\/pre>\n
O\u00f9 A1<\/code> peut contenir une r\u00e9f\u00e9rence telle que \u00ab\u00a0Nouvel utilisateur\u00a0\u00bb. L’URL obtenue est exempte d’erreurs d’interpr\u00e9tation et pr\u00eate \u00e0 \u00eatre int\u00e9gr\u00e9e de fa\u00e7on s\u00e9curis\u00e9e dans tout contexte web.<\/p>\n
Applications En R\u00e9sum\u00e9<\/h2>\n
    \n
  • Pr\u00e9paration de liens pour des requ\u00eates HTTP s\u00e9curis\u00e9es.<\/li>\n
  • G\u00e9n\u00e9ration automatis\u00e9e de documents web int\u00e9grant des URLs.<\/li>\n
  • Assurance d’une interpr\u00e9tation correcte des param\u00e8tres URL dans divers environnements de programmation.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
    Renvoie une cha\u00eene cod\u00e9e au format URL<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[323],"tags":[],"class_list":["post-6519","post","type-post","status-publish","format-standard","hentry","category-sites"],"acf":[],"yoast_head":"\nFonction ENCODEURL (URLENCODAGE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ENCODEURL (URLENCODAGE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/encodeurl\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ENCODEURL (URLENCODAGE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ENCODEURL (URLENCODAGE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/encodeurl\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:05:41+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ENCODEURL (URLENCODAGE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/encodeurl\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/encodeurl\/\",\"name\":\"Fonction ENCODEURL (URLENCODAGE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:05:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ENCODEURL (URLENCODAGE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/encodeurl\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/encodeurl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/encodeurl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sites\",\"item\":\"https:\/\/functiontranslator.com\/fr\/sites\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"URLENCODAGE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction ENCODEURL (URLENCODAGE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ENCODEURL (URLENCODAGE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/encodeurl\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ENCODEURL (URLENCODAGE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ENCODEURL (URLENCODAGE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/encodeurl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ENCODEURL (URLENCODAGE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/encodeurl\/","url":"https:\/\/functiontranslator.com\/fr\/encodeurl\/","name":"Fonction ENCODEURL (URLENCODAGE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:05:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ENCODEURL (URLENCODAGE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/encodeurl\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/encodeurl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/encodeurl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Sites","item":"https:\/\/functiontranslator.com\/fr\/sites\/"},{"@type":"ListItem","position":3,"name":"URLENCODAGE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6519"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6519\/revisions"}],"predecessor-version":[{"id":29531,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6519\/revisions\/29531"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}