{"id":94,"date":"2019-01-19T17:02:33","date_gmt":"2019-01-19T17:02:33","guid":{"rendered":"http:\/\/www.countingcharacters.com\/blog\/?p=94"},"modified":"2022-01-16T07:39:31","modified_gmt":"2022-01-16T07:39:31","slug":"google-sheets-importxml","status":"publish","type":"post","link":"https:\/\/www.countingcharacters.com\/blog\/google-sheets-importxml\/","title":{"rendered":"ImportXML Google Sheets – Syntax, Examples & How to Use?"},"content":{"rendered":"\n

There are millions of users from the world that use Google Sheets daily but, they are not aware of all the functions that Google Spreadsheet have. From those functions, ImportXML is a very unique function that we will discuss in this blog. So first, we should understand what is ImportXML function and what we can do with this function?<\/p>\n

What is the Google Sheets ImportXML Function?<\/h2>\n

It is the pre-built function of Google Sheets that used to retrieve data in the structured data. It has two parameters, first is URL and second is XPath query. In the first parameter, you have to provide the URL in the double quotes and in a second parameter, you have to add XPath query in double quotes.<\/p><\/br>\n

Syntax of ImportXML<\/h3>\n
=IMPORTXML(url, xpath_query)<\/code><\/pre>\n
How to Use Google Sheets ImportXML?<\/h2>\n
You can use this function to extract any piece of information available publicly. Like Wikipedia Page or any other web page.<\/p>\n
Google Sheets ImportXML Examples<\/h2>\n
1. Extract Page Title From URLs Using ImportXML<\/h3>\n
Suppose, If you have a situation where you need a Page TItle of multiple URLs, so how long will run this task? I think it will take \u2153 of your whole day \ud83d\ude42<\/p>\n
To overcome this situation, you can use ImportXML function. Have a look at the brief example below:<\/p>\n
Examples of URLs:<\/p>\n
http:\/\/www.countingcharacters.com
http:\/\/www.countingcharacters.com\/google-serp-tool
http:\/\/www.countingcharacters.com\/image-compressor-online<\/p>\n
=IMPORTXML(\"http:\/\/www.countingcharacters.com\" , \"\/\/title\")<\/code><\/pre>\n
Or, you can also refer a cell in the first parameter<\/p>\n
=IMPORTXML(A1,\"\/\/title\")<\/code><\/pre>\n
Output:<\/strong> Online Character, Letter & Word Count Tool – Counting Characters<\/p>\n
\n
Recommended Tool: Meta Description Length Checker<\/a><\/strong><\/p>\n<\/blockquote>\n
<\/p>\n
2. Extract H1 Tag<\/h3>\n
To extract H1 tag content, you have to follow the same procedure as discussed above<\/p>\n
=IMPORTXML(\"http:\/\/www.countingcharacters.com\" , \"\/\/h1\")<\/code><\/pre>\n
Output:<\/strong> Character and Word Count Tool Online<\/p>\n
To explore more examples, click on the below button<\/b> and make a copy of Google Spreadsheet that has lots of ImportXML examples.<\/p>\n