Free Resource

Free Keyword Research Template (Google Sheets)

A ready-to-use keyword research template with columns for search volume, keyword difficulty, search intent, current ranking, target URL, priority scoring, cluster assignment, and notes. The same template our team uses at ScaleGrowth.Digital to manage keyword data for 50+ client campaigns.

Last updated: March 2026 · Reading time: 9 min

Contents

What’s in this template

Template structure and columns
What’s inside the spreadsheet
How to use this keyword research template
Download the template
How do you classify search intent for each keyword?
How does priority scoring work?
How to cluster keywords into topic groups
Why most keyword research fails
FAQ

Template Preview

What columns does this keyword research template include?

9 core columns that turn raw keyword data into an actionable content plan.

This keyword research template has 9 core columns that capture everything you need to move from raw keyword data to an actionable content plan. It’s designed for teams using Ahrefs, SEMrush, or Google Keyword Planner as their data source. You export your keyword data, paste it in, and the template handles intent classification, priority scoring, and cluster grouping.

A keyword research template is a structured spreadsheet used to organize, prioritize, and map keywords to content. It turns raw search data into a ranked list of content opportunities with clear owners and deadlines.

Column	What it captures	Example value
Keyword	The exact search query	keyword research template
Search Volume	Monthly search volume (from Ahrefs, SEMrush, or GKP)	5,000
KD (Keyword Difficulty)	Difficulty score from your SEO tool (0-100 scale)	38
Intent	Search intent classification: Informational, Navigational, Transactional, or Commercial	Transactional
Current Rank	Your current position for this keyword (blank if not ranking)	14
Target URL	The page on your site that should rank for this keyword	/resources/seo/keyword-research-template/
Priority Score	Calculated score combining volume, difficulty, and intent (auto-formula)	72
Cluster	Topic cluster or content hub this keyword belongs to	SEO Templates
Notes	Free-text field for observations, competitor URLs, content angle ideas	Top 3 results are all downloadable templates

Spreadsheet Details

What’s inside the full spreadsheet?

The Google Sheets template includes four tabs, not just the keyword list. Most keyword research templates give you a flat list and nothing else. This one includes the analysis and mapping layers that turn data into decisions.

Keyword Database tab: The master list with all 9 columns, auto-sorting, conditional formatting (green for KD under 30, yellow for 30-60, red for 60+), and filter views by intent type
Priority Matrix tab: A scatter plot visualization of search volume vs. keyword difficulty, with keywords color-coded by intent. Helps you spot “golden keywords” (high volume + low difficulty) at a glance
Cluster Map tab: Keywords grouped by topic cluster with aggregate volume and average difficulty per cluster. Shows which clusters to prioritize for content creation
Content Plan tab: Maps clusters to target URLs, assigns content status (Not Started, In Progress, Published, Needs Update), and tracks publication dates

The priority score formula is transparent and editable: =((Volume/MAX(Volume))*40) + ((1-(KD/100))*35) + (Intent_Score*25). The weights default to 40% volume, 35% difficulty (inverted), and 25% intent value. You can adjust these weights based on your goals. E-commerce sites typically weight transactional intent higher. Content publishers weight volume higher.

How to Use

How do you fill in this keyword research template?

Start with a keyword export from your SEO tool. Don’t try to manually type keywords. Pull a bulk export from Ahrefs’ Keywords Explorer, SEMrush’s Keyword Magic Tool, or Google Keyword Planner. The template is designed to work with pasted data from any of these tools. Step 1: Export keyword data from your SEO tool. In Ahrefs, go to Keywords Explorer, enter your seed keywords, export the results as CSV. In SEMrush, use Keyword Magic Tool with your seed terms and export. You want at least 200-500 keywords to start. Step 2: Paste into the Keyword Database tab. Map the columns: keyword, search volume, and KD come directly from the export. Current Rank comes from your rank tracker (or leave blank for new keywords). Step 3: Classify search intent. Use the dropdown in the Intent column. The template includes a helper guide in the sidebar, but the rule is: if someone searching this keyword wants to buy, it’s Transactional. If they want to compare options, it’s Commercial. If they want to learn, it’s Informational. If they want a specific website, it’s Navigational. Step 4: Assign clusters. Group keywords that could be answered by the same page or belong to the same topic. “Keyword research template,” “keyword research spreadsheet,” and “free keyword research tool” probably belong in one cluster. “How to do keyword research” needs its own cluster (different intent, different content format). Step 5: Review the Priority Matrix. The scatter plot auto-populates. Look for keywords in the upper-left quadrant (high volume, low difficulty). Those are your best opportunities. The auto-calculated priority score handles this mathematically, but the visual confirms it.

