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

[eli-hgm]

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?

[DavidKonigsberg]

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

[TimKelsey]

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 [email protected].

Best,

Tim

[eli-hgm]

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]

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