When you click the "Download It" button, the next time you login to your game, the creation will be downloaded into your game. You will find the creation in the in-game Sporepedia under the "Recent Downloads" category.