Why don't Xpaths work in Google spreadsheets?

Question

Parsing

I want to learn how to parse data from various divs into a google spreadsheet.
For example, from the page https://2steps.pro/importxml-for-seo.html I want to transfer the title "1. Import Title, Description, H1. In DevTools, I select Copy - copy Xpath, I copy the Xpath into the Excel formula (cell B1):
https://docs.google.com/spreadsheets/d/12shJFpZZ85...
but for some reason an error. And so I tried with various links and divs. Banal "title" etc. work, but XPath does not. What I am I doing it wrong?

Answer 1

DevTools is a poor source of XPath, you need to understand the syntax of that language and write the path yourself.
https://www.w3schools.com/xml/xpath_intro.asp