Free SEO Keyword Research Excel Spreadsheet Template (Download + Tutorial)

TL;DR: This free SEO keyword research Excel template walks you through the full process from market research to keyword clustering, with 4 structured tabs and 15 built-in data sources. Download it for Excel or open it in Google Sheets, then follow the video tutorial above to use it on any niche.

Most people start keyword research by opening a tool and typing a word. That’s backwards. You end up with a random pile of keywords that have no strategic foundation, no understanding of your audience, and no real sense of which opportunities are actually worth chasing.

I built this template to fix that problem. Before you open Semrush or Ahrefs or even Google Keyword Planner, this spreadsheet forces you to think clearly about your market, your audience, and where keywords actually live in the real world.

Watch the full tutorial where I walk through using this template live on a niche I know nothing about:

In this guide, I’ll walk you through exactly what is in the template, how each tab works, and how to use 15 free data sources to fill it out before you ever open a paid SEO tool.

Download the free template:

What Is This SEO Keyword Research Excel Template and Who Is It For?

This SEO keyword research Excel template is a structured spreadsheet (also works in Google Sheets) that guides you through the keyword research process step by step. It’s not a dashboard. It’s not a tool. It’s a framework for thinking before you research.

I designed it for two types of people:

Type 1: You already have a business. You know your niche, you serve customers, and you have intuition about what problems they have. This template helps you translate that intuition into a structured keyword list before you validate it in a tool.

Type 2: You are entering a new niche cold. Maybe you are an affiliate marketer, a freelancer taking on a new client, or a content creator branching into unfamiliar territory. You have no domain expertise. This template shows you exactly where to go to learn the language of any industry before you start targeting keywords.

Both types of users face the same core problem: without a systematic approach to keyword brainstorming, you miss the most valuable keywords. The ones that are obvious to your customers but invisible to people who just type broad terms into a keyword tool.

I use this keyword research spreadsheet on every new project I take on. For the video tutorial, I picked “office cleaning service” as a niche I know nothing about, and walked through the entire process live.

How to Download the Template

You have two options depending on how you work:

Excel download: Click the link and the .xlsx file downloads directly. Works in Microsoft Excel, LibreOffice Calc, and any compatible spreadsheet tool.

Google Sheets: Click the Google Sheets link and it opens the template. Go to File > Make a copy to save it to your own Google Drive. Don’t request edit access to the original.

Download the free keyword research template

The 4-Tab Structure of the Template

The spreadsheet has four tabs, each building on the previous one. Here is what each section does and why the order matters.

Tab 1: Market Research

This is where you answer the foundational questions about your market before touching any keyword data.

The market research tab asks you to document:

  • Your industry and niche: What exactly is the business? What specific segment of the market are you targeting?
  • Your target audience: Who are the customers? What demographic, psychographic, and behavioral characteristics define them?
  • Pain points and problems: What specific problems is your audience trying to solve? What keeps them up at night?
  • Goals and motivations: What outcome are they looking for? What does success look like to them? (For a deeper dive into this, my guide on building a buyer persona for small business SEO walks through the full process.)
  • Where your audience gathers: Which forums, communities, social platforms, and publications do they read?
  • Competitor landscape: Who else is serving this audience? What do their websites, content, and messaging look like?
  • Industry terminology: What words and phrases do people in this space actually use? Not what you think they use.

The reason this tab comes first is simple: people who skip this step end up doing keyword research in their own head instead of in their customer’s head. You end up targeting keywords based on how you describe your product, not how your customer searches for it.

If you already know your industry, fill this out from memory and lived experience. If you are entering a new niche, this tab becomes a research checklist. You cannot move to Tab 2 until you have at least partial answers to these questions.

Tab 2: Find Seed Keywords (15 Free Data Sources)

This is the heart of the template. It gives you 15 different sources for discovering seed keywords, each with a checkbox so you can track which ones you have explored.

I’ll cover all 15 sources in detail in the next section of this guide. The key point here is the structure: each source has a row, a description of what to look for, and a place to record the keywords you find.

The tab auto-aggregates your total count as you add keywords, which gives you a sense of how deep your initial research has gone. Most people stop after two or three sources. The template shows you there are 12 more you are leaving on the table.

Tab 3: Expand and Validate Your Keyword List

Once you have your seed keywords, Tab 3 is where you take them into keyword research tools to expand and validate them.

