Keyword finder from text: pull the keywords out of any page
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 callHow 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 know | Use | Free? |
|---|---|---|
| Which words and phrases this text uses most | A spreadsheet word count, or an AI chatbot | Yes |
| Which searches this text could match | Google Keyword Planner, "Start with a website" | Yes, with a Google Ads account |
| Which searches this page already shows up for | Google Search Console, Queries for that page | Yes, 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:
- Paste the whole text into cell A1.
- 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)`
- 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
| Tool | What you give it | What you get | The catch |
|---|---|---|---|
| AI chatbot (ChatGPT, Gemini, Claude) | Pasted text, plus "list the main topics and two- to three-word phrases" | A tidy list of phrases | It guesses. No search numbers, and it can list phrases nobody types |
| Google Cloud Natural Language API | Text, through its demo or code | Named things in the text, each with an importance score | Built for developers; Google doesn't say Search ranks pages this way |
| Google Keyword Planner | A page URL | Search phrases related to the page, with monthly search estimates | Needs a Google Ads account; numbers are rounded averages built for ad planning |
| Google Search Console | Nothing: it reads your site | Searches your page already appeared for | Only 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:
- Run the page's URL through Keyword Planner.
- 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).
- 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?
- The page is new and gets no traffic yet: Search Console has no queries for it. Start with keyword research for a local business.
- You haven't set up Search Console: see Google Search Console for a small business.
- You know the keywords but the page still doesn't rank: check the basics in on-page SEO for service pages, or have the SEO agent handle it.