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.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1a6059f8-9db0-47e4-bd06-ae31f07e1076/Untitled.png

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

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/03b362d8-54fa-49e0-b0e0-94d63c92f1d4/Untitled.png

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.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/56f1d0b0-0e50-44b7-a238-71ac22277bba/Untitled.png

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.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/93bab646-582f-453b-9c68-69f91be9f53c/Untitled.png

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