+ Reply to Thread
Results 1 to 2 of 2

Is there a way to automate google searches into excel?

  1. #1
    Registered User
    Join Date
    03-29-2016
    Location
    Delft, Netherlands
    MS-Off Ver
    2007
    Posts
    2

    Is there a way to automate google searches into excel?

    I want three columns in an excel file. (very large with tons of rows)
    The column A has names of customers and
    for column B I want to have the hyperlink to each customer website.
    For column C I want their e-mail adress (mostly [email protected], so I won't mind any misfires when they have a different adress. I'll search that manually if there is no other way)

    Example: If column A of row 1 was "Boeing". Then column B of row 1
    is www.boeing.com
    My clients normally don't have a separate 'contact' page, so we don't have to worry about that.

    I know this is possible, because I saw an earlier post about this issue. Only there he had this working, but was asking for the google link instead of the homepage.
    Someone else asked my question, but was sent away by an admin, after which he never posted the question again.

    Since the list is over 35,000 rows it would be very time consuming to search one by one in google and copy and paste the homepage url and e-mail adress. Is there a automated way /via batch file writting that I can let one excel file convert alll the names in column A into homepage adresses in column B without having to do them one by one???

    Any other method is also very welcome. I'm new to this whole automation thing

    Thanks!

  2. #2
    Registered User
    Join Date
    03-29-2016
    Location
    Delft, Netherlands
    MS-Off Ver
    2007
    Posts
    2

    Re: Is there a way to automate google searches into excel?

    I just found the Blockspring add-on, which seemingly gives the first google search hit url and pastes it into a new column.
    That is exactly what I'm looking for.

    If it works well, all I need is a crawler that searches the websites automatically and pastes
    the e-mail in another column

+ 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. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  2. VBA Route Calculator - Google Maps Api 22 Minutes quicker than Actual Google Website
    By lookingforhelp1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2015, 01:23 PM
  3. Google Trend, Automate Download CSV URL
    By AZ007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2015, 01:15 PM
  4. Is there a way to automate google searches into excel?
    By bxc2739 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2013, 02:31 AM
  5. Automate google search of excel database
    By wlt123 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-12-2012, 11:50 AM
  6. Automate Google Search via Excel
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 07-27-2010, 02:09 PM
  7. Getting valid web searches and avoiding sites that contaminate web searches
    By David McRitchie in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-12-2006, 10:10 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