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("", "//a")

Lets take an example of URL “”


=importXML(“”, “//a”)


import Pagelinks

If you want to get the links from URL “”


=importXML(“”, “//a/@href”)

Then follow the screenshot

import pagelinks


Leave a Reply

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