This tab is structured to record:

  • Keyword: The exact phrase
  • Monthly search volume: What the tool reports (Semrush, Ahrefs, Google Keyword Planner, or others)
  • Keyword type: Is this a long-tail keyword, a short-tail keyword, or a mid-length keyword?
  • Intent classification: Is this informational, commercial, navigational, or transactional?

If you’re looking for an efficient way to find easy-to-rank keywords during this step, my guide on Semrush easy-to-rank long-tail keywords shows the exact workflow I use.

The template auto-calculates total estimated search volume across all keywords in the tab. This gives you a real sense of the traffic opportunity you are building towards.

One important note on search volume: these numbers are estimates. No tool has access to Google’s actual data. I always cross-reference between at least two tools before making decisions based on volume. Google Search Console is the only source of real click data, and that only works for pages you have already ranked.

If you want a free way to start this validation without a paid tool, check out my guide on Google Search Console keyword research and how I use it to find real search data.

Tab 4: Keyword Clustering and Grouping

This is where raw keywords become a content strategy.

Tab 4 uses color-coding to group keywords by theme, intent, and priority. You are essentially building your content plan here: which topics become pillar articles, which become supporting posts, and which keywords should be combined onto a single page because they share the same search intent.

The clustering logic matters because Google does not rank individual keywords, it ranks pages. A page targeting 15 closely related keywords around one topic will almost always outperform 15 separate pages each targeting one keyword.

For a structured approach to clustering, I have a full guide on keyword clustering with Semrush that shows my exact process. But you can do a basic version of this manually in the template.

The 15 Free Keyword Research Sources (With How to Use Each One)

This is where most keyword research guides stop at “use Google Autocomplete and check Quora.” That’s leaving 13 sources untouched. Here is every source in the template and exactly what to do with it.

SEO keyword research template overview showing market research and seed keyword tabs

1. Keyword Research Software

Yes, free keyword tools count. Before spending money on Semrush or Ahrefs, you’ve got legitimate free options: Google Keyword Planner, Ubersuggest’s free tier, and Semrush’s free daily searches.

The point here isn’t to do your full keyword validation in these tools. It is to generate your initial seed list. Type your broadest topic term and look at what the tool suggests. Record anything that looks relevant in Tab 2.

For a no-cost approach to using Semrush for initial research, see my Semrush Keyword Magic Tool tutorial.

2. Forums and Online Communities

This is one of the most underused keyword sources. Forums reveal the exact language your audience uses when they are not performing for anyone. They are talking to each other, not to a search engine.

How to find forums for any niche:

  • Search [your topic] + forum in Google
  • Search [your topic] + community
  • Use the search operator site:reddit.com [your topic]
  • Search [your topic] + site:quora.com
  • Look for niche-specific forums (photography forums, home improvement forums, local business forums)

When you are inside a forum, you are not looking for keywords in the traditional sense. You are looking for the questions people ask repeatedly, the problems that appear in thread after thread, and the specific terminology that insiders use.

For the office cleaning example from the video: a cleaning forum might reveal that customers ask repeatedly about “green cleaning products” or “bond cleaning” or “post-construction cleaning.” These are specific phrases that broad keyword research would never surface.

The search operator intitle:forum [keyword] in Google also works well to find active discussion boards in any niche.

3. Social Media Platforms

Social media is a real-time keyword research tool. The things people post, hashtag, and search for on social platforms reveal what is on their minds right now, not six months ago when the keyword tool last updated its database.

YouTube: Search your main topic and look at video titles. The titles that get high views are effectively proven keywords. Creators title their videos around what people search for. Also look at the tags visible in a video’s page source.

Pinterest: Highly visual and search-driven. Type your topic into Pinterest search and look at the suggested searches that appear. These are real search queries from Pinterest users.

Instagram: Look at hashtags used by accounts in your niche. The most-used hashtags often correspond to search terms people care about.

Facebook Groups: Join groups in your niche and read the posts. What questions do members ask? What pain points come up repeatedly? What terminology do members use naturally?

Twitter/X and LinkedIn: Search for your main topic and look at what people are talking about, what language they use, and what specific problems they mention.

The key with social media research is to look for patterns. One post mentioning a term is a data point. Ten posts mentioning the same term is a keyword worth investigating.

4. Talking with Customers and Real People

This sounds obvious. It’s not. Most content creators and SEO practitioners never actually talk to the customers they are trying to reach.

If you have an existing business, the most valuable keyword research you can do is simply asking your customers: “What did you search for before you found us? What words did you use?” Their answer will almost never match the keywords you think they are using.