Download

Download the Keyword Research Template

Auto-scoring formulas, conditional formatting, priority matrix, and cluster mapping.

Duplicate to your Drive and start organizing your keyword data in 5 minutes. Download Free Template →

No email required. Instant access via Google Sheets.

Intent Classification

How do you classify search intent for each keyword?

Search intent classification is the step most people skip, and it’s the step that determines whether your content actually ranks. Google’s entire algorithm is built around matching content to intent. If you publish a blog post for a keyword where the top 10 results are all product pages, you won’t rank. Period. There are four intent types. Here’s how to identify each one:

Intent Type	User wants to…	SERP signals	Content format
Informational	Learn something or get an answer	Featured snippets, “People also ask,” knowledge panels	Blog post, guide, how-to, explainer
Navigational	Find a specific website or page	Brand name in query, sitelinks, official result	Homepage, product page, login page
Commercial	Compare options before buying	“Best,” “vs,” “review” in results; comparison tables	Comparison page, review, roundup
Transactional	Take an action (buy, download, sign up)	Shopping ads, product carousels, pricing in titles	Product page, template download, tool page

The fastest way to classify intent: search the keyword in Google and look at the top 5 results. If they’re all how-to guides, the intent is informational. If they’re all product pages with pricing, it’s transactional. Don’t guess. Look at what Google is already rewarding. In the template, intent classifications feed into the priority score formula. Transactional and commercial keywords get a higher intent score (0.8-1.0) than informational keywords (0.4-0.6) by default. This is adjustable, but the logic is sound: keywords closer to a purchase decision are more valuable for most businesses.

Priority Scoring

How does the priority scoring formula work?

The priority score reduces a three-dimensional decision (volume, difficulty, intent) into a single number between 0 and 100. It answers the question: “Which keyword should I write content for first?” The formula weights three factors and lets you adjust the weights based on your business goals. The default formula:

40% search volume (normalized to 0-1 scale against max volume in your list)
35% inverted difficulty (lower difficulty = higher score, normalized to 0-1)
25% intent value (Transactional = 1.0, Commercial = 0.8, Informational = 0.5, Navigational = 0.3)

A keyword with 10,000 monthly searches, KD 25, and transactional intent would score around 85. A keyword with 500 monthly searches, KD 70, and informational intent would score around 25. The formula makes these tradeoffs explicit rather than leaving them to gut feel. When to adjust the weights: if you’re building topical authority in a new niche, increase the informational intent weight (readers today, customers tomorrow). If you need revenue this quarter, weight transactional intent and low difficulty higher. The template’s weights are editable in a settings cell at the top of the Priority Matrix tab.

Keyword Clustering

How do you cluster keywords into topic groups?

Keyword clustering is the process of grouping keywords that should be targeted by the same page. Two keywords belong in the same cluster if a single page could realistically rank for both. The test: search both keywords in Google. If the top 3 results overlap (same URLs appearing for both), they belong in one cluster. If the results are completely different, they need separate pages. For a list of 500 keywords, manual clustering takes 2-3 hours. Tools like KeyClusters, SE Ranking, or Keyword Insights can automate this by checking SERP overlap, but we recommend manual review for your top 50 keywords. Automated clustering misses nuances in intent. In the template’s Cluster Map tab, each cluster shows:

Cluster name (the topic or hub label)
Primary keyword (highest volume keyword in the cluster)
Total cluster volume (sum of all keyword volumes in the cluster)
Average KD (average difficulty across the cluster)
Keyword count (number of keywords in the cluster)
Assigned URL (the target page for this cluster)

