Google Sheets – How to Grab an HTML Link from a Table

google sheets

Behind each of the company names here is an HTML link to another page.

How do I import that HTML link into Google Sheets?

Best Answer

You can pull in those links with this formula:

=IMPORTXML("http://www.nasdaq.com/markets/ipos/activity.aspx?tab=upcoming","//tr/td[1]/a/@href")