delimited text exported into one column - wanted in 6 columns

from a query result (in a process), i am exporting 6 columns of data to a
csv file but it comes out in 1 column with the data (thus aborting my
continued process). however my co-worker can run the exact same process and
he ends up with 6 columns of data and the process continues just fine. we
tried most everything, not sure if problem is with export from query result
or the csv excel like application.

what we do know is that my version of the file looks to be in unicode and i
have 2 characters at the front of my file while my co-workers does not.