Excel + Google

A

alifihri

New Member
Joined
Apr 5, 2023
Messages
3
Office Version
  1. 2019
Platform
  1. Windows
Hi Everyone I wanted help finding the number of Google search results for each keyword/Box.
For example:
Google search results for these keywords are:
Football: 3,920,000,000 results
Beauty: 6,470,000,000 results
Cinema: 2,870,000,000 results
What I need is a formula that provides me with these numbers for each keyword.
image_2023-04-06_032305643.png

I hope you get my point.
And finally I wanted to ask if there any course or source to learn to do such things like finding number of results, first result, result titles of each keyword. It's like using the power of google and excel at once.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
To get the number of search results for keywords, you need to use Google's Custom Search API.
First, enable Custom Search API for your Google account and follow instructions in this article.
Second, write a simple VBA subroutine that makes an API call with the given API key and a CX value you generated above:
VBA Code: 
Option Explicit

Public Sub GetGoogleSearchResults()
    Const API As String = "API_KEY"
    Dim strUrl As String
    strUrl = "https://customsearch.googleapis.com/customsearch/v1"
    strUrl = strUrl & "?key=" & API
    Dim strKeyword As String
    strKeyword = "football"
    strUrl = strUrl & "&q=" & URLEncode(strKeyword)
    Const CX As String = "CX"
    strUrl = strUrl & "&cx=" & CX
    Dim objWinHttp As WinHttp.WinHttpRequest
    Set objWinHttp = New WinHttp.WinHttpRequest
    With objWinHttp
        .Open "GET", strUrl, True
        .SetRequestHeader "Accept", "application/json"
        .Send
        .WaitForResponse
        If .Status = 200 Then
            Dim objJson As Scripting.Dictionary
            Set objJson = JsonConverter.ParseJson(.ResponseText)
            Debug.Print "Search time: " & objJson.Item("searchInformation")("totalResults")
            Debug.Print "Formatted total results: " & objJson.Item("searchInformation")("formattedTotalResults")
        End If
    End With
End Sub

'Source: ExcelVBA.ru
Private Function URLEncode(ByRef txt As String) As String
    Dim buffer As String, i As Long, c As Long, n As Long
    buffer = String$(Len(txt) * 12, "%")
 
    For i = 1 To Len(txt)
        c = AscW(Mid$(txt, i, 1)) And 65535
        Select Case c
            Case 48 To 57, 65 To 90, 97 To 122, 45, 46, 95  ' Unescaped 0-9A-Za-z-._ '
                n = n + 1
                Mid$(buffer, n) = ChrW(c)
            Case Is <= 127            ' Escaped UTF-8 1 bytes U+0000 to U+007F '
                n = n + 3
                Mid$(buffer, n - 1) = Right$(Hex$(256 + c), 2)
            Case Is <= 2047           ' Escaped UTF-8 2 bytes U+0080 to U+07FF '
                n = n + 6
                Mid$(buffer, n - 4) = Hex$(192 + (c \ 64))
                Mid$(buffer, n - 1) = Hex$(128 + (c Mod 64))
            Case 55296 To 57343       ' Escaped UTF-8 4 bytes U+010000 to U+10FFFF '
                i = i + 1
                c = 65536 + (c Mod 1024) * 1024 + (AscW(Mid$(txt, i, 1)) And 1023)
                n = n + 12
                Mid$(buffer, n - 10) = Hex$(240 + (c \ 262144))
                Mid$(buffer, n - 7) = Hex$(128 + ((c \ 4096) Mod 64))
                Mid$(buffer, n - 4) = Hex$(128 + ((c \ 64) Mod 64))
                Mid$(buffer, n - 1) = Hex$(128 + (c Mod 64))
            Case Else                 ' Escaped UTF-8 3 bytes U+0800 to U+FFFF '
                n = n + 9
                Mid$(buffer, n - 7) = Hex$(224 + (c \ 4096))
                Mid$(buffer, n - 4) = Hex$(128 + ((c \ 64) Mod 64))
                Mid$(buffer, n - 1) = Hex$(128 + (c Mod 64))
        End Select
    Next
    URLEncode = Left$(buffer, n)
End Function

Example of a successful API call for keyword "football":
1680774595274.png


