Importing Page’s Links to Google Docs

Sometimes a situation comes up where you really need to look at a list of all links on a page and what anchor text those links are using. Google spreadsheets makes it easy to get these links into a spreadsheet for your searching and sorting pleasure. Drop the following ImportXML() functions into cells that are side by side in your spreadsheet and let Google do the work for you.

=importXML("http://www.domain.com", "//a")

Lets take an example of URL “http://legendofthecryptids.org/”

Query:

=importXML(“http://legendofthecryptids.org/”, “//a”)

Screenshot:

import Pagelinks

If you want to get the links from URL “http://legendofthecryptids.org/”

Query:

=importXML(“http://legendofthecryptids.org/”, “//a/@href”)

Then follow the screenshot

import pagelinks

 

Leave a Reply

Your email address will not be published. Required fields are marked *