Q: I’m trying to extract the first keyword from a website’s source code to use it as a title.
Hi,
I’m trying to extract the first keyword from a website’s source code to use it as a title. Specifically, I want to get the first keyword from a meta tag like this:
<meta name="keywords" content="SheetMagic, ChatGPT" />
For example, I would like to retrieve "SheetMagic" as the title. Could you please help me with the formula or method to do this?
I have already tried functions like =GETMETAKEYWORDS("F2") and others, but they haven’t worked. Any guidance would be appreciated. Thank you!
Curran35278
Sep 15, 2025A: Hello!
Meta keywords are an obsolete HTML tag once used to provide search engines with a list of terms related to a web page's content. While they once aimed to help search engines categorize pages, they were abused through "keyword stuffing" and have since been disregarded by Google and other search engines as a ranking factor, so we did not implement this as many websites don't even have this meta information since it's obsolete now.
If just generally you want to get keywords from a page, you could try grabbing the page content or meta title/description and then using our AI functions on that to get the top keywords for the page.