A few months ago I uploaded a little demo that let you import hosts into VirtualCenter using a spreadsheet. Well if there’s one constant in software it’s feature requests. A reader mentioned to me that this would be a lot more useful if he could import hosts directly into resource pools, clusters and things like that. Since it’s pretty easy to do in PowerShell (less than 50 lines in total) I updated the spreadsheet in hopes that other people could get some use out of this.

Here’s a preview of what it looks like:


One shortcoming of the spreadsheet is that if the host belonged to some other VirtualCenter, it will exist in that VirtualCenter as a disconnected host. It’s fairly easy to get rid of these though, if you connect to the old VirtualCenter using the VI Toolkit, then run

they will all be removed. Enjoy!