Welcome to WebmasterWorld Guest from 23.20.184.141

Forum Moderators: martinibuster

Message Too Old, No Replies

Extracting search results for database

Collecting link:www.mysite.com results

     
7:02 pm on Feb 7, 2002 (gmt 0)

New User

5+ Year Member

joined:Aug 27, 2007
posts:1
votes: 0


I would like to do a comparison between the links that a competitor and I have.

The results of a link:www.mysite.com search at the main sites provides about 200-400 results, depending on the search site.

I would like to know if anyone has a solution for importing these results into an Excel spreadsheet. Is there a software that will do this, or is it a matter of copying and pasting?

12:28 pm on Feb 14, 2002 (gmt 0)

Administrator from US 

WebmasterWorld Administrator brett_tabke is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Sept 21, 1999
posts:38061
votes: 13


Offhand, I don't know of any off-the-shelf solutions. However, the intrepid can pull the source to the pages into a text editor (all 8 of them). Then you can either run your text editors HTML stripper, or write a quick keyboard macro to strip down the pages into something you can paste into excell.
1:16 pm on Feb 14, 2002 (gmt 0)

Preferred Member

10+ Year Member

joined:Dec 19, 2000
posts:366
votes: 0


There's a commercial windows app that does what you want. It's called RankSpy. It basically collects all incoming links for an url from different search engines you select.