Download My Intelligent Keyword Research Template Now

Are You Using Blacklisted Backlinks? Check Now

The easiest way to do keyword research is by using my free keyword research template.

This is something I had developed to help me build intelligent keyword strategies in minutes rather than days.

This free keyword research template will spit out a personalized keyword strategy based on your competitors search rankings in less than 5 minutes.

It does a bunch of cool things-

  • Automatically finds the best keywords with high search volumes & low competition
  • Tell you if its possible to win a featured snippet
  • Calculates the intent of the keyword to help you focus on $$$ keywords

YouTube video

Click Here To Download It Now

Because you can use my keyword research template to build an intelligent keyword strategy without spending any money!

How To Setup My Free Keyword Research Template

It only takes a few minutes to find all of the best keywords in your niche.

First take a look at this sample sheet and familiarize yourself with it.

Note: This sheet is view only, you need to make a copy of the blank template below.

There are 4x tabs at the bottom to navigate through-

  1. Start Here – Enter your competitor domains here
  2. Data – Enter the data you export here
  3. Keyword Analysis – Automatically finds the best keywords for you to select
  4. Final Selections – Shows you final keyword selections

Just take a moment to browse around and click on the checkboxes and things to see how it works.

When you are ready make a copy of the Google Sheet below-

Steal Your Keywords Sheet – MAKE A COPY OF ME

Do that by going to File > Make A Copy.

make a copy


You are going to take out the 100% free 14 day SEMRush trial.

This is where we are going to get all of the world class data to plug into the sheet without spending any cash! (mwahaha)

How To Setup The Sheet For Your Niche

Setting up the sheet is easy and really just boils down to a 2 step process-

  1. Import the data
  2. Make our keyword selections

It really doesn’t get any easier than that and the sheet will do all the heavy lifting in the background for us.

Step #1 – Start Here Tab

Go to the first tab “Start Here” and enter the domains of your competitors (without http or www) in column A-

Then click on the links to automatically open the right report that you need.

Make sure you are on the Organic Research > Positions report-

And then on the right side, scroll down a bit and click on the export button and select the first 3,000 rows to export-

Repeat this for each of the competitors until you have exported all of the data.

Step #2 – Loading The Data

Head over to tab #2 – Data and import each of the files you exported in step #1.

The quickest way to do that is-

  1. Open one of the files from step #1
  2. Delete the first row of data
  3. Highlight all of the remaining data and copy it
  4. Then paste it into Tab #2 of the google sheet
  5. Repeat the process adding each report you exported in step #1 to tab #2

This is how you should do it-

Once you have loaded in the data from all of your competitors, you are ready for…

Step #3 – Keyword Analysis

Now head over to the 3rd tab #3 – Keyword Analysis.

This sheet has already found the easiest to rank for keywords with the highest search volumes for you-

It also includes some extra helpful columns like if there is opportunity for a featured snippet.

It will also tell you if it’s a tyre kicker keyword (ignore these) or a commercial based keyword.

Just work through the sheet and tick the little tick box when you find keywords you like!

Step #4 – Review Your Final Selections

Last but not least jump over to the 4th tab #4 – Final Selections and review your final keyword choices.

Once you have done that, your personalized keyword strategy is complete!

Wrapping It Up

So there you have it! A free intelligent keyword research template that will-

  • Automatically find the best keywords with high search volumes & low competition
  • Tell you if its possible to win a featured snippet
  • Calculates the intent of the keyword to help you focus on $$$ keywords

Click Here To Download It Now

And tomorrow I’ll also send you another intelligent sheet that is focused on finding all of the best backlinks for those keywords as well!

Because once you have done that…

…you will have an intelligent SEO plan of attack based on cold hard data!

Click Here To Download The Intelligent Sheets Now

If you have any questions, please ask below and I will help you out!

Frequently Asked Questions

What is the best keyword research tool?
The best keyword research tools available on the market right now are:

  • SEMRush
  • Ahrefs
  • Long Tail Pro
  • My Intelligent Keyword Research Spreadsheet

How to do keyword research?
The best way to do keyword research is to use a premium keyword research tool combined with my intelligent spreadsheet, which will give you relevant keywords that bring the most qualified traffic to your site from the search engine results pages when optimised correctly.

What is SEO keyword research?
Keyword research for SEO is the process of finding the keywords that bring in high amounts of relevant traffic to your site. Finding keywords with high search volume but low competition is usually the best combination.