JSON: 
{
    "kind": "customsearch#search",
    "url": {
      "type": "application/json",
      "template": "https://www.googleapis.com/customsearch/v1?q={searchTerms}&num={count?}&start={startIndex?}&lr={language?}&safe={safe?}&cx={cx?}&sort={sort?}&filter={filter?}&gl={gl?}&cr={cr?}&googlehost={googleHost?}&c2coff={disableCnTwTranslation?}&hq={hq?}&hl={hl?}&siteSearch={siteSearch?}&siteSearchFilter={siteSearchFilter?}&exactTerms={exactTerms?}&excludeTerms={excludeTerms?}&linkSite={linkSite?}&orTerms={orTerms?}&relatedSite={relatedSite?}&dateRestrict={dateRestrict?}&lowRange={lowRange?}&highRange={highRange?}&searchType={searchType}&fileType={fileType?}&rights={rights?}&imgSize={imgSize?}&imgType={imgType?}&imgColorType={imgColorType?}&imgDominantColor={imgDominantColor?}&alt=json"
    },
    "queries": {
      "request": [
        {
          "title": "Google Custom Search - football",
          "totalResults": "2770000000",
          "searchTerms": "football",
          "count": 10,
          "startIndex": 1,
          "inputEncoding": "utf8",
          "outputEncoding": "utf8",
          "safe": "off",
          "cx": "70c03cada6abe4ae4"
        }
      ],
      "nextPage": [
        {
          "title": "Google Custom Search - football",
          "totalResults": "2770000000",
          "searchTerms": "football",
          "count": 10,
          "startIndex": 11,
          "inputEncoding": "utf8",
          "outputEncoding": "utf8",
          "safe": "off",
          "cx": "70c03cada6abe4ae4"
        }
      ]
    },
    "context": {
      "title": "Google Search"
    },
    "searchInformation": {
      "searchTime": 0.499753,
      "formattedSearchTime": "0.50",
      "totalResults": "2770000000",
      "formattedTotalResults": "2,770,000,000"
    },
    "items": [
      {
        "kind": "customsearch#result",
        "title": "NFL.com | Official Site of the National Football League",
        "htmlTitle": "NFL.com | Official Site of the National \u003cb\u003eFootball\u003c/b\u003e League",
        "link": "https://www.nfl.com/",
        "displayLink": "www.nfl.com",
        "snippet": "The official source for NFL News, NFL video highlights, Fantasy Football, game-day coverage, NFL schedules, stats, scores & more.",
        "htmlSnippet": "The official source for NFL News, NFL video highlights, Fantasy \u003cb\u003eFootball\u003c/b\u003e, game-day coverage, NFL schedules, stats, scores &amp; more.",
        "cacheId": "tOQiBrRKqKwJ",
        "formattedUrl": "https://www.nfl.com/",
        "htmlFormattedUrl": "https://www.nfl.com/",
        "pagemap": {
          "cse_thumbnail": [
            {
              "src": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTUZz2J99wq1BGdIwwYmFjmLW43RudmU-lI7m10rwMsx0DUg5-U23XRYnpC",
              "width": "225",
              "height": "225"
            }
          ],
          "metatags": [
            {
              "og:image": "https://static.www.nfl.com/image/upload/v1554321393/league/nvfr7ogywskqrfaiu38m.svg",
              "og:type": "website",
              "twitter:card": "summary_large_image",
              "twitter:title": "NFL.com | Official Site of the National Football League",
              "og:site_name": "NFL.com",
              "og:title": "NFL.com | Official Site of the National Football League",
              "og:image:type": "image/jpeg",
              "og:description": "The official source for NFL news, video highlights, fantasy football, game-day coverage, schedules, stats, scores and more.",
              "twitter:image:src": "https://static.www.nfl.com/image/upload/v1554321393/league/nvfr7ogywskqrfaiu38m.svg",
              "twitter:site": "@NFL",
              "viewport": "width=device-width, initial-scale=1.0",
              "twitter:description": "The official source for NFL news, video highlights, fantasy football, game-day coverage, schedules, stats, scores and more.",
              "og:locale": "en-US",
              "og:url": "https://www.nfl.com/"
            }
          ],
          "cse_image": [
            {
              "src": "https://static.www.nfl.com/image/upload/v1554321393/league/nvfr7ogywskqrfaiu38m.svg"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "Football - Wikipedia",
        "htmlTitle": "\u003cb\u003eFootball\u003c/b\u003e - Wikipedia",
        "link": "https://en.wikipedia.org/wiki/Football",
        "displayLink": "en.wikipedia.org",
        "snippet": "Football is a family of team sports that involve, to varying degrees, kicking a ball to score a goal. Unqualified, the word football normally means the form ...",
        "htmlSnippet": "\u003cb\u003eFootball\u003c/b\u003e is a family of team sports that involve, to varying degrees, kicking a ball to score a goal. Unqualified, the word \u003cb\u003efootball\u003c/b\u003e normally means the form&nbsp;...",
        "cacheId": "oTP5Qe93NzQJ",
        "formattedUrl": "https://en.wikipedia.org/wiki/Football",
        "htmlFormattedUrl": "https://en.wikipedia.org/wiki/\u003cb\u003eFootball\u003c/b\u003e",
        "pagemap": {
          "metatags": [
            {
              "referrer": "origin",
              "og:image": "https://upload.wikimedia.org/wikipedia/commons/thumb/a/ad/Football_in_Bloomington%2C_Indiana%2C_1996.jpg/1200px-Football_in_Bloomington%2C_Indiana%2C_1996.jpg",
              "theme-color": "#eaecf0",
              "og:image:width": "1200",
              "og:type": "website",
              "viewport": "width=device-width, initial-scale=1.0, user-scalable=yes, minimum-scale=0.25, maximum-scale=5.0",
              "og:title": "Football - Wikipedia",
              "og:image:height": "817",
              "format-detection": "telephone=no"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "Online conference: Understanding the new FIFA Football Agent ...",
        "htmlTitle": "Online conference: Understanding the new FIFA \u003cb\u003eFootball\u003c/b\u003e Agent ...",
        "link": "https://www.fifa.com/",
        "displayLink": "www.fifa.com",
        "snippet": "The official site of the international governing body of football with news, national associations, competitions, results, fixtures, development, ...",
        "htmlSnippet": "The official site of the international governing body of \u003cb\u003efootball\u003c/b\u003e with news, national associations, competitions, results, fixtures, development,&nbsp;...",
        "cacheId": "tRh_crqBaKgJ",
        "formattedUrl": "https://www.fifa.com/",
        "htmlFormattedUrl": "https://www.fifa.com/",
        "pagemap": {
          "cse_thumbnail": [
            {
              "src": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcTk7vW_LQZQizOotdQvrx-IClOrmvDLDA1-KkAICK0a8pTwzJ9e7zx5WYGL",
              "width": "275",
              "height": "183"
            }
          ],
          "metatags": [
            {
              "msapplication-tilecolor": "#326295",
              "og:image": "https://digitalhub.fifa.com/m/605981858ebaad97/webimage-129802200HC016_FIFA_Executi.png",
              "og:type": "website",
              "twitter:card": "summary",
              "twitter:title": "FIFA",
              "theme-color": "#ffffff",
              "twitter:url": "https://fifa.com",
              "og:title": "FIFA",
              "title": "FIFA",
              "msapplication-tileimage": "/mstile-150x150.png",
              "og:description": "The official site of the international governing body of football with news, national associations, competitions, results, fixtures, development, organisation, world rankings, statistics, the International Football Association Board, history, laws of the game, futsal, publications, downloads, and contact details.",
              "twitter:image": "https://digitalhub.fifa.com/m/605981858ebaad97/webimage-129802200HC016_FIFA_Executi.png",
              "next-head-count": "40",
              "viewport": "minimal-ui, width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no",
              "twitter:description": "The official site of the international governing body of football with news, national associations, competitions, results, fixtures, development, organisation, world rankings, statistics, the International Football Association Board, history, laws of the game, futsal, publications, downloads, and contact details.",
              "og:url": "https://fifa.com"
            }
          ],
          "cse_image": [
            {
              "src": "https://digitalhub.fifa.com/m/605981858ebaad97/webimage-129802200HC016_FIFA_Executi.png"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "American football - Wikipedia",
        "htmlTitle": "American \u003cb\u003efootball\u003c/b\u003e - Wikipedia",
        "link": "https://en.wikipedia.org/wiki/American_football",
        "displayLink": "en.wikipedia.org",
        "snippet": "American football also known as gridiron, is a team sport played by two teams of eleven players on a rectangular field with goalposts at each end.",
        "htmlSnippet": "American \u003cb\u003efootball\u003c/b\u003e also known as gridiron, is a team sport played by two teams of eleven players on a rectangular field with goalposts at each end.",
        "cacheId": "vriNcg2Xb28J",
        "formattedUrl": "https://en.wikipedia.org/wiki/American_football",
        "htmlFormattedUrl": "https://en.wikipedia.org/wiki/American_\u003cb\u003efootball\u003c/b\u003e",
        "pagemap": {
          "hcard": [
            {
              "fn": "American football"
            }
          ],
          "metatags": [
            {
              "referrer": "origin",
              "og:image": "https://upload.wikimedia.org/wikipedia/commons/thumb/d/df/Larry_Fitzgerald_catches_TD_at_2009_Pro_Bowl.jpg/1200px-Larry_Fitzgerald_catches_TD_at_2009_Pro_Bowl.jpg",
              "theme-color": "#eaecf0",
              "og:image:width": "1200",
              "og:type": "website",
              "viewport": "width=device-width, initial-scale=1.0, user-scalable=yes, minimum-scale=0.25, maximum-scale=5.0",
              "og:title": "American football - Wikipedia",
              "og:image:height": "1680",
              "format-detection": "telephone=no"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "Football | CNN",
        "htmlTitle": "\u003cb\u003eFootball\u003c/b\u003e | CNN",
        "link": "https://www.cnn.com/sport/football",
        "displayLink": "www.cnn.com",
        "snippet": "Latest football news from around the world, with features and interviews with the biggest stars of the English Premier League, Spanish La Liga, ...",
        "htmlSnippet": "Latest \u003cb\u003efootball\u003c/b\u003e news from around the world, with features and interviews with the biggest stars of the English Premier League, Spanish La Liga,&nbsp;...",
        "formattedUrl": "https://www.cnn.com/sport/football",
        "htmlFormattedUrl": "https://www.cnn.com/sport/\u003cb\u003efootball\u003c/b\u003e",
        "pagemap": {
          "cse_thumbnail": [
            {
              "src": "https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcQ6zWnKnUqtrnlNEOTqHEltVX6lvgLbSj2iBs1PeziCH5Ly82iPaZpYm5Y",
              "width": "300",
              "height": "168"
            }
          ],
          "metatags": [
            {
              "twitter:title": "Football | CNN",
              "og:type": "website",
              "twitter:card": "summary_large_image",
              "og:site_name": "CNN",
              "og:title": "Football | CNN",
              "meta-section": "sport",
              "type": "section",
              "og:description": "Latest football news from around the world, with features and interviews with the biggest stars of the English Premier League, Spanish La Liga, German Bundesliga and Italian Serie A.",
              "article:publisher": "https://www.facebook.com/CNN",
              "fb:app_id": "80401312489",
              "twitter:site": "@cnn",
              "viewport": "width=device-width,initial-scale=1,shrink-to-fit=no",
              "twitter:description": "Latest football news from around the world, with features and interviews with the biggest stars of the English Premier League, Spanish La Liga, German Bundesliga and Italian Serie A.",
              "template_type": "landing_section",
              "theme": "sport",
              "og:url": "https://www.cnn.com/sport/football"
            }
          ],
          "cse_image": [
            {
              "src": "https://media.cnn.com/api/v1/images/stellar/prod/230328135711-wrexham-football-club-file-012923.jpg?c=16x9&q=h_720,w_1280,c_fill"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "Pro-Football-Reference.com: Pro Football Stats, History, Scores ...",
        "htmlTitle": "Pro-\u003cb\u003eFootball\u003c/b\u003e-Reference.com: Pro \u003cb\u003eFootball\u003c/b\u003e Stats, History, Scores ...",
        "link": "https://www.pro-football-reference.com/",
        "displayLink": "www.pro-football-reference.com",
        "snippet": "Complete source for pro football history including complete player, team, and league stats, awards, records, leaders, rookies and scores.",
        "htmlSnippet": "Complete source for pro \u003cb\u003efootball\u003c/b\u003e history including complete player, team, and league stats, awards, records, leaders, rookies and scores.",
        "cacheId": "pmmCcNXNx-EJ",
        "formattedUrl": "https://www.pro-football-reference.com/",
        "htmlFormattedUrl": "https://www.pro-\u003cb\u003efootball\u003c/b\u003e-reference.com/",
        "pagemap": {
          "cse_thumbnail": [
            {
              "src": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcS17P4ut1Ohm2ZeoAz78vh9SEGDTCn0667qVf2Wq_S3FUFrjNQ3gGwS3XQ",
              "width": "300",
              "height": "168"
            }
          ],
          "metatags": [
            {
              "msapplication-tilecolor": "#005629",
              "generated-by": "build_index_page.pl",
              "og:image": "https://cdn.ssref.net/req/202303231/favicons/pfr/apple-touch-icon-228x228-precomposed.png",
              "theme-color": "#384d42",
              "og:type": "article",
              "twitter:card": "summary",
              "og:site_name": "Pro-Football-Reference.com",
              "handheldfriendly": "True",
              "twitter:domain": "Pro-Football-Reference.com",
              "og:title": "Pro Football Stats, History, Scores, Standings, Playoffs, Schedule & Records | Pro-Football-Reference.com",
              "msapplication-tileimage": "https://cdn.ssref.net/req/202303231/favicons/pfr/ms-tile-144.png",
              "msapplication-navbutton-color": "#384d42",
              "og:description": "Complete source for pro football history including complete player, team, and league stats, awards, records, leaders, rookies and scores.",
              "twitter:creator": "@pfref",
              "twitter:image": "https://cdn.ssref.net/req/202303231/favicons/pfr/apple-touch-icon-228x228-precomposed.png",
              "referrer": "unsafe-url",
              "apple-mobile-web-app-status-bar-style": "#384d42",
              "twitter:site": "@pfref",
              "viewport": "width=device-width, initial-scale=1.0, maximum-scale=2.0",
              "apple-mobile-web-app-capable": "no",
              "mobile-web-app-capable": "yes",
              "revised": "22:06:14 05-Apr-2023",
              "og:url": "https://www.pro-football-reference.com/",
              "format-detection": "telephone=no"
            }
          ],
          "cse_image": [
            {
              "src": "https://i.ytimg.com/vi/y9OEvffREcc/maxresdefault.jpg"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "NCAA on ESPN - College Football Scores, Stats and Highlights",
        "htmlTitle": "NCAA on ESPN - College \u003cb\u003eFootball\u003c/b\u003e Scores, Stats and Highlights",
        "link": "https://www.espn.com/college-football/",
        "displayLink": "www.espn.com",
        "snippet": "Visit ESPN for NCAA live scores, video highlights and latest news. Stream exclusive college football games on ESPN+ and play College Pick'em.",
        "htmlSnippet": "Visit ESPN for NCAA live scores, video highlights and latest news. Stream exclusive college \u003cb\u003efootball\u003c/b\u003e games on ESPN+ and play College Pick&#39;em.",
        "cacheId": "IRmJar-2LrYJ",
        "formattedUrl": "https://www.espn.com/college-football/",
        "htmlFormattedUrl": "https://www.espn.com/college-\u003cb\u003efootball\u003c/b\u003e/",
        "pagemap": {
          "cse_thumbnail": [
            {
              "src": "https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcQ1YTbiqvZr3-0onXwnp1xSSK3Kv2YIN8SswoKWQVu0OHtkeIFU0X3VWqw",
              "width": "225",
              "height": "225"
            }
          ],
          "thumbnail": [
            {
              "src": "https://a3.espncdn.com/combiner/i?img=%2Fi%2Fespn%2Fmisc_logos%2F500%2Fncaa_football.png",
              "width": "500",
              "height": "500"
            }
          ],
          "document": [
            {
              "title": "NCAA on ESPN - College Football Scores, Stats and Highlights"
            }
          ],
          "metatags": [
            {
              "og:image": "https://a3.espncdn.com/combiner/i?img=%2Fi%2Fespn%2Fmisc_logos%2F500%2Fncaa_football.png",
              "twitter:app:id:googleplay": "com.espn.score_center",
              "og:image:width": "500",
              "og:type": "website",
              "twitter:title": "NCAA on ESPN - College Football Scores, Stats and Highlights",
              "twitter:card": "summary",
              "og:site_name": "ESPN.com",
              "twitter:url": "https://www.espn.com/college-football/",
              "og:title": "NCAA on ESPN - College Football Scores, Stats and Highlights",
              "og:image:height": "500",
              "twitter:app:name:googleplay": "ESPN",
              "medium": "index",
              "twitter:app:id:iphone": "317469184",
              "title": "NCAA on ESPN - College Football Scores, Stats and Highlights",
              "og:description": "Visit ESPN for NCAA live scores, video highlights and latest news. Stream exclusive college football games on ESPN+ and play College Pick'em.",
              "referrer": "origin-when-cross-origin",
              "fb:app_id": "116656161708917",
              "twitter:site": "espn",
              "viewport": "initial-scale=1.0, maximum-scale=1.0, user-scalable=no",
              "twitter:description": "Visit ESPN for NCAA live scores, video highlights and latest news. Stream exclusive college football games on ESPN+ and play College Pick'em.",
              "og:url": "https://www.espn.com/college-football/",
              "twitter:app:name:iphone": "ESPN"
            }
          ],
          "cse_image": [
            {
              "src": "https://a3.espncdn.com/combiner/i?img=%2Fi%2Fespn%2Fmisc_logos%2F500%2Fncaa_football.png"
            }
          ],
          "sitenavigationelement": [
            {
              "name": "NFL",
              "url": "NFL"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "College Football Playoff - Official Athletics Website",
        "htmlTitle": "College \u003cb\u003eFootball\u003c/b\u003e Playoff - Official Athletics Website",
        "link": "https://collegefootballplayoff.com/",
        "displayLink": "collegefootballplayoff.com",
        "snippet": "The official website of the College Football Playoff.",
        "htmlSnippet": "The official website of the College \u003cb\u003eFootball\u003c/b\u003e Playoff.",
        "formattedUrl": "https://collegefootballplayoff.com/",
        "htmlFormattedUrl": "https://college\u003cb\u003efootball\u003c/b\u003eplayoff.com/",
        "pagemap": {
          "cse_thumbnail": [
            {
              "src": "https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcQJqBB6jgMo5hKHJqX85sYQrha1g7SvCRtIB61zSFk2HEnLiWMRORQkDFk",
              "width": "200",
              "height": "200"
            }
          ],
          "metatags": [
            {
              "og:determiner": "the",
              "og:image": "http://collegefootballplayoff.com/images/logos/site/site.png",
              "theme-color": "#c9920e",
              "og:type": "website",
              "og:image:alt": "College Football Playoff Logo",
              "twitter:card": "summary",
              "og:site_name": "College Football Playoff",
              "og:title": "College Football Playoff - Official Athletics Website",
              "og:description": "The official website of the College Football Playoff",
              "viewport": "width=device-width, initial-scale=1.0, user-scalable=yes",
              "twitter:description": "The official website of the College Football Playoff",
              "og:locale": "en_US",
              "og:url": "https://collegefootballplayoff.com/"
            }
          ],
          "cse_image": [
            {
              "src": "http://collegefootballplayoff.com/images/logos/site/site.png"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "Football | History, Rules, & Significant Players | Britannica",
        "htmlTitle": "\u003cb\u003eFootball\u003c/b\u003e | History, Rules, &amp; Significant Players | Britannica",
        "link": "https://www.britannica.com/sports/football-soccer",
        "displayLink": "www.britannica.com",
        "snippet": "football, also called association football or soccer, game in which two teams of 11 players, using any part of their bodies except their hands and arms, ...",
        "htmlSnippet": "\u003cb\u003efootball\u003c/b\u003e, also called association \u003cb\u003efootball\u003c/b\u003e or soccer, game in which two teams of 11 players, using any part of their bodies except their hands and arms,&nbsp;...",
        "cacheId": "lZwISU8bLjQJ",
        "formattedUrl": "https://www.britannica.com/sports/football-soccer",
        "htmlFormattedUrl": "https://www.britannica.com/sports/\u003cb\u003efootball\u003c/b\u003e-soccer",
        "pagemap": {
          "cse_thumbnail": [
            {
              "src": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRrWImNM1j0yw3Gr0D5GtSPELsPSW7wptTG-NoFL5JnKl2IJRUlidD9LqFe",
              "width": "187",
              "height": "269"
            }
          ],
          "metatags": [
            {
              "og:image": "https://cdn.britannica.com/72/143472-050-6ECD0DB0/Carlos-Alberto-Torres-holds-Jules-Rimet-trophy-Brazil-1970.jpg",
              "twitter:card": "summary_large_image",
              "og:type": "ARTICLE",
              "og:site_name": "Encyclopedia Britannica",
              "og:title": "Football | History, Rules, & Significant Players",
              "og:image:type": "image/jpeg",
              "fb:pages": "74442380906",
              "og:description": "football, also called association football or soccer,  game in which two teams of 11 players, using any part of their bodies except their hands and arms, try to maneuver the ball into the opposing team’s goal. Only the goalkeeper is permitted to handle the ball and may do so only within the penalty area surrounding the goal. The team that scores more goals wins. Football is the world’s most popular ball game in numbers of participants and spectators. Simple in its principal rules and essential equipment, the sport can be played almost anywhere, from official football playing fields (pitches) to",
              "twitter:image": "https://cdn.britannica.com/72/143472-050-6ECD0DB0/Carlos-Alberto-Torres-holds-Jules-Rimet-trophy-Brazil-1970.jpg",
              "fb:app_id": "1887621861548296",
              "twitter:site": "@britannica",
              "viewport": "width=device-width, initial-scale=1.0",
              "twitter:description": "football, also called association football or soccer,  game in which two teams of 11 players, using any part of their bodies except their hands and arms, try to maneuver the ball into the opposing team’s goal. Only the goalkeeper is permitted to handle the ball and may do so only within the penalty area surrounding the goal. The team that scores more goals wins. Football is the world’s most popular ball game in numbers of participants and spectators. Simple in its principal rules and essential equipment, the sport can be played almost anywhere, from official football playing fields (pitches) to",
              "og:url": "https://www.britannica.com/sports/football-soccer"
            }
          ],
          "cse_image": [
            {
              "src": "https://cdn.britannica.com/72/143472-050-6ECD0DB0/Carlos-Alberto-Torres-holds-Jules-Rimet-trophy-Brazil-1970.jpg"
            }
          ]
        }
      },
      {
        "kind": "customsearch#result",
        "title": "The Scoop - Tuesday April 4, 2023 - Footballscoop",
        "htmlTitle": "The Scoop - Tuesday April 4, 2023 - Footballscoop",
        "link": "https://footballscoop.com/thescoop/the-scoop-tuesday-april-4-2023",
        "displayLink": "footballscoop.com",
        "snippet": "2 days ago ... The Assistant Coach of Football assists in all aspects of the intercollegiate football team including coaching, recruiting, scheduling, program ...",
        "htmlSnippet": "2 days ago \u003cb\u003e...\u003c/b\u003e The Assistant Coach of \u003cb\u003eFootball\u003c/b\u003e assists in all aspects of the intercollegiate \u003cb\u003efootball\u003c/b\u003e team including coaching, recruiting, scheduling, program&nbsp;...",
        "cacheId": "mQqm2BDEjgQJ",
        "formattedUrl": "https://footballscoop.com/thescoop/the-scoop-tuesday-april-4-2023",
        "htmlFormattedUrl": "https://\u003cb\u003efootball\u003c/b\u003escoop.com/thescoop/the-scoop-tuesday-april-4-2023",
        "pagemap": {
          "cse_thumbnail": [
            {
              "src": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTDNWhHMThZQbgKvbe8-ElS6s7Sxq65uEKA7zUYyYRuDuhzJBccwBniz5V-",
              "width": "340",
              "height": "148"
            }
          ],
          "imageobject": [
            {
              "contenturl": "https://footballscoop.com/.image/t_share/MTk0NzQwNTc3NDc5MTczNjU2/coachcomm-dec-2022.jpg",
              "url": "https://footballscoop.com/.image/t_share/MTk0NzQwNTc3NDc5MTczNjU2/coachcomm-dec-2022.jpg"
            }
          ],
          "metatags": [
            {
              "pagetype": "article",
              "og:image": "https://footballscoop.com/.image/t_share/MTk0NzQwNTc3NDc5MTczNjU2/coachcomm-dec-2022.jpg",
              "twitter:card": "summary_large_image",
              "og:site_name": "Footballscoop",
              "twitter:url": "https://footballscoop.com/thescoop/the-scoop-tuesday-april-4-2023",
              "apple-mobile-web-app-title": "Footballscoop",
              "parsely-author": "Scott Roussel",
              "section": "The Scoop",
              "phx:content-item-id": "ci02bbe3c720002705",
              "twitter:creator": "@FootballScoop",
              "og:description": "Since 1999, all sources remain confidential. Mail@FootballScoop.com or 225.229.3429  Our world has lost another great man as coach Bernie Wyatt has passed away",
              "phx:content-object-type": "ContentArticle",
              "companies": "CoachComm Dec 2022",
              "parsely-type": "post",
              "phx:site-keyword": "footballscoop",
              "modified": "2023-04-04T20:00:22Z",
              "dcterms.datecopyrighted": "2023",
              "twitter:domain": "footballscoop.com",
              "author": "Scott Roussel",
              "published": "2023-04-04T12:49:20Z",
              "parsely-pub-date": "2023-04-04T12:49:20Z",
              "parsely-tags": "The Scoop",
              "item-id": "ci02bbe3c720002705",
              "mobileoptimized": "320",
              "sailthru.image.full": "https://footballscoop.com/.image/t_share/MTk0NzQwNTc3NDc5MTczNjU2/coachcomm-dec-2022.jpg",
              "sailthru.author": "Scott Roussel",
              "format-detection": "telephone=no",
              "sailthru.tags": "The Scoop",
              "twitter:image": "https://footballscoop.com/.image/t_share/MTk0NzQwNTc3NDc5MTczNjU2/coachcomm-dec-2022.jpg",
              "dcterms.rightsholder": "Coaching News Network, LLC",
              "parsely-link": "https://footballscoop.com/thescoop/the-scoop-tuesday-april-4-2023",
              "sailthru.title": "The Scoop - Tuesday April 4, 2023",
              "parsely-image-url": "https://footballscoop.com/.image/c_fill%2Ccs_srgb%2Cfl_progressive%2Ch_400%2Cq_auto:good%2Cw_620/MTk0NzQwNTc3NDc5MTczNjU2/coachcomm-dec-2022.jpg",
              "parsely-section": "The Scoop",
              "sailthru.date": "2023-04-04T12:49:20Z",
              "og:type": "article",
              "parsely-post-id": "ci02bbe3c720002705",
              "handheldfriendly": "True",
              "og:title": "The Scoop - Tuesday April 4, 2023",
              "parsely-title": "The Scoop - Tuesday April 4, 2023 - Footballscoop",
              "phx:exclusive-content-type": "free",
              "pinterest-rich-pin": "false",
              "referrer": "unsafe-url",
              "fb:app_id": "2109571519347496",
              "sailthru.description": "Since 1999, all sources remain confidential. Mail@FootballScoop.com or 225.229.3429  Our world has lost another great man as coach Bernie Wyatt has passed away",
              "apple-mobile-web-app-status-bar-style": "black",
              "viewport": "width=device-width, initial-scale=1",
              "twitter:description": "Since 1999, all sources remain confidential. Mail@FootballScoop.com or 225.229.3429  Our world has lost another great man as coach Bernie Wyatt has passed away",
              "apple-mobile-web-app-capable": "no",
              "og:url": "https://footballscoop.com/thescoop/the-scoop-tuesday-april-4-2023"
            }
          ],
          "webpage": [
            {
              "name": "Home"
            },
            {
              "name": "The Scoop"
            }
          ],
          "cse_image": [
            {
              "src": "https://footballscoop.com/.image/t_share/MTk0NzQwNTc3NDc5MTczNjU2/coachcomm-dec-2022.jpg"
            }
          ],
          "listitem": [
            {
              "position": "1"
            },
            {
              "position": "2"
            }
          ]
        }
      }
    ]
  }

GoogleCustomSearchAPI.xlsm
 

Attachments

  • 1680774345969.png
    1680774345969.png
    7.5 KB · Views: 10
Last edited:
Upvote 0
Thanks for your reply, but I want to do a bulk search, if I have hundreds of keywords how can I search them at once
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Excel file search engine
Replies
6
Views
571
6StringJazzer
6StringJazzer
M
  • Question Question
Dynamic link from Word to Excel...
Replies
8
Views
181
Matteo85
M
AndyTampa
  • Solved
Limit Quick Tasks macro to a specific worksheet
Replies
4
Views
305
mumps
mumps
S
  • Question Question
Specific and maybe advanced search
Replies
6
Views
248
Shakeable_Drip
S
N
  • Question Question
Always open xlsx files in the already-open instance of Excel
Replies
2
Views
279
nevyoung
N

Forum statistics

Threads
1,223,237
Messages
6,170,930
Members
452,367
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top