Blog

  • http://www.evolvingseo.com Dan Shure

    Awesome Chris!!! Thank you!

    Reason I love Quora so much, is you have a whole list of people who have basically came out and “voted” on a topic they LOVE. And you know they have some interest in it because they’ve taken the time to follow the topic. Great if you’re trying to source a list of ie: DIY enthusiasts or wine lovers. And I like Quora because its a very “pure” environment (not many junk/spam profiles – you get a lot of that with follwerwonk sometimes) and I find the people to be a bit more savvy.

    Will DEF be using ALOT.

  • http://distilled.net David Sottimano

    Damn that’s nice. That’s all.

  • https://plus.google.com/u/0/111044299943603359137?rel=author Chris Le

    You guys are very welcome! Enjoy!

  • http://www.digitalnino.com Cleo Kirkland

    Super nice Chris! I’ve just started getting into Quora; this will be very useful for finding relevant target.

    Also, have you or anyone else found a way to scrape Zoominfo.com. Just curious.

    Also, also, what about review sites like Yelp or Menupages? I work a lot in the travel space, and would love a scalable way to check out the “review” competition in each locality.

  • https://plus.google.com/u/0/111044299943603359137?rel=author Chris Le

    @Cleo. I haven’t dug into scraping Zoominfo, Yelp, or Menupages. But I’ll keep it in mind for the next edition of the cookbook.

  • Sandeep Gulati

    WOW….thanks Chris, this is a awesome tool,I have made a massive file from the above formulas..this is amazing and rocks…thanks again for all above formula.

  • http://www.stevelarsen.co.uk Steve

    I’ve been trying to limit the importXML function to return only the first result. I haven’t been able to figure out how to do it through xPath as it seems to all be the same. Perhaps someone knows how to limit the output to only the first result OR modify the query. Here it is

    =ImportXML(“http://bit.ly/KkEXR6″,”//tr[@class='rategroup3']//span[@class='amount']“)

    This returns 3 results: 111.75,126.75,141.75
    I would only like to use 111.75

    note: the values might change or become invalid after 26 Jul 2012

  • http://www.stevelarsen.co.uk Steve

    I’ve been trying to limit the importXML function to return only the first result. I haven’t been able to figure out how to do it through xPath as it seems to all be the same. Perhaps someone knows how to limit the output to only the first result OR modify the query. Here it is

    =ImportXML(“http://bit.ly/KkFzGr″,”//tr[@class='rategroup3']//span[@class='amount']“)

    This returns 3 results: 111.75,126.75,141.75
    I would only like to use 111.75

    note: the values might change or become invalid after 26 Jul 2012

  • http://balanceddietishealthydiet.com balanced diet

    Hello! I’ve been reading your blog for a long time now and finally got the bravery to go ahead and give you a shout out from Porter Texas! Just wanted to tell you keep up the fantastic work!

  • https://plus.google.com/u/0/111044299943603359137?rel=author Chris Le

    Thanks for the shout out! We really appreciate it!

  • https://plus.google.com/u/0/111044299943603359137?rel=author Chris Le

    I haven’t been able to look at your query itself, but adding [1] to the xpath can sometimes yield the first result. It depends on how the HTML looks.

  • http://twitter.com/TheRastaLion MannehDF

    Tried, but frustratingly, I get an “error. Argument is blank”, even when I copied and pasted the recipe!

  • Conor Jones

    Your xpath for linkedin is very helpful for a novice like me. Next time you are doing more cookbook, can you show code for extracting ‘experience’ (title, company, dates, description). I can’t seem to get anywhere with it. Much to learn I guess.

  • Nicola Barozzi

    It does not work with Linkedin :-(

Get our Newsletter

Keep up-to-date search trends, latest blog posts and more!