How important is keyword research?
Keyword research is probably one of the most important steps of your SEO strategy. Being able to rank highly in the SERPs for your target keywords is key to bringing in high levels of organic traffic. You need to research your keywords thoroughly for any chance of success.

How do I choose keywords for SEO?
Choosing keywords for your website is pretty simple:

  1. Choose a topic for your content
  2. Brainstorm keyword ideas
  3. Use a premium keyword research tool to collect your data
  4. Input the data into my intelligent spreadsheet

What is the best free keyword research tool?
Here is the list of the best free keyword research tools you can find out there:

  1. Google Keyword Planner
  2. Aherfs Keywords
  3. Answer The Public
  4. Ubersuggest
  5. Keyword Shitter

30 Responses

  1. umer Ali

    The article is very helpful. The instructions are very easy to follow. I will definitely use these tips in order to optimize my keyword research.

  2. John Ravi

    Hi Matthew,

    It was a great share! I am a marketer as well, and keyword research is one of the most important aspects of ranking your website higher. I already have a great keyword research process, but I think your template will be of great use as well. I will definitely be checking out this template, and I hope to streamline my keyword research process with your template. Thanks a lot for sharing such an amazing article, along with your own template.

  3. onenee

    good job

    • Matthew Woodward
      February 2nd, 2022 at 2:45 pm


  4. ghali

    I have read your article and it is awesome. Thanks you sharing this

    Today I got the actual answer, how should I write content.
    Thank you so much for providing this useful information

    • Matthew Woodward
      November 8th, 2021 at 9:31 am

      No problem- Glad it was helpful!

  5. Ivan

    The article is very helpful. The instructions are very easy to follow. I will definitely use these tips in order to optimize my keyword research.

    • Matthew Woodward
      August 9th, 2021 at 8:13 am

      Glad to hear that! Good luck!

  6. Virtual Assistant

    Hi, This article is helpful. Can you suggest any free tool to get organic keywords for a new website?

  7. Anand

    Very helpful content which simplifies the key task of keyword research. Is there any possibility of linking this spreadsheet with some free keyword tools like Google Keyword Planner

    People like me who runs with limited budgets may not be able to subscribe SEM Rush. Hope you understand and give suggestions accordingly.

  8. omae ahmed ahmed

    i cant make a copy help plz

    • Matthew Woodward
      August 6th, 2021 at 10:26 am

      You need to sign up to receive the sheet.
      If you click on the sample sheet, it won’t work. It’s set up on view only.

  9. Sourav

    Hello I unable to download that xlxs file can you please help?

    • Matthew Woodward
      August 6th, 2021 at 10:27 am

      Hi! You need to sign up to receive the sheet.
      If you click on the sample sheet, it won’t work. It’s set up on view only.

  10. Abhijit

    Indeed helpful sir!

  11. Shuktab

    If I want to download the spreadsheet for desktop use, what file format shall I select?(there are .xlsx, csv,html,.ods etc)

    • Matthew Woodward
      September 29th, 2020 at 9:10 am

      Hey Shuktab – I would suggest you use xlsx.

  12. Lakshmi


    I’ve been trying to download this template. But I’m not getting an email. It asks me to confirm and I’m not getting that email.

    • Matthew Woodward
      August 5th, 2020 at 10:50 am

      Hey – Could you please check in your spams as well – something it gets lost.

  13. Roy

    This sheet is not work for aherfs tool.
    Tell me how to use this sheet for ahrefs

    • Matthew Woodward
      April 22nd, 2020 at 9:17 am

      The Ahrefs version isn’t available right now

  14. Ardella Imes

    I dont understand how to get it

    • Matthew Woodward
      March 5th, 2020 at 12:38 am

      Just make a copy of the blank spreadsheet as instructed.

  15. aditi arora

    Hi, Thanks for this, I am gonna try.

    • Matthew Woodward
      January 21st, 2020 at 3:16 am


  16. Nirman

    Hi sir. I’m nirman from nepal. I am new to this affiliate marketing field. I have one question to ask. Does my url should have the keywords for seo? If so then it would be long domain name. And u have mentioned shorter the better. So how could I manage this. Sorry for my bad English tho. Thanke

    • Matthew Woodward
      September 30th, 2019 at 6:20 am

      It will help to have a couple of keywords relevant to that page in your URL but yes the shorter the better – just find the right balance.

    • manvee
      December 16th, 2019 at 6:58 am

      If you don’t find shorter domain including seo in your url… then go with .np your country extension.

What are your thoughts?

* Name, Email, Comment are Required