Skip to content
    Moz logo Menu open Menu close
    • Products
      • Moz Pro
      • Moz Pro Home
      • Moz Local
      • Moz Local Home
      • STAT
      • Moz API
      • Moz API Home
      • Compare SEO Products
      • Moz Data
    • Free SEO Tools
      • Domain Analysis
      • Keyword Explorer
      • Link Explorer
      • Competitive Research
      • MozBar
      • More Free SEO Tools
    • Learn SEO
      • Beginner's Guide to SEO
      • SEO Learning Center
      • Moz Academy
      • SEO Q&A
      • Webinars, Whitepapers, & Guides
    • Blog
    • Why Moz
      • Agency Solutions
      • Enterprise Solutions
      • Small Business Solutions
      • Case Studies
      • The Moz Story
      • New Releases
    • Log in
    • Log out
    • Products
      • Moz Pro

        Your all-in-one suite of SEO essentials.

      • Moz Local

        Raise your local SEO visibility with complete local SEO management.

      • STAT

        SERP tracking and analytics for enterprise SEO experts.

      • Moz API

        Power your SEO with our index of over 44 trillion links.

      • Compare SEO Products

        See which Moz SEO solution best meets your business needs.

      • Moz Data

        Power your SEO strategy & AI models with custom data solutions.

      NEW Keyword Suggestions by Topic
      Moz Pro

      NEW Keyword Suggestions by Topic

      Learn more
    • Free SEO Tools
      • Domain Analysis

        Get top competitive SEO metrics like DA, top pages and more.

      • Keyword Explorer

        Find traffic-driving keywords with our 1.25 billion+ keyword index.

      • Link Explorer

        Explore over 40 trillion links for powerful backlink data.

      • Competitive Research

        Uncover valuable insights on your organic search competitors.

      • MozBar

        See top SEO metrics for free as you browse the web.

      • More Free SEO Tools

        Explore all the free SEO tools Moz has to offer.

      What is your Brand Authority?
      Moz

      What is your Brand Authority?

      Check yours now
    • Learn SEO
      • Beginner's Guide to SEO

        The #1 most popular introduction to SEO, trusted by millions.

      • SEO Learning Center

        Broaden your knowledge with SEO resources for all skill levels.

      • On-Demand Webinars

        Learn modern SEO best practices from industry experts.

      • How-To Guides

        Step-by-step guides to search success from the authority on SEO.

      • Moz Academy

        Upskill and get certified with on-demand courses & certifications.

      • SEO Q&A

        Insights & discussions from an SEO community of 500,000+.

      Unlock flexible pricing & new endpoints
      Moz API

      Unlock flexible pricing & new endpoints

      Find your plan
    • Blog
    • Why Moz
      • Small Business Solutions

        Uncover insights to make smarter marketing decisions in less time.

      • Agency Solutions

        Earn & keep valuable clients with unparalleled data & insights.

      • Enterprise Solutions

        Gain a competitive edge in the ever-changing world of search.

      • The Moz Story

        Moz was the first & remains the most trusted SEO company.

      • Case Studies

        Explore how Moz drives ROI with a proven track record of success.

      • New Releases

        Get the scoop on the latest and greatest from Moz.

      Surface actionable competitive intel
      New Feature

      Surface actionable competitive intel

      Learn More
    • Log in
      • Moz Pro
      • Moz Local
      • Moz Local Dashboard
      • Moz API
      • Moz API Dashboard
      • Moz Academy
    • Avatar
      • Moz Home
      • Notifications
      • Account & Billing
      • Manage Users
      • Community Profile
      • My Q&A
      • My Videos
      • Log Out

    The Moz Q&A Forum

    • Forum
    • Questions
    • Users
    • Ask the Community

    Welcome to the Q&A Forum

    Browse the forum for helpful insights and fresh discussions about all things SEO.

    1. Home
    2. Digital Marketing
    3. Paid Search Marketing
    4. Does anyone know of an excel template for creating keyword combinations?

    Moz Q&A is closed.

    After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.

    Does anyone know of an excel template for creating keyword combinations?

    Paid Search Marketing
    3
    5
    4237
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as question
    Log in to reply
    This topic has been deleted. Only users with question management privileges can see it.
    • eli-hgm
      eli-hgm last edited by

      I am looking for an Excel template with Macros that would allow me to drop a column of keywords next to a column of modifiers and it would build out thousands of keywords with a Macro. Can anyone drop their best SEO/SEM Excel template spreadsheet links in the comments?

      1 Reply Last reply Reply Quote 0
      • DavidKonigsberg
        DavidKonigsberg last edited by

        does this help you? http://textmechanic.com/Permutation-Generator.html

        1 Reply Last reply Reply Quote 1
        • TimKelsey
          TimKelsey @eli-hgm last edited by

          Hmmm, that's a bit more complicated. I'm sure there's a Macro out there that can do it, but I don't know one off the top of my head.

          I think this can be done without a Macro but it will take a little bit of manual work. Here's what I would do:

          Place your two sets of keywords in Columns A and B. Select all of Column B and cut (ctrl+x) it. Then in Cell B1, right click, select Paste Special > Transpose. Then, move Column A down one so the list starts in Cell A2.

          This will create a matrix with one set of keywords in Column A and the modifiers in Row 1.

          Next, in Cell B2, enter this formula:

          =$A2&" "&B$1

          Copy this across all cells in the matrix and you'll have 10,000 unique keywords. You will then have to remove the formulas by copying the entire sheet, right clicking in Cell A1 and selecting Past Special > Values.

          Finally, you'll have to do some manual work of cutting and pasting all the separate columns into one long column of 10k keywords.

          I know this isn't exactly what you're looking for, but it's the best I can think of for know. I've updated that spreadsheet example to give you a better idea of what I mean - https://docs.google.com/spreadsheet/ccc?key=0AsNfzI57aVSXdGFKME1pamRnZkJNandZWVpoVkFXZkE

          Or, if you want to send your initial set of keywords to me, I wouldn't mind giving it a shot myself. Feel free to send it to tim@prontomarketing.com.

          Best,

          Tim

          1 Reply Last reply Reply Quote 0
          • eli-hgm
            eli-hgm @TimKelsey last edited by

            Hi Tim,

            Thanks so much for your response. To be more clear, I would have a row of 100 keywords in column A, and 100 keywords in column B. I would like each of the 100 keywords in column A to be combined with each of the keywords in column B giving me 10,000 keywords.

            TimKelsey 1 Reply Last reply Reply Quote 0
            • TimKelsey
              TimKelsey last edited by

              If I'm correctly understanding your goal here, I think this can be accomplished by just using an Excel formula. You shouldn't need a Macro to combine two columns.

              Place your keywords in Column A and the modifiers in Column B. Then, in Column C, enter the following formula:

              =A1&" "&B1

              Copy this formula down the list and it will combine the contents of the two cells separated by a space. Here's an example I put together in Google Docs: https://docs.google.com/spreadsheet/ccc?key=0AsNfzI57aVSXdGFKME1pamRnZkJNandZWVpoVkFXZkE

              Hope this helps!

              Tim

              eli-hgm 1 Reply Last reply Reply Quote 0
              • 1 / 1
              • First post
                Last post

              Got a burning SEO question?

              Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.


              Start my free trial


              Browse Questions

              Explore more categories

              • Moz Tools

                Chat with the community about the Moz tools.

              • SEO Tactics

                Discuss the SEO process with fellow marketers

              • Community

                Discuss industry events, jobs, and news!

              • Digital Marketing

                Chat about tactics outside of SEO

              • Research & Trends

                Dive into research and trends in the search industry.

              • Support

                Connect on product support and feature requests.

              • See all categories

              Related Questions

              • Vallerinspects

                Keyword & negative keyword overlap

                negitive keywords google paid ads

                So I just read your blog on quality score and after reading the negative keyword section I'm a little confused and I need clarification. In that paragraph you mentioned about not overlapping your negative keywords with your active keywords and you used an example of dog food and dog bed. So my question is, if you put the word dog bed into the negative keyword list isn't the word dog the over lap word? Would you ad not show because the word dog is in the active keyword list?

                Paid Search Marketing | | Vallerinspects
                0
              • Fubra

                PPC: how to get rid of an ad appearing on a keyword we don't want?

                Hi, Our ad on Google Ads is appearing for a search we don't want. it isn't in our search keywords and when i try and ad it to our negative ones, we get the error " You cannot exclude keywords that are targeted " which i assume means that google thinks we are bidding on it? We have a selection of broad phrase matches so i can only think that this is where it's coming from? Do you have any tips on tracking down which keyword is generating this ad and how we can turn it off? (we don't want to pay for clicks on this search if possible!) Btw - i have turned off each keyword in turn to test it = nothing. have then paused the whole campaign = gets rid of the ad (but this is our most successful campaign so i can't just turn it off). Any advice super super welcome. thank you!

                Paid Search Marketing | | Fubra
                1
              • singhmahendra

                How to Find Competitor PPC Keywords ?

                Can anyone suggest best way to find all PPC keywords of a competitor. Any tool recommendation ?

                Paid Search Marketing | | singhmahendra
                0
              • EcommerceSite

                Is there any reason to add the word "buy" to our Adwords keywords?

                Was having a discussion with someone so I am going to write this up as neutral as possible and let you guys decide. We have a large keyword list and they are all setup as phrase. Should we go back and add the word buy in front of all those keywords? Even though they are setup as phrase already. Example: "Widget" (as a phrase) Should we go back and add "Buy Widget" as a keyword?

                Paid Search Marketing | | EcommerceSite
                0
              • klkirby

                Keyword Domains for PPC

                I have a client who wants to buy a lot of long domains with keywords in them, for example, thesandiegopetstore.com (this is fictional) and then set up a PPC landing page for each. They think that when someone types in "san diego pet store" that their domain will be listed high and then they will get a lot of traffic. My concern is that they will own a lot of domains for their company and I thought Google is getting pretty adamant about companies not having a lot of domains, and I thought that keyword domains are not as effective as they used to be -- that branding is more important now. Also, I think the domains they've picked target very competitive keywords and that perhaps they will get a lot unqualified traffic and will still have to pay for the clicks. What do you think? What is the best way to set up PPC landing pages?

                Paid Search Marketing | | klkirby
                0
              • tolik1

                Keyword tool for Yahoo ads?

                Hi guys, Anyone knows a good keywords tool for Yahoo Ads and Bing Advertising? - We are interested to see the search volumes for these 2 search engines (all tough they are together now, people still have searching preferences and usualy only use one of them. - We need to see global search volumes as well as geo-specific data (country level) Thanks in advance

                Paid Search Marketing | | tolik1
                0
              • europeandomaincentre

                How accurate is the Google´s keyword tool regarding monthly searches?

                How correct is Google´s keyword tool regarding the estimated number of Global Monthly Searches? Judging from my adwords campaigns the real number of impressions is 1/3 compared to the estimated number for an exact match. What is your experience?

                Paid Search Marketing | | europeandomaincentre
                0
              • SWKurt

                Does anybody know of a good bulk import http response checker? The one I was using has disappeared and I can only find checkers that only take one URL at a time.

                An example of something I'm looking for but I want to check multiple checkers: http://web-sniffer.net/

                Paid Search Marketing | | SWKurt
                0

              Get started with Moz Pro!

              Unlock the power of advanced SEO tools and data-driven insights.

              Start my free trial
              Products
              • Moz Pro
              • Moz Local
              • Moz API
              • Moz Data
              • STAT
              • Product Updates
              Moz Solutions
              • SMB Solutions
              • Agency Solutions
              • Enterprise Solutions
              Free SEO Tools
              • Domain Authority Checker
              • Link Explorer
              • Keyword Explorer
              • Competitive Research
              • Brand Authority Checker
              • MozBar Extension
              • MozCast
              Resources
              • Blog
              • SEO Learning Center
              • Help Hub
              • Beginner's Guide to SEO
              • How-to Guides
              • Moz Academy
              • API Docs
              About Moz
              • About
              • Team
              • Careers
              • Contact
              Why Moz
              • Case Studies
              • Testimonials
              Get Involved
              • Become an Affiliate
              • MozCon
              • Webinars
              • Practical Marketer Series
              • MozPod
              Connect with us

              Contact the Help team

              Join our newsletter
              Moz logo
              © 2021 - 2025 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.
              • Accessibility
              • Terms of Use
              • Privacy

              Looks like your connection to Moz was lost, please wait while we try to reconnect.