It seems it's possible to extract website title into a row, but how to extract IP address of the host into a row?
So for given any hostname (e.g.
webapps.stackexchange.com) it should return IP address (e.g.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Probably it's only possible by using some 3rd party web services which return IP addresses in HTML/XML format, so you can parse it via IMPORTXML.
In the example:
Here is an example with a dynamic row as an input (e.g. A1):
=importxml("http://xml.utrace.de/?query=" & A1,"//ip")