One of the handy feature of the Sql Server Management Studio is to export the data into csv file.
Please refer following steps in order to export your data to csv:
1. Execute your query
2. Write click on the result grid and click “Save Results As”
3. Save exported csv file.