{"id":520,"date":"2018-04-05T11:11:58","date_gmt":"2018-04-05T18:11:58","guid":{"rendered":"http:\/\/www.ghosh.com\/blog\/?p=520"},"modified":"2025-05-17T14:45:07","modified_gmt":"2025-05-17T21:45:07","slug":"url-decode-formula-for-excel","status":"publish","type":"post","link":"https:\/\/www.ghosh.com\/blog\/url-decode-formula-for-excel\/","title":{"rendered":"URL Decode formula for Excel"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;--awb-margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-1 fusion-text-no-margin\" style=\"--awb-margin-bottom:3%;\"><p>Excel provides a EncodeURL() function to encode URLs, but surprisingly does not provide any function to decode a URL (e.g., DecodeURL or UnencodeURL).\u00a0 Instead, you can use the following formula:<\/p>\n<\/div>'=LET(\n    src, A1,\n    codes, {\n        \"%C3%A4\",\"%C3%84\",\n        \"%C3%B6\",\"%C3%96\",\n        \"%C3%A5\",\"%C3%85\",\n        \"%C3%BC\",\"%C3%9C\",\n        \"%C3%A9\",\"%C3%89\",\n        \"%C3%B1\",\"%C3%91\",\n        \"%C3%A7\",\"%C3%87\",\n        \"%C3%9F\",\n        \"%3F\",\"%20\",\"%25\",\"%26\",\"%3D\",\"%7B\",\"%7D\",\"%5B\",\"%5D\",\n        \"%3A\",\"%22\",\"%2F\",\"%2B\",\"%21\",\"%23\",\"%24\",\"%2A\",\"%27\",\n        \"%28\",\"%29\",\"%2C\",\"%3B\",\"%40\"\n    },\n    repl, {\n        \"\u00e4\",\"\u00c4\",\n        \"\u00f6\",\"\u00d6\",\n        \"\u00e5\",\"\u00c5\",\n        \"\u00fc\",\"\u00dc\",\n        \"\u00e9\",\"\u00c9\",\n        \"\u00f1\",\"\u00d1\",\n        \"\u00e7\",\"\u00c7\",\n        \"\u00df\",\n        \"?\",\" \",\"%\",\"&\",\"=\",\"{\",\"}\",\"[\",\"]\",\n        \":\",\"\"\"\",\"\/\",\"+\",\"!\",\"#\",\"$\",\"*\",\"'\",\"(\",\")\",\",\",\";\",\"@\"\n    },\n    REDUCE(\n        src,\n        SEQUENCE(COUNTA(codes)),\n        LAMBDA(s, i, SUBSTITUTE(s, INDEX(codes, i), INDEX(repl, i)))\n    )\n)<div class=\"fusion-text fusion-text-2\" style=\"--awb-margin-top:3%;\"><p>Change &#8220;A1&#8221; to the cell address containing your encoded URL.<\/p>\n<p>Please let me know if I&#8217;ve missed any codes and I&#8217;ll update the formula.<\/p>\n<h6>Thanks to <a href=\"https:\/\/searchmarketingcorner.wordpress.com\/2013\/03\/27\/creating-an-excel-formula-to-encode-or-unencode-urls\/\" target=\"_blank\" rel=\"noopener\">Christi Olson<\/a> for providing basis of the formula.\u00a0 I completed it with some missing pieces.<\/h6>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":522,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-520","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/posts\/520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/comments?post=520"}],"version-history":[{"count":6,"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/posts\/520\/revisions"}],"predecessor-version":[{"id":1644,"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/posts\/520\/revisions\/1644"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/media\/522"}],"wp:attachment":[{"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/media?parent=520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/categories?post=520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ghosh.com\/blog\/wp-json\/wp\/v2\/tags?post=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}