I have a keyword map in microsoft excel that has a column A that includes urls and a column be that includes any number of anchor text / keywords associated the the corresponding url. I'd like a piece of software that will take my excel files and auto generate every possible combination of urls and keywords to create resouce boxes for article marketing purposes.
The resource box format I use is:
Bryan Smythe has expert knowledge of <a href="<[url removed, login to view]>">humidors</a> and is a business consultant for an online <a href="<[url removed, login to view]>smhumidors">cigar humidors</a> store.
The first link is always to the home page url but has varying anchor text. The second link goes to any number of sub pages with varying anchor texts.
So I'd like the software to pull the urls and anchor text from excel and auto fill the resoure box in a sort of mail merge fashion. However, I want to generate every possible combination of resource boxes based on this formula.
i would like the auto generated resource boxes to be generated in separate, single cell in column A? in excel.