Writing CSV is Resulting in Extra Quotes

I am executing a stored procedure that returns a Name column that contains a set of double quotes around the value (“Smith, John”). However, when I write this output to a CSV to be uploaded to a system, the values in that column have two extra sets of double quotes around the values (""“Smith, John”"").

Does anyone have idea why this happens or how to fix it? Thanks in advance.

The double quote is a special character in CSV used to surround text fields, usually only if the field contains a space:
“text 1”,“text 2”,“text 3” => values text 1, text 2, text 3

In case the text field itself contains a doublequote it is “escaped” by another doblequote:
“text”“1”,“text”“2”,“text”“3” => values text"1, text"2, text"3

In case the text field itself is surrounder by doublequote it is “escaped” also resulting in 3 doublequotes :
“”“text1"”",""“text2"”",""“text3"”" => values “text1”, “text2”, “text3”

Cheers