If you don’t have customers yet, talk to people who could be customers. Find three to five people who fit your target audience and ask them:

  • “If you were looking for [your service/product] online, what would you type into Google?”
  • “What problem were you trying to solve when you last searched for this?”
  • “What questions did you have that you could not find good answers to?”

Record every phrase they use verbatim. Don’t clean it up or normalize it. Their messy, natural-language search queries are your most honest keyword data.

5. News Sites and Industry Publications

Google News, industry trade publications, and news aggregators reveal trending topics and emerging terminology. If your niche is evolving (and most niches are), the vocabulary is also evolving.

For any niche, search Google News for your main topic. Look at the headlines. What specific terms appear repeatedly? What new problems or technologies are journalists covering?

For the office cleaning example: a news search might reveal growing coverage of “electrostatic disinfection” or “antimicrobial surface treatments.” These are terms that would not appear in a keyword research tool six months ago but are already entering customer conversations.

Industry trade publications are especially valuable for B2B niches. Trade journals use the precise technical vocabulary that decision-makers search for. That vocabulary often has low keyword difficulty because few content creators bother to read trade journals.

6. Shopping Sites (Amazon, Google Shopping, eBay)

Product listings are keyword gold mines, especially for commercial and transactional keywords.

Amazon: Search your topic on Amazon. Look at product titles, which are optimized for both Amazon’s search algorithm and buyer language. Look at the category structure, which tells you how Amazon (and therefore buyers) organize the topic space. Most importantly, read product reviews. Customer reviews contain verbatim descriptions of what buyers were looking for, what problems they had, and what language they used when making their decision.

Google Shopping: The product names and descriptions that appear in Google Shopping are optimized for commercial searches. Look at the filters and categories Google surfaces.

eBay and Etsy: Both platforms have search autocomplete that reveals how buyers describe the products they want.

For the office cleaning example: searching Amazon for “office cleaning” would surface products like “commercial floor cleaner,” “industrial disinfectant spray,” and “janitorial supplies.” Each of these is a keyword category worth exploring.

7. Blogs and Niche Sites

Your competitors’ blogs and niche content sites are essentially public keyword research. Every article title, every category, every tag is telling you what topics the site believes their audience cares about.

How to mine competitor blogs for keywords:

  1. Find the top-ranking content sites in your niche (search your main topic and look at who ranks on page 1)
  2. Go to their blog and look at category names, article titles, and tag pages
  3. Use a free tool like Ubersuggest to see which of their pages get the most organic traffic
  4. Read their most popular articles and note the specific terms and sub-topics they cover

The goal isn’t to copy their content. It’s to understand the full topical landscape. A strong niche blog will have explored most of the keyword territory. Your job is to identify which parts of that territory they cover well and which parts they are missing or covering badly.

8. Competitor Websites

Go deeper than just the blog. Look at the full website structure of your main competitors.

Homepage and navigation: How do they describe their product or service? What words do they use in their main navigation? These are the terms they have decided are most important to their audience.

Service or product pages: Every separate service or product page corresponds to a search intent. If a competitor has a dedicated page for “deep cleaning services” and “move-out cleaning services,” they are telling you those are distinct enough keywords to deserve separate pages.

About and FAQ pages: Frequently Asked Questions pages are essentially a list of the most common things customers ask. Every FAQ entry is a potential keyword.

Meta titles (visible in browser tabs): These are explicitly optimized for search. Right-click on any page and view page source to see the exact meta title and meta description a competitor is targeting.

For deeper competitor keyword analysis, my guide on Semrush Organic Research shows you how to see exactly what keywords a competitor ranks for.

9. Local Directories and Classified Ads

This source is especially valuable for local businesses and local SEO, but it applies to any niche with geographic or service-area variation.

Yellow Pages and local directories: Look at how businesses in your niche describe their services. The category names and service descriptions in directories reveal how customers think about the service.

Craigslist and classified ad sites: People posting in classified ads write in natural language. A plumber advertising on Craigslist will describe their services the way a customer would search for them.

Google My Business listings: Search your topic plus a city name and look at the business descriptions in the map pack. These are keyword-optimized by the business owners and reveal local terminology.

For a full breakdown of local SEO keyword strategy, see my article on types of SEO including local SEO.

10. Industry Experts and Thought Leaders

The people who have been in a niche for years have a vocabulary that generic keyword research completely misses.

Find the top five to ten thought leaders in your niche. They might be conference speakers, podcast hosts, book authors, or prolific LinkedIn contributors.

Look at:

  • The titles of their talks and presentations
  • The chapters of any books they have written
  • The topics of their podcast episodes
  • The specific terms and frameworks they use in interviews

