{"id":9710,"date":"2022-05-17T18:35:26","date_gmt":"2022-05-17T18:35:26","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9710"},"modified":"2024-02-19T14:52:24","modified_gmt":"2024-02-19T14:52:24","slug":"extract-domain-from-url","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/","title":{"rendered":"Extract Domain from URL in Excel"},"content":{"rendered":"\n
Extract-Domain-from-URL<\/a>Download File<\/a><\/div>\n\n\n\n

You can use Excel to process huge lists of URLs and generate useful reports such as a report on new links to a website. To accomplish this easily you will first need to extract domain names from the URLs.<\/p>\n\n\n\n

A domain name is a unique website address that appears after www.<\/strong> and before the first slash (\/) character in a web address. For example, in the URL https:\/\/codeigo.com\/python\/convert-csv-to-excel\/<\/a>, the domain name is codeigo.com<\/a>.<\/p>\n\n\n\n

In this tutorial, we will look at the following 3 methods that can be used to extract domain names from URLs:<\/p>\n\n\n\n

    \n
  1. Use of an Excel Formula<\/strong>.<\/li>\n\n\n\n
  2. Use Excel Find and Replace Feature<\/strong> with wildcards<\/strong>.<\/li>\n\n\n\n
  3. Using Free Add-in<\/strong> with custom functions.<\/li>\n<\/ol>\n\n\n\n

    Method 1: Use of an Excel Formula<\/h2>\n\n\n\n

     Step 1<\/strong> \u2013 Select Cell B2<\/strong> and key in the following formula.<\/p>\n\n\n\n

    =IF(ISERROR(FIND(\"\/\/www.\",A2)), MID(A2,FIND(\":\",A2,4)+3,FIND(\"\/\",A2,9)-FIND(\":\",A2,4)-3), MID(A2,FIND(\":\",A2,4)+7,FIND(\"\/\",A2,9)-FIND(\":\",A2,4)-7))<\/code><\/pre>\n\n\n\n
    Step 2<\/strong> \u2013 Press Enter<\/strong> key and since the data is in a table, Excel automatically copies the formula to all the cells in Column B<\/strong>:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    All the domain names have been extracted from the URLs.<\/p>\n\n\n\n
    To convert the formula results in Column B into values, proceed as follows:<\/p>\n\n\n\n
    Step 3<\/strong> \u2013 Select any cell in Column B and press Ctrl + Space<\/strong> to select the cells in the Column.<\/p>\n\n\n\n
    Step 4<\/strong> \u2013 Press Ctrl + C<\/strong> to copy the formula results to the Clipboard.<\/p>\n\n\n\n
    Step 5<\/strong> \u2013 Right-click cell C2<\/strong> and paste formulas as values:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    The domain values will be pasted into Column C:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Explanation of the formula<\/h3>\n\n\n\n
    =IF(ISERROR(FIND(\"\/\/www.\",A2)), MID(A2,FIND(\":\",A2,4)+3,FIND(\"\/\",A2,9)-FIND(\":\",A2,4)-3), MID(A2,FIND(\":\",A2,4)+7,FIND(\"\/\",A2,9)-FIND(\":\",A2,4)-7))<\/code><\/pre>\n\n\n\n
    This formula uses 4 functions:<\/p>\n\n\n\n
      \n
    1. The IF function<\/strong> checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.<\/li>\n\n\n\n
    2. The ISERROR function<\/strong> checks whether a value is an error, for example, #N\/A and returns TRUE or FALSE.<\/li>\n\n\n\n
    3. The MID function<\/strong> returns the characters from the middle of a text string, given a starting position and length.<\/li>\n\n\n\n
    4. The FIND function<\/strong> returns the starting position of one text string within another text string. It is case-sensitive.<\/li>\n<\/ol>\n\n\n\n
      Stepping through the formula<\/h3>\n\n\n\n
        \n
      1. FIND(“\/\/www.”,A2)<\/strong> returns the starting position of the \/\/www. string in the URL in Cell A2. If the string is not present a #N\/A error is generated.<\/li>\n\n\n\n
      2. The value generated by the FIND function is passed to the ISERROR function. If it is an error the ISERROR(FIND(“\/\/www.”,A2))<\/strong> returns TRUE otherwise it returns FALSE.<\/li>\n\n\n\n
      3. TRUE means that \/\/www. string was not found in the URL and therefore MID(A2,FIND(“:”,A2,4)+3,FIND(“\/”,A2,9)-FIND(“:”,A2,4)-3)<\/strong> part of the formula is applied to extract the domain name.<\/li>\n\n\n\n
      4. FALSE means that the \/\/www. text string was found in the URL and therefore MID(A2,FIND(“:”,A2,4)+7,FIND(“\/”,A2,9)-FIND(“:”,A2,4)-7)<\/strong> part of the formula is applied to extract the domain name.<\/li>\n<\/ol>\n\n\n\n
        Method 2: Use the Find and Replace Feature with a wildcard character<\/h2>\n\n\n\n
        With the help Using the combination of the Find and Replace feature and a wildcard character will extract the domain names easily.<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Step 1<\/strong> \u2013 Select URLs and then press Ctrl + F<\/strong> to launch the Find and Replace<\/strong> dialog box, then click the Replace<\/strong> tab:<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Step 3<\/strong> \u2013 To remove the protocol before the URL, type *www. in the Find what <\/strong>box, leave the Replace with <\/strong>box blank and then press Replace All<\/strong> button:<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Step 4<\/strong> \u2013 Click OK on the popup Excel message box to accept the changes. All the protocols containing www. have been replaced with empty strings:<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Step 5<\/strong> \u2013 Repeat step 3 but now type in *:\/\/ in the Find what box. All the remaining protocols are removed:<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Step 6<\/strong> \u2013 To remove the paths after the domains, repeat step 3 but now type in \/* in the Find what box. All the paths will be removed leaving you with only the domain names:<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        In this method, we first had to remove the protocol in the URL and then the path following the domain name.<\/p>\n\n\n\n
        Method 3: Use free SEO Excel Add-in<\/h2>\n\n\n\n
        The easiest and quickest way to extract a domain name from a URL is to use an add-in. You can download it for free from the main page<\/a>.<\/p>\n\n\n\n
        After you install the add-in, you can start using it.<\/p>\n\n\n\n
        Select the URLs you want to convert and click the Get Domain<\/strong> button in SEO >> Convert URLs<\/strong>.<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Another way you can use this tool is by clicking the URL Converter<\/strong> button. After you click it, you can select one of the options:<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Each option gives different results:<\/p>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        Using Custom Functions<\/h3>\n\n\n\n
        If you prefer to use functions, you can use a function called:<\/p>\n\n\n\n
        =SEO.GETDOMAIN(url, [param])<\/code><\/pre>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        The function takes one or two parameters. If there is no second parameter, the function works the same as:<\/p>\n\n\n\n
        =SEO.GETDOMAIN(url, 1)<\/code><\/pre>\n\n\n\n
        The additional optional parameters are 2<\/strong>, 3<\/strong>, and 4<\/strong>, and they work the same as the example used before.<\/p>\n\n\n\n
        \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
        You can use Excel to process huge lists of URLs and generate useful reports such as a report on new links to a…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170,150],"yoast_head":"\nExtract Domain from URL in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to extract domain names from URLs in Excel using formulas, Find and Replace, and add-ins. Download the Extract-Domain-from-URL file.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extract Domain from URL in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to extract domain names from URLs in Excel using formulas, Find and Replace, and add-ins. Download the Extract-Domain-from-URL file.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-17T18:35:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:52:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Extract Domain from URL in Excel\",\"datePublished\":\"2022-05-17T18:35:26+00:00\",\"dateModified\":\"2024-02-19T14:52:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/\"},\"wordCount\":767,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png\",\"keywords\":[\"file\",\"SEO\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/\",\"name\":\"Extract Domain from URL in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png\",\"datePublished\":\"2022-05-17T18:35:26+00:00\",\"dateModified\":\"2024-02-19T14:52:24+00:00\",\"description\":\"Learn how to extract domain names from URLs in Excel using formulas, Find and Replace, and add-ins. Download the Extract-Domain-from-URL file.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png\",\"width\":641,\"height\":163},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extract Domain from URL in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Extract Domain from URL in Excel","description":"Learn how to extract domain names from URLs in Excel using formulas, Find and Replace, and add-ins. Download the Extract-Domain-from-URL file.","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:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/","og_locale":"en_US","og_type":"article","og_title":"Extract Domain from URL in Excel","og_description":"Learn how to extract domain names from URLs in Excel using formulas, Find and Replace, and add-ins. Download the Extract-Domain-from-URL file.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/","article_published_time":"2022-05-17T18:35:26+00:00","article_modified_time":"2024-02-19T14:52:24+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Extract Domain from URL in Excel","datePublished":"2022-05-17T18:35:26+00:00","dateModified":"2024-02-19T14:52:24+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/"},"wordCount":767,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png","keywords":["file","SEO"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/","url":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/","name":"Extract Domain from URL in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png","datePublished":"2022-05-17T18:35:26+00:00","dateModified":"2024-02-19T14:52:24+00:00","description":"Learn how to extract domain names from URLs in Excel using formulas, Find and Replace, and add-ins. Download the Extract-Domain-from-URL file.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/05\/extracted-domain-names.png","width":641,"height":163},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/extract-domain-from-url\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Extract Domain from URL in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9710"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=9710"}],"version-history":[{"count":8,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9710\/revisions"}],"predecessor-version":[{"id":13756,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9710\/revisions\/13756"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=9710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=9710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=9710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}