Export from SQL Server 2012 to .CSV through Management Studio
If it is the query results you want exported to csv, you can right click on the results grid and select "Save Results As", which will allow you to save as csv.
Right click on your database in management studio and choose Tasks -> Export Data...
Follow a wizard, and in destination part choose 'Flat File Destination'. Type your file name and choose your options.