Industry experts often use technical vocabulary that has high buyer intent but low keyword difficulty precisely because most content creators do not read this material. A term that is obvious to an industry insider may be a goldmine for someone targeting a professional audience.

11. Search Engines (Google and Bing Autocomplete)

Everyone knows about Google Autocomplete. Not everyone uses it systematically.

Type your seed keyword into Google and look at:

  • Autocomplete suggestions: What does Google suggest as you type?
  • People Also Ask: The questions that appear in the accordion below the top result
  • Related searches: The eight suggestions at the very bottom of the search results page

Repeat this process for every seed keyword you have. Then take the suggestions and run them through the same process. This tree-branching approach can quickly surface hundreds of specific keyword variations.

Do the same thing on Bing. Bing’s autocomplete often surfaces different suggestions than Google, especially for commercial queries.

Also try Google’s “Search for” suggestion, which appears when you type a partial query. It reveals how real users complete searches in real time.

12. Wikipedia

Wikipedia is a structured map of every major topic on the internet. It’s a keyword research tool that almost nobody uses deliberately.

Here is how to use it:

  1. Search your main topic on Wikipedia
  2. Look at the Table of Contents of the main article. Each section heading is a sub-topic and a potential keyword cluster
  3. Look at the categories at the bottom of the article. Each category leads to related topic pages
  4. Look at the “See also” section. These are closely related topics your audience is also interested in
  5. Follow links to related Wikipedia articles and repeat

For the office cleaning example: the Wikipedia article on “cleaning” would have sections on cleaning methods, cleaning chemicals, cleaning industry, green cleaning, and more. Each section is a potential content cluster.

The categories would connect to facility management, janitorial services, and commercial cleaning. Each connection is a keyword territory worth mapping.

Wikipedia also uses the technical, formal names for things. This is useful for identifying the “official” terminology that your niche uses, which may differ from the common names your customers use. Knowing both versions lets you cover the full range of how people search.

13. Advertisements (Google and Bing Paid Ads)

Advertisers pay for every click. They don’t pay for keywords that don’t convert. This means paid ad copy and the keywords that trigger it represent the highest-confidence signal for commercial intent.

Google Ads: Search your main topic on Google and look at the paid ads that appear at the top and bottom of the results page. The headline language and description copy are carefully optimized to match buyer intent. The specific phrases used in ad headlines are essentially validated commercial keywords.

Bing Ads: Repeat the same search on Bing. The advertiser population is slightly different, and you may find different commercial angle.

Facebook Ads Library: Search the Facebook Ads Library (free, publicly accessible) for your main topic. Look at how advertisers describe their products and what specific problems they claim to solve. The language in high-performing Facebook ads reveals buyer language in a different context than search ads.

The specific phrases that appear repeatedly across multiple advertisers are the ones with the highest commercial value. If five different companies are bidding on “same day office cleaning” as a phrase in their ads, that phrase has commercial intent worth targeting organically.

14. Question and Answer Communities

Quora, Reddit, and similar Q&A communities are databases of every question your audience has ever asked publicly.

Quora: Search your topic on Quora. Look at the most-followed questions. The exact phrasing of popular questions is keyword-ready. People ask Quora the same things they type into Google. The most-viewed Quora questions in your niche are often directly rankable on Google.

Reddit: Use Reddit search to find threads in your niche. Reddit is particularly valuable for understanding the emotional context behind searches. Not just what people ask, but why they are asking and how frustrated or confused they are. This depth of understanding improves the content you write around those keywords.

Answer The Public and Answer Socrates: These free tools are built specifically for extracting question-based keywords from search engine autocomplete data. They generate dozens of “who, what, where, when, why, how” variations around any seed keyword.

I have a review of Answer Socrates that shows how I use it to fill in my keyword lists quickly.

15. Your Own Customer Touchpoints

If you have an existing business, your own data is the most accurate keyword source available.

Support tickets and chat logs: The exact questions and complaints your customers submit through support channels are keywords. If customers repeatedly ask “how do I clean without chemicals,” that phrase is a keyword worth targeting.

Sales call recordings: If your team takes sales calls, review recordings for the language prospects use to describe their problem. “We need someone to handle the office” versus “we need commercial cleaning services” are different search intents.

Email inquiries: The subject lines and opening sentences of inbound emails often contain the exact search queries people used to find you.

Internal site search: If your website has a search bar, the queries people type in are directly telling you what they could not find. Every internal search query is a content gap.

If you’re not yet collecting any of this data, start now. It’s the most honest keyword research you’ll ever do.

