This article gives a method to extract all open projects into CSV format by using the Rally API
To get a CSV list of open project in Rally use the following link:
https://rally1.rallydev.com/slm/webservice/v2.0/project.csv?fetch=ObjectID,Name,CreationDate,Notes,Parent,Owner