Create a List of Keyword Domain Names in Excel | DomainInvesting.com
Neustar Domain Names

Create a List of Keyword Domain Names in Excel

15

I’ve often searched for available keyword domain names in bulk using a keyword list and Microsoft Excel. I appended .com on to the end of the keyword string and then pasted it into a bulk domain checker at a domain registrar like Name.com.

Here’s how to turn a list of keywords into a list of domain names:

1) Paste keyword list into Excel workbook Column A
2) In Column B enter .com and copy it all the way down to the last row where you have something in Column A
3) In Column C, enter this function: =concatenate(A1,B1)
4) Copy cell C1 and paste all the way down to the last cell where you have keyword and .com
5) This may or may not be necessary depending on where you take the list, but since column C is still filled with functions, Copy all the cells in Column C and Paste Special as “Values”
6) Copy list in Column C and paste it in the Bulk domain checker


About The Author: Elliot Silver is an Internet entrepreneur and publisher of DomainInvesting.com. Elliot is also the founder and President of Top Notch Domains, LLC, a company that has sold seven figures worth of domain names in the last five years. Please read the DomainInvesting.com Terms of Use page for additional information about the publisher, website comment policy, disclosures, and conflicts of interest.


Reach out to Elliot: Twitter | | Facebook | Email

Comments (15)

    Mike

    And then they register the good names, which you ran through their WHOIS checker, before you can register them…

    November 29th, 2010 at 10:16 am

    Robbie

    Hey Elliot another system that I use is http://NameTumbler.com – It uses GD but you can use any registrar to run a bulk check.

    November 29th, 2010 at 3:07 pm

    Paul

    Much nicer to enter:

    =A1&”.com”

    into B1 then copy and paste it down (I don’t like the word concatenate :-))

    November 29th, 2010 at 3:27 pm

    Noon

    First I didn’t get it why you posted such an article but then I saw the referral link ­čśë

    November 29th, 2010 at 5:40 pm

      Elliot

      @ Noon

      Someone had asked about how to do it in private, so I posted it in public. The link is the same one as in the big banner on the top right. It’s a tracking link not referrals, and they are paying monthly not for signups, sales, or CPM.

      November 29th, 2010 at 5:42 pm

    jamesB

    @ Noon

    Yes he certainly is working every angle. But I guess you gotta pay the bills.

    November 29th, 2010 at 5:47 pm

      Elliot

      @ jamesb

      “working every angle”

      Don’t click the link if you don’t want. Don’t read my blog if you don’t want… nobody forcing you to do either. As mentioned before, I don’t make any more or less with that link…. and trust me, my blog isn’t paying my bills… selling domain names pays my bills.

      November 29th, 2010 at 5:49 pm

    Landon White

    @ Noon

    Yeah, So go get High-Noon er,

    i mean go hang yourself at High-Noon,

    Just kidding , of course! …

    November 29th, 2010 at 7:55 pm

    SL

    Elliot, it’s a badge of honor when your blog is popular enough to attract trolls and whiners. It means you’ve made it…

    So ignore them and keep up the good work!

    November 30th, 2010 at 9:49 am

    Elliot

    @ SL

    LOL… I think there have been trolls and whiners since day 1 :)

    I’m just glad people are comfortable enough with posting comments and their opinions here, without worrying that I won’t publish them or edit them.

    November 30th, 2010 at 9:51 am

    David

    @Robbie,
    When i consistently use nametumbler.com it stops giving me available domains saying i have done a serch of more than 500 when i have less searches done..Know anyhow i can fix this?

    December 5th, 2010 at 9:04 am

    mike

    How do you remove all the spaces in between the keywords?

    If list is …
    keyword1 keyword2

    concatenate will just give you keyword1 keyword2.com

    what is the command to remove space in-between keyword1 keyword2?

    Thanks.

    April 19th, 2011 at 12:25 am

    Elliot Silver

    Not sure, but you can then copy the new row and paste “values” which will then give you the actual keywords instead of just A1, B1. Once that’s done, highlight the row and do a find / change. In the row to be replaced, click the spacebar, and then click replace all, and the space will be removed.

    April 19th, 2011 at 8:22 am

    Howard Crosby

    (2013) The new link to name.com’s excel spreadsheet is https://www.name.com/manage/export/domains

    January 4th, 2013 at 12:53 am

    dncrew

    Thanks for the tip, but the bulk domain checker at name.com shows 404 error

    February 15th, 2014 at 3:57 am

Leave a Reply

Name *

Mail *

Website