SSIS is a no-brainer for doing stuff like this and is very straight forward (and this is just the kind of thing it is for).
- Right-click the database in SQL Management Studio
- Go to Tasks and then Export data, you’ll then see an easy to use wizard.
- Your database will be the source, you can enter your SQL query
- Choose Excel as the target
- Run it at end of wizard
If you wanted, you could save the SSIS package as well (there’s an option at the end of the wizard) so that you can do it on a schedule or something (and even open and modify to add more functionality if needed).