Disclosure: I earn a commission from the link below, which helps support my content creation. Thanks for your support!
Take Excel classes with 1 free month of Skillshare (paid link) https://www.skillshare.com/en/r/profile/Excel-Classes/102244525?gr_tch_ref=on
In this video we look at the IMPORTXML function in Google Sheets and how you can use it to extract and import website page titles. If you work in SEO or are a website content editor, this is a really useful function to know!
Here is the formula used in the video with the necessary XPath query:
=IMPORTXML(B2,"//title/text()")
Download
0 formats
No download links available.
Import Website Page Titles into Google Sheets | IMPORTXML Function | NatokHD