I was trying to solve this today.

Changing setting @query_result_separator to a tab enables Excel 2003 to read that on my computer.

If your target is another app, then you might need to use a different separator and/or convert your columns to e. g. to varchars and prepend and append double quotes (") to them.