| SEO Elements | Uses and Tips | Go to Sheet |
| H1 Tag | Extract the H1 tag of pages in bulk | =IFERROR(TRANSPOSE(IMPORTXML(A:A,”//h1″)),”Not Found”) |
| Page Title | Extract the Page Title of pages in bulk | =IFERROR(IMPORTXML(A:A,“//title”),“Not Found”) |
| Meta Description | Extract the Meta Description of pages in bulk | =IF(A2 = “”,“Meta Description Will Appear Here”,IMPORTXML(A:A,“//meta[@name=’description’]/@content”)) |
| Image Alt Tag | – | – |
| – Existing Image Alt Tags | Extract the links of image URL and ALT Tags | =IMPORTXML(A2,“//img/@src”) |
| – Missing Image Alt Tags | Extract the links of image URL that missing ALT Tags | =IMPORTXML(A2,“//img/@alt”) |
| Canonical URL | Extract canonical URL of page to know it is same as URL or different | Click Here |
| Hreflang Tags Checker | Extract the hreflang tag | Click Here |
| Hreflang URLs Checker | Extract the hreflang URLs | Click Here |
| Internal Links | Extract the internal links of a specific page | Click Here |
| External Links | Extract all the external links of given URL | Click Here |
| – Dofollow External Links | Extract All External Do-Follow Links | Click Here |
| – Nofollow External Links | Extract All External No-Follow Links | Click Here |
| Social Links | Extract social links of the specific page | Click Here |