The cluster with the highest total volume isn’t always the best place to start. Look for clusters with high volume AND low average difficulty. Those are the clusters where you can win fastest. At ScaleGrowth.Digital, we typically identify 3-5 “quick win” clusters in every keyword research project.

Expert Context

Why does most keyword research produce a list that nobody acts on?

The typical keyword research process produces a spreadsheet with 2,000 keywords, sorted by search volume, and then nothing happens. The marketing team doesn’t know which keywords to prioritize. The content team doesn’t know what format to use. And six months later, someone exports the same keywords again and starts over. This happens because most keyword research stops at data collection. It doesn’t include the decision-making layers: intent classification, priority scoring, and cluster-to-URL mapping. Without those layers, a keyword list is just noise. It’s like having a stack of building materials with no blueprint.

“Every keyword research project we do at ScaleGrowth.Digital ends with a mapped content plan, not just a keyword list. The research isn’t done until every keyword has an intent, a priority score, a cluster, and a target URL. That last mile of work is what turns data into a content calendar that actually gets executed.”
Hardik Shah, Founder of ScaleGrowth.Digital

The other common failure: using search volume as the only prioritization metric. We’ve seen teams spend 6 months chasing a 50,000-volume keyword with KD 85 when there were 20 keywords at 2,000-5,000 volume with KD 15-25 sitting right there in the data. The priority scoring formula in this template prevents that mistake by balancing volume against achievability. If you’re building a keyword strategy alongside this template, you’ll want our keyword mapping template for the URL assignment layer, and our keyword density checker for validating on-page usage after publication.

Related Resources

What should you use alongside this template?

Pair this template with these resources for a complete keyword workflow.

Complete SEO Checklist (47 Points)

The comprehensive SEO checklist covering technical, on-page, off-page, local SEO, content quality, and AI visibility. Get Checklist →

Keyword Mapping Template

Map your researched keywords to specific URLs with cannibalization checks and content status tracking. Get Template →

On-Page SEO Checklist

Once you’ve identified target keywords, use this checklist to optimize each page for maximum ranking potential. Get Checklist →

FAQ

Frequently Asked Questions

How many keywords should I include in my keyword research template?

Start with 200-500 keywords for a focused niche, or 1,000-3,000 for a broad site. More isn’t always better. A list of 500 well-classified keywords with intent mapping and priority scores is far more useful than 5,000 keywords dumped into a spreadsheet with no analysis. Focus on quality of classification over quantity of data.

What’s the best keyword research tool for filling in this template?

Ahrefs Keywords Explorer and SEMrush Keyword Magic Tool are the most comprehensive paid options (starting at $99/month). For free alternatives, Google Keyword Planner gives search volume ranges (requires a Google Ads account), and Ubersuggest offers limited free searches. The template works with data from any tool. Just match the columns: keyword, volume, and difficulty.

How often should I update my keyword research?

Refresh your keyword data every 6 months. Search volumes shift seasonally, new keywords emerge as topics trend, and your rankings change. At minimum, re-pull the “Current Rank” column monthly to track progress. Full re-research (new seed keywords, expanded exports) should happen twice a year or when entering a new market segment.

Should I target high-volume or low-difficulty keywords first?

Neither in isolation. The priority score in this template balances both factors. For new sites with low domain authority, weight difficulty higher (target KD under 30). For established sites (DR 50+), you can afford to go after higher-difficulty terms. The best strategy: start with low-difficulty keywords to build topical authority, then use that authority to rank for harder terms.

What’s the difference between a keyword research template and a keyword mapping template?

A keyword research template organizes raw keyword data: volumes, difficulty, intent, and priority. A keyword mapping template takes the next step: it assigns each keyword (or cluster) to a specific URL on your site and tracks whether that URL has been created, optimized, or needs updating. This template includes a basic mapping layer in the Content Plan tab, but a dedicated keyword mapping template goes deeper into URL-level tracking.