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
And then they register the good names, which you ran through their WHOIS checker, before you can register them…
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.
Much nicer to enter:
=A1&”.com”
into B1 then copy and paste it down (I don’t like the word concatenate :-))
First I didn’t get it why you posted such an article but then I saw the referral link 😉
@ 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.
@ Noon
Yes he certainly is working every angle. But I guess you gotta pay the bills.
@ 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.
@ Noon
Yeah, So go get High-Noon er,
i mean go hang yourself at High-Noon,
Just kidding , of course! …
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!
@ 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.
@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?
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.
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.
(2013) The new link to name.com’s excel spreadsheet is https://www.name.com/manage/export/domains
Thanks for the tip, but the bulk domain checker at name.com shows 404 error