A keyword research spreadsheet template structures discovery, analysis, and prioritization into repeatable columns and workflows. This walkthrough covers what fields to include, how to populate each one, and how to turn the spreadsheet into actionable content and technical decisions.
Start with a Keyword Phrase column wide enough for long-tail variants and questions. Next, add Volume—monthly search estimates from Keyword Planner, Ubersuggest, or your SEO platform. Include a Difficulty or Competition score; most tools export a 0-100 scale, but you can also flag high/medium/low manually if working from Keyword Planner's competition tiers. Add an Intent column and classify each row as informational, commercial investigation, navigational, or transactional. This drives targeting decisions more than volume alone. Include Current Rank if you already appear for the term; enter the position or leave blank. Add Target URL to map each keyword to an existing or planned page. Finally, a Priority column—use high/medium/low or a numeric score—to flag which terms warrant immediate action. Optional but useful: a Parent Topic or Cluster column to group semantically related keywords, and a Notes field for context like seasonality, local modifiers (Montreal, Toronto), or competitor gaps.
Begin with seed keywords: five to ten broad terms your business actually serves. Export suggestions from Google Keyword Planner (set location to Canada if relevant), Ubersuggest, or AnswerThePublic. Paste the raw export into a Discovery tab. Clean duplicates and irrelevant phrases. For volume, use the tool's estimate as-is; if a range is given (e.g. 100-1K), record the midpoint or the range itself. For difficulty, copy the tool's metric or assess manually: if the top ten results are all high-authority domains with dedicated pages, mark it high; if you see forums, thin pages, or mixed intent, mark it medium or low. Classify intent by reading the SERP: mostly blog posts and guides means informational; product comparisons and reviews signal commercial; homepages and brand searches are navigational; checkout-adjacent pages indicate transactional. Populate Current Rank by checking Search Console for impressions and average position, or manually search in an incognito window. Assign Target URL by matching intent—informational keywords to blog posts, transactional to product or service pages.
Use a multi-tab structure. The Discovery tab holds the raw export—hundreds or thousands of rows with minimal filtering. The Shortlist tab is where you copy high-priority keywords after applying filters: volume above a threshold that matches your domain authority (often 50+ for newer sites, 200+ for established ones), difficulty within reach, and intent aligned with existing or planned content. The Tracking tab lists keywords you are actively optimizing for, with columns for Current Rank, Target URL, Date Last Updated, and Status (e.g. content published, internal links added, page optimized). Update this tab monthly. If you serve multiple regions or product lines, consider separate shortlist tabs—one for Ottawa-focused local terms, another for national commercial keywords, another for French-language Quebec queries. This prevents the spreadsheet from becoming a single unwieldy list and lets different team members own different segments.
Apply conditional formatting to the Priority column so high-priority rows highlight in green or bold. Sort by Priority, then by Volume descending, to see the biggest wins at the top. Use auto-filter on the Intent column to isolate informational keywords when planning blog content or transactional keywords when optimizing product pages. Filter by Difficulty to find quick wins—terms where you have authority but no dedicated page yet. If you included a Cluster column, sort by it to group related keywords together; this reveals content hub opportunities where a single pillar page and three to five supporting articles can capture a semantic set. In Google Sheets or Excel, use the COUNTIF function to tally how many keywords map to each Target URL; if one URL has fifteen assigned keywords, that page deserves more internal links and on-page depth. Flag any keyword with volume above your threshold, low difficulty, and no current rank—that is net-new opportunity with minimal competition.
Each high-priority row becomes a content brief or optimization ticket. For a new blog post, copy the keyword phrase, intent, and top three related cluster terms into a brief doc. Research the top five ranking pages—note word count, subheadings, media, and structured data. Use that context to set a target length and outline, not to fabricate specifics. For an existing page, compare the assigned keywords against current on-page elements: does the title tag include the primary phrase, do subheadings cover the intent, are related terms present in the first 200 words? Update meta descriptions and internal anchor text to match. Build a quarterly content calendar by sorting the shortlist by Priority and assigning one article per week or two per month, depending on capacity. Mark published pieces in the Tracking tab and update rank monthly. The spreadsheet also informs technical decisions: if transactional keywords cluster around a single product category, that category may need faceted navigation or schema markup; if local keywords dominate, prioritize Google Business Profile optimization and local link building.
Keyword research is not one-and-done. Set a quarterly refresh: export new suggestions from your tools, append them to the Discovery tab, and re-run your filters. Check the Tracking tab monthly—update ranks from Search Console, note any drops (which may signal new competition or algorithm shifts), and celebrate gains. Archive completed keywords into a separate Done tab to keep the Shortlist focused on active work. If search behavior shifts—seasonality, new product launches, regulatory changes like Canadian privacy law updates—add those seed terms and re-expand. When you migrate the site, launch new services, or rebrand, duplicate the entire spreadsheet and start a fresh version rather than overwriting historical data. Label each version with a date. Over time, you will build a library of keyword snapshots that show how search demand and your competitive position evolved, which informs future strategy more reliably than any single cross-sectional export.
At minimum, include Keyword Phrase, Volume estimate, Difficulty or Competition score, Intent category, and Target URL. These five fields let you prioritize and map keywords to pages. Priority or Status and Current Rank columns add substantial value if you plan to track progress or manage a team, but you can start with the core five and expand as workflows mature.
If you serve both English and French markets or operate in distinct metros like Ottawa, Montreal, and Vancouver with localized service pages, use separate tabs within one spreadsheet rather than entirely separate files. Label tabs by region or language, share core columns, and keep a master shortlist tab that pulls high-priority rows from each. This approach maintains a single source of truth while respecting different search landscapes and content calendars.
Refresh volume and difficulty quarterly or when you notice rank volatility. Search volume can shift with seasonality, trends, or new competitors entering the market. Difficulty scores change as domains build authority or as Google updates ranking factors. Set a calendar reminder every three months to re-export data from your tool, compare it against the existing spreadsheet, and update any row where volume or difficulty has moved significantly.
Yes. Keyword Planner provides volume ranges and competition levels, which you can record in the Volume and Difficulty columns. Use AnswerThePublic or Google autocomplete for question-based long-tail variants. Classify intent manually by reviewing the SERP for each keyword. The template structure works regardless of tool; paid platforms like Ahrefs or Semrush simply speed up exports and provide more granular metrics, but the decision framework—volume, difficulty, intent, target URL—remains identical.
Priority is a judgment call based on volume, difficulty, intent fit, and current rank. Mark a keyword high priority if volume is within your site's reach, difficulty is equal to or below your domain authority tier, intent matches existing content or a planned page, and you currently rank outside the top twenty or not at all. Medium priority applies when one or two of those factors are marginal. Low priority flags keywords that are interesting but require more authority or content than you have today. Document your thresholds in a notes tab so the logic is transparent and repeatable.
Use separate tabs for Discovery (raw exports), Shortlist (filtered high-priority terms), Tracking (active optimization), and Done (completed or deprioritized keywords). Apply auto-filters liberally and sort by Priority or Volume to keep the working view focused. Archive old exports into dated tabs rather than deleting them. If the file exceeds a few thousand rows and slows down, export the Shortlist to a fresh workbook each quarter and link back to the archive for historical reference. Keep the active working sheet lean and action-oriented.