+ Reply to Thread
Results 1 to 2 of 2

Excel List and Google Search for company URL based on company name

  1. #1
    Registered User
    Join Date
    07-13-2017
    Location
    California
    MS-Off Ver
    2016
    Posts
    9

    Excel List and Google Search for company URL based on company name

    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!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Excel List and Google Search for company URL based on company name

    Hi, if you search for webscraper you'll find some posts. there's one here somewhere, the username Claudia80
    You'll have to edit the url string but it does it quite nicely
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] select one company from drop down menu the respective company detail must appear
    By sehan14189 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-25-2019, 09:03 AM
  2. [SOLVED] enter country by company name and company cost
    By raysrains in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2019, 08:25 AM
  3. Replies: 2
    Last Post: 07-17-2017, 03:05 PM
  4. [SOLVED] Automatically copy individual company rows into separate company sheet
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-24-2016, 03:24 AM
  5. Search on company name to auto input company address
    By jamie.c in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2009, 12:38 PM
  6. Appending a colums from 2nd list based on match of company name
    By JamesC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2007, 10:17 AM
  7. Replies: 2
    Last Post: 06-05-2006, 12:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1