How to Use the Keyword Research Excel Template from Start to Finish

Here is the sequence that gives you the best results.

Day 1 - Market Research Tab (2-4 hours): Do not skip this. Fill out every question you can answer about your audience, their pain points, and the industry landscape. Leave blanks for things you genuinely do not know. Those blanks tell you where to focus your research.

Day 1-2 - Source Research (4-8 hours for a thorough job): Work through the 15 sources systematically. Don’t rush. For each source, spend at least 15-20 minutes genuinely exploring the platform and recording keyword ideas. I recommend spending a full day on this if the niche is new to you.

Day 2-3 - Expand in Keyword Tools: Take your seed keywords from Tab 2 into your keyword research tool of choice. I use Semrush’s Keyword Magic Tool for this. If you don’t have a paid tool, Google Keyword Planner is free. Record search volume and keyword type in Tab 3.

Day 3-4 - Cluster and Prioritize (Tab 4): Group related keywords together by topic and intent. Use the color coding to prioritize. Which clusters have the most volume and the lowest competition? Those become your first content targets.

After completion - Run through SEO tools: Now you have a real foundation. Your keyword list isn’t a random selection of what a tool surfaced. It’s a structured map of what your audience actually searches for, organized by opportunity.

The full keyword research template process takes time. That is the point. Anyone can do keyword research in 30 minutes. Not everyone can build a keyword strategy that captures opportunities their competitors are still missing six months later.

Common Mistakes to Avoid with This Template

Filling in only the sources you already know. The whole point of the 15-source structure is to push you beyond your defaults. If you only ever use Google Autocomplete and Wikipedia, you are doing keyword research that any competitor with 20 minutes can replicate.

Treating search volume as the final authority. Volume data from any tool is an estimate. I have seen pages rank for keywords that tools said had zero monthly searches. Always combine volume data with real judgment about relevance and intent.

Skipping the market research tab. I know it feels like prep work when you want to get to the “real” research. But keyword research without market understanding is just data entry. The market research tab is what turns keyword lists into strategy.

Clustering too broadly. Putting 50 keywords into one cluster and expecting one article to rank for all of them is not a strategy. Be specific with your clustering. If two keywords would require different content to satisfy the searcher, they belong in different clusters.

Doing this once and never updating. Markets change. New terminology enters niches constantly. The template is most valuable when you revisit it quarterly and check whether new sources or new terminology has emerged in your space.

Download the Free Keyword Research Template and Get Started

The template is free. There’s no email required for the Excel version.

Download the Excel template

Open in Google Sheets

Once you have it, watch the video tutorial at the top of this page. I walk through the entire process live using a niche I selected at random. Seeing it done on an unfamiliar niche is more useful than seeing it done on something comfortable.

If you want to go deeper on any specific part of the keyword research process, here are the tools and guides I use:

Frequently Asked Questions

Is this template really free?

Yes. No email required for the Google Sheets version. The Excel download also requires no sign-up. I built it as part of my keyword research course and made it freely available because the course teaches the process, not the spreadsheet.

Does this work for any niche?

Yes. The 15 sources and 4-tab structure work for any niche: local services, e-commerce, SaaS, affiliate sites, blogs, and B2B. The example in the video uses “office cleaning service” because I chose it randomly to demonstrate the process works even without domain expertise.

Can I use this for YouTube keyword research?

Partially. Tabs 1 and 2 transfer directly. For Tab 3, you would replace search volume data with YouTube search volume estimates (which tools like VidIQ and TubeBuddy provide). The 15 sources in Tab 2 are also applicable to YouTube because many of them (forums, social media, Q&A sites) reveal what questions people want answered in video format.

What keyword research tool should I use to fill out Tab 3?

If you have budget, Semrush or Ahrefs. If you want to keep costs low, Semdash is a lifetime deal alternative with solid keyword data. If you need completely free, Google Keyword Planner gives volume ranges that are enough to prioritize your list.

How long does this process take?

For a niche you know well: 4-6 hours across all four tabs. For a brand new niche: a full day is appropriate. Do not rush the seed keyword sources. Most of the value comes from discovering terms you would not have found in a tool.

Should I complete this before or after competitor analysis?

The market research tab includes competitor analysis as one of its questions. But a dedicated competitor keyword gap analysis is a separate step that comes after you have your own keyword list. See my guide on Semrush Keyword Gap analysis for that process.

Disclosure: Some links in this post are affiliate links. I provide both referral and non-referral versions where possible. See my transparency policy for details.