Products SEO & GEO Agent Paid Ads Agent Website Agent Conversion Agent
How it works Pricing FAQ Blog Book a call

Keyword finder from text: pull the keywords out of any page

Updated · 6 min read

Short answer Paste the text into a free spreadsheet formula or an AI chatbot to list the words and phrases it repeats most. That shows what the text is about, not what people search. To get searched words, give the page's URL to Google Keyword Planner, or read the queries Search Console shows for that page.

Want help applying this to your business? Talk it through on a free 30-minute call.

Book a call

How do I find the keywords in a piece of text?

There are two different questions hiding in this one, and they need different tools:

You want to knowUseFree?
Which words and phrases this text uses mostA spreadsheet word count, or an AI chatbotYes
Which searches this text could matchGoogle Keyword Planner, "Start with a website"Yes, with a Google Ads account
Which searches this page already shows up forGoogle Search Console, Queries for that pageYes, for a site you own

The first tells you what a page is about. Only the second and third tell you what real people type into Google. Most "paste your text" keyword tools do the first job and stop there.

How to extract keywords from text by hand

A free Google Sheet does it in about two minutes:

  1. Paste the whole text into cell A1.
  2. In B1, paste this formula: `=QUERY(FLATTEN(SPLIT(REGEXREPLACE(LOWER(A1),"[^a-z0-9' ]+"," ")," ")),"select Col1, count(Col1) group by Col1 order by count(Col1) desc",0)`
  3. You get every word with how often it appears, most-used first.

The formula lowercases the text, strips punctuation, splits it into single words, and stacks them in one column. FLATTEN is the step that does the stacking: Google's help describes it as turning ranges "into a single column" (Google Docs Editors Help: FLATTEN function).

Then read the list like a person, not a machine:

  • Skip filler words. "the", "and", "we", "your" will top the list. Ignore them.
  • Circle the nouns that name a service or a problem. "drain", "clog", "camera", "sewer".
  • Rebuild the phrases. Search the text (Ctrl+F or Cmd+F) for each circled word and note the words beside it: "drain" turns into "drain cleaning" and "clogged drain".
  • Note what's missing. If you sell emergency service and "emergency" isn't in the top 20, the page doesn't say what you think it says.

Free keyword extractor tools, and their limits

ToolWhat you give itWhat you getThe catch
AI chatbot (ChatGPT, Gemini, Claude)Pasted text, plus "list the main topics and two- to three-word phrases"A tidy list of phrasesIt guesses. No search numbers, and it can list phrases nobody types
Google Cloud Natural Language APIText, through its demo or codeNamed things in the text, each with an importance scoreBuilt for developers; Google doesn't say Search ranks pages this way
Google Keyword PlannerA page URLSearch phrases related to the page, with monthly search estimatesNeeds a Google Ads account; numbers are rounded averages built for ad planning
Google Search ConsoleNothing: it reads your siteSearches your page already appeared forOnly for pages you own, and only after they get seen

Two of these deserve a closer look.

Keyword Planner is the closest thing to a "URL in, keywords out" tool that uses real search data. Google calls it "a free resource to help advertisers build keyword lists" (Google Ads: Keyword Planner). Its help page explains the option:

"Start with a website: Enter any website and Google will look for keywords related to the content on that site." (Google Ads Help: Use Keyword Planner)

You can enter a competitor's page, not just your own. Google adds that link text on the page isn't used, and that giving a keyword together with a URL returns more ideas.

The Natural Language API gives each named thing a salience score between 0 and 1:

"The salience score for an entity provides information about the importance or centrality of that entity to the entire document text." (Google Cloud: Natural Language API, Entity reference)

The first 5,000 units a month of entity analysis are free, and a unit is about 1,000 characters (Google Cloud: Natural Language API pricing). It's a useful second opinion on what a page centers on. It is a Google Cloud product, not a window into Google Search.

Why the words in your text aren't your keywords yet

A keyword list pulled from text shows your words. Customers may use different ones. A clinic page might repeat "physiotherapy" while people nearby search "physical therapy". Google's advice starts from the searcher, not the page:

"Think about the words that a user might search for to find a piece of your content." (Google Search Central: SEO Starter Guide)

The same guide says you don't need every wording on the page. Google's language matching systems "can understand how your page relates to many queries, even if you don't explicitly use the exact terms in them" (Google Search Central: SEO Starter Guide). So the gap worth fixing is a missing topic, not a missing synonym.

To check your list against real searches:

  1. Run the page's URL through Keyword Planner.
  2. In Search Console's Performance report, open the Pages tab, click the page, then switch to Queries. Search Console groups that table "by the search query users typed" (Search Console Help: Performance report).
  3. Compare. Words that appear in both lists are your page's real keywords. Searched words your text never mentions are the topics to add.

For the full process of picking which searches to go after, see keyword research for a local business.

What to do with the list

  • Put the main phrase in the page title, the main heading and the first lines. On-page SEO for service pages covers where each one goes.
  • Add a short section for each searched topic the text skips, such as price, area served or what's included.
  • Don't raise a word's count to match a tool. Repeating words is "tiring for users, and keyword stuffing is against Google's spam policies" (Google Search Central: SEO Starter Guide). The keyword density guide explains why no percentage is the target.

Example

A roofer checks a service page

The spreadsheet count puts "roof", "shingles" and "replacement" on top. Keyword Planner on the same URL suggests "roof repair" and "roof leak repair". The page never says "leak". The roofer adds a section on leak repairs with a typical price range.

A bookkeeper checks a competitor

She enters a competing firm's services page in Keyword Planner and sees "catch-up bookkeeping" among the ideas. Her own page doesn't mention it, though she does the work. She adds it as a service with its own heading.

FAQ

Is there a free keyword extractor I can paste text into?

Yes. A Google Sheet with the formula above, or any AI chatbot, lists the main words and phrases. Neither shows how often they're searched.

Can I find the keywords a competitor's page targets?

Keyword Planner takes any URL and shows searches related to it. Paid tools such as Semrush estimate which searches a site actually ranks for.

How many keywords should one page have?

One main phrase and its close variations, plus the questions buyers ask about that service. Give each separate service its own page.

Does keyword density matter when I check my text?

No. Google publishes no target percentage. Use the count to spot missing topics, not to hit a number.

Different for you?

Keep learning

NextKeyword research tools: Keyword Planner and Ahrefs step by stepHow to use Google Keyword Planner and Ahrefs Keywords Explorer for keyword research: the clicks, what each number means, what they cost, and which you need.

Do it yourself

Keyword research checklist: every step from seed to trackingA 15-step keyword research checklist for a small business: collect customer words, choose buyer searches, give each group one page, then track it free.

Ask us one question

One line is enough. We reply by email.

Sources

  1. Google Ads Help: Use Keyword Planner
  2. Google Ads Help: About Keyword Planner metrics
  3. Google Ads: Keyword Planner
  4. Search Console Help: Performance report (Search results)
  5. Google Search Central: SEO Starter Guide
  6. Google Cloud: Natural Language API, Entity reference
  7. Google Cloud: Natural Language API pricing
  8. Google Docs Editors Help: FLATTEN function
  9. Semrush Knowledge Base: Organic Positions report