Importing Alexa Ranking status Using ImportXML

If you want to get the rank of any site, we can import the status automatically by using this ImportXML formula =ImportXML(“http://www.alexa.com/search?q={URL}”, “//span//a”) Let’s take an example of  targeted url as http://google.com/ =ImportXML(“http://www.alexa.com/search?q=http://google.com/”, “//span//a”) Screenshot:  

Web Scraping Using ImportXML

For scraping the recent posts from a site, we can use ImportXML Follow the formula where First field having the site name Take an example of site legendofthecryptids.org =importxml(“http://legendofthecryptids.org/”,”//div[@class=’box-post-content’]//a/@title”) Here // – this means select all elements of the type,…

Importing Linkedin Profile

Here PROFILE ID is the linkedin profile name with the target person’s username. It’s usually the person’s name without any spaces. For removing white spaces in name we can use Dewhitespace function in ImportXML with USERNAME. =ImportXML(“www.linkedin.com/in/” & Dewhitespace({PROFILE ID}),…

Importing wikipedia Data into Google Docs

The Google spreadsheet function =importHTML(“”,”table”,N) will scrape a table from an HTML web page into a Google spreadsheet. The URL of the target web page, and the target table element both need to be in double quotes. The number N…

How to import Google data Using ImportXML

First take a google link like this: =”http://www.google.com/search?hl=en&gl=US&q=”&a2 In that url http://www.google.com/ is the url we are going to import, Next is /search? is for pulling up the search results page, add in hl=en which is the language code. EN=english,…

Process of Importing XML

Performing a a quick search turns up with a site listing 100 blogs, http://top-site-list.com/top-100-lists.php It’s manual and time consuming having to click on each one to copy the link. I want to get the list of URLs into a spreadsheet…

ImportXML lets you get information from filetypes such as xml, html, csv, tsv, as well as RSS and Atom feeds that you might read today in Google Reader. It can only read publicly available files by default. Data in other…

Before going to know, first we should know about xpath. Xpath is a query language used to pick out pieces of information from web pages. XPath is a syntax for defining parts of an XML document XPath uses path expressions…