I’ve needed to populate a site collection with many hundreds of sites in an automated fashion several times over the last couple of years. Every time the business owner gives me an Excel spreadsheet of the sites they want created. So rather than reinvent the wheel – again! – I’ve decided to start developing something reasonably generic and release it to my very first Codeplex project.

This first version is designed for a topology where each segment of the URL has its siblings in common. For example, Industry > Brand > Product or Division > Sector > Department. Depending on feedback I might make this more flexible.

Speaking of feedback, I’d really appreciate any comments from end users or other developers on desired features or comments on code WTFs! Please go to SPExcelator on Codeplex, download and add to the discussion!

Finally, special thanks to Robin Meuré for suggesting use of the excellent Excel Data Reader project.