Here is the simple way to save query results as .csv or .xls  file using SqlServer Management Studio.

Execute your query

Example : Select * from AdventureWorks.Person.Address

Right Click on Left top corner

Select “Save Result As” to save as .csv file

OR

Select “Copy” and paste the result in an Excel sheet.