Creating your .csv file is the hard part. Once that's done, creating projects with it is a piece of cake.

Go to the Projects screen and click the Create from CSV button.

This popup will appear. Click Upload a file and upload your .csv file.

Next, you're asked to provide a name for your projects. Your projects will be given this name, followed by a numbered indicator. You can of course rename these later.

Finally, hit Create projects, wait a couple of seconds, and voila! Your projects are now generated! From here, you can use these like any other project.

Note: generating projects from a .csv is currently only possible for personal projects, not for team projects.