{"id":15389,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/urlkodla\/"},"modified":"2021-02-25T16:26:24","modified_gmt":"2021-02-25T16:26:24","slug":"encodeurl","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/encodeurl\/","title":{"rendered":"URLKODLA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets’te bulunan ENCODEURL (T\u00fcrk\u00e7e versiyonlarda URLKODLA olarak bilinir) fonksiyonu, URI kodlamas\u0131n\u0131 kullanarak URL’leri uygun bi\u00e7ime d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon genelde web tabanl\u0131 kaynaklara olan ba\u011flant\u0131lar\u0131 veya API \u00e7a\u011fr\u0131lar\u0131n\u0131 olu\u015ftururken tercih edilir. A\u015fa\u011f\u0131da, bu fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131na dair detayl\u0131 bir rehber bulacaks\u0131n\u0131z.<\/p>\n

URLKODLA Fonksiyonunun S\u00f6zdizimi<\/h2>\n

URLKODLA fonksiyonunun s\u00f6zdizimi olduk\u00e7a basittir:<\/p>\n

=URLKODLA(metin)<\/code><\/pre>\n
    \n
  • metin<\/strong>: Kodlanacak metindir. Bu metin, fonksiyona do\u011frudan girilebilir veya bir h\u00fccre referans\u0131yla sa\u011flanabilir.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m:<\/p>\n
    =URLKODLA(\"https:\/\/www.example.com\/ana sayfa?arama=test de\u011feri\")<\/code><\/pre>\n
    Bu form\u00fcl, bo\u015fluklar\u0131 “%20” ile ve di\u011fer \u00f6zel karakterleri uygun \u015fekilde kodlam\u0131\u015f bir metni \u00e7\u0131kt\u0131 olarak verir.<\/p>\n
    Pratik Kullan\u0131m Alanlar\u0131<\/h2>\n
    URLKODLA fonksiyonu, web tabanl\u0131 uygulamalarda veri al\u0131\u015fveri\u015finde kritik bir role sahiptir. \u0130\u015fte bu fonksiyonun kullan\u0131labilece\u011fi tipik iki senaryo:<\/p>\n
    Senaryo 1: Web Ba\u011flant\u0131lar\u0131 Olu\u015fturma<\/h2>\n
    \u00d6rne\u011fin, bir Excel tablosunda kullan\u0131c\u0131lar\u0131n girdi\u011fi \u00e7e\u015fitli arama terimleri bulunuyor ve bu terimler ile bir arama motorunda sorgu yapacak URL’ler olu\u015fturman\u0131z gerekiyor. Bu i\u015flemi \u015fu ad\u0131mlarla ger\u00e7ekle\u015ftirebilirsiniz:<\/p>\n
      \n
    1. Tablonuzda ‘Arama Terimi’ ba\u015fl\u0131\u011f\u0131 ile A s\u00fctununu kullan\u0131n.<\/li>\n
    2. B s\u00fctunu i\u00e7in “URL” ba\u015fl\u0131\u011f\u0131n\u0131 ekleyin.<\/li>\n
    3. B2 h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaz\u0131n:<\/li>\n<\/ol>\n
      =URLKODLA(\"https:\/\/www.google.com\/search?q=\" & A2)<\/code><\/pre>\n
        \n
      • Bu form\u00fcl, A2 h\u00fccresindeki arama terimini al\u0131r, Google arama URL’sine ekler ve t\u00fcm metni URL olarak kodlar.<\/li>\n
      • Form\u00fcl\u00fc B s\u00fctunundaki di\u011fer h\u00fccrelere kopyalayarak her bir arama terimi i\u00e7in uygun URL’leri kolayca olu\u015fturabilirsiniz.<\/li>\n<\/ul>\n
        Senaryo 2: API \u00c7a\u011fr\u0131lar\u0131 \u0130\u00e7in URL Olu\u015fturma<\/h2>\n
        E\u011fer s\u00fcrekli de\u011fi\u015fen verileri bir API \u00fczerinden almak isteyen bir Excel kullan\u0131c\u0131s\u0131ysan\u0131z, dinamik parametrelerle API URL’inizi olu\u015fturman\u0131z gerekir. \u0130\u015fte bu durumda kullanabilece\u011finiz URLKODLA fonksiyonuna bir \u00f6rnek:<\/p>\n\n\n\n\n
        Parametre<\/th>\nDe\u011fer<\/th>\n<\/tr>\n
        API Anahtar\u0131<\/td>\nXYZ123<\/td>\n<\/tr>\n
        Kullan\u0131c\u0131 ID<\/td>\n789<\/td>\n<\/tr>\n<\/table>\n
        =URLKODLA(\"https:\/\/api.example.com\/data?apiKey=\" & B1 & \"&userId=\" & B2)<\/code><\/pre>\n
          \n
        • Burada B1 ve B2 h\u00fccresi, yukar\u0131daki tabloda belirtilen de\u011ferleri i\u00e7erir.<\/li>\n
        • Bu form\u00fcl, API anahtar\u0131n\u0131 ve kullan\u0131c\u0131 ID’sini URL’e dahil eder ve t\u00fcm bilgileri uygun \u015fekilde kodlar.<\/li>\n<\/ul>\n
          G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere, URLKODLA fonksiyonu hem web ba\u011flant\u0131lar\u0131 hem de API \u00e7a\u011fr\u0131lar\u0131 olu\u015ftururken son derece i\u015flevseldir. \u00d6nemli olan, metinleri do\u011fru bir \u015fekilde kodlamak ve hata yapmaks\u0131z\u0131n etkili bir URL olu\u015fturmakt\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
          URL ile kodlanm\u0131\u015f bir dize verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[590],"tags":[],"class_list":["post-15389","post","type-post","status-publish","format-standard","hentry","category-web-13"],"acf":[],"yoast_head":"\nExcel'de ENCODEURL (URLKODLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ENCODEURL (URLKODLA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/encodeurl\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ENCODEURL (URLKODLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ENCODEURL (URLKODLA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/encodeurl\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:26:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de ENCODEURL (URLKODLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/encodeurl\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/encodeurl\/\",\"name\":\"Excel'de ENCODEURL (URLKODLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:26:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ENCODEURL (URLKODLA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/encodeurl\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/encodeurl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/encodeurl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Web\",\"item\":\"https:\/\/functiontranslator.com\/tr\/web-13\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"URLKODLA\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de ENCODEURL (URLKODLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ENCODEURL (URLKODLA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/encodeurl\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ENCODEURL (URLKODLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ENCODEURL (URLKODLA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/encodeurl\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:26:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ENCODEURL (URLKODLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/encodeurl\/","url":"https:\/\/functiontranslator.com\/tr\/encodeurl\/","name":"Excel'de ENCODEURL (URLKODLA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:26:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ENCODEURL (URLKODLA) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/encodeurl\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/encodeurl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/encodeurl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Web","item":"https:\/\/functiontranslator.com\/tr\/web-13\/"},{"@type":"ListItem","position":3,"name":"URLKODLA"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15389"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15389\/revisions"}],"predecessor-version":[{"id":26657,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15389\/revisions\/26657"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}