Find the country where a site is hosted in Excel

Find the country where a site is hosted in Excel

by Niels Bosma
JsonPathOnUrl, ResolveIp, HttpSettings

Using the ip-api.com JSON API and ResolveIp we can get the country where a site is hosted: The following API request http://ip-api.com/json/91.189.43.102 returns this JSON response: So we use ResolveIp to get the ip of the site and JsonPathOnUrl on to parse the result: =JsonPathOnUrl("http://ip-api.com/json/"&ResolveIp("http://nielsbosma.se");"$.country";HttpSettings(TRUE;;;"240|240|Host")) Note the usage limits from their documentation: Our system will automatically ban any IP addresses doing over 250 requests per minute. You are free to use ip-api.com for non-commercial use. We do not allow commercial...

Bulk check Google Mobile Test in Excel

Bulk check Google Mobile Test in Excel

by Niels Bosma
scrapers, JsonPathOnUrl

So with mobilegeddon raging around us we need a good way to bulk check all of our websites for mobile friendliness. A perfect job for Excel and SeoTools! Google has released a tool that help test whether a website is considered "mobile friendly" or not. But only for one website at a time. What if we need to bulk check lots of websites to spot the ones we need to fix? In this post I'll show you how we can...