Excel List and Google Search

laurenm

New Member
Joined
Nov 1, 2018
Messages
4
Hi everyone,

I have a question I'm not sure if excel is able to do. If I have a list of businesses in excel and want to search the web (probably google) for their website address. Is there a formula or a way to upload my list somewhere and have each business googled and return their website address automatically?

It's been tedious to do a google search one by one to get this information, so I would like to save some time.

Thanks!
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
A starting point: Search Web
VBA Code:
Sub SearchWeb
    Dim arStr As Variant, i As Byte
    Dim sTxt As String, sVal As String, sSearchFor As String, sURL As String
    Select Case ActiveSheet.name
        Case Else: sTxt = CStr(Selection.Value)
    End Select
    If Len(Trim(sTxt)) = 0 Then GoTo EXITNOW
    arStr = Split(sTxt, " ")
    For i = 0 To UBound(arStr)
        sVal = CStr(arStr(i))
        If i = UBound(arStr) = False Then sVal = sVal & "+"
        sSearchFor = sSearchFor & sVal
    Next i
    sURL = "http://www.google.com/search?q=" & sSearchFor & "&sourceid=chrome&ie=UTF-8"
    ActiveWorkbook.FollowHyperlink sURL, , True
EXITNOW:
    If IsArray(arStr) Then Erase arStr
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,150
Members
448,552
Latest member
WORKINGWITHNOLEADER

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