>>>I have a CSV file:
>>>
>>>

>>>Name,Given Name,Additional Name,
>>>1A Scott Stephens - Office,1A,Scott,Stephens - Office
>>>

>>>
>>>When I open it with Excel the data all appears in one column.
>>>
>>>What's wrong with this?
>>
>>Looks like there is one extra , at the end of the first line.
>
>That shouls have no effect on the way Excel opens the file

You're right, I created the file with these exact 2 lines and it opened an Excel file with 2 lines for me. Are you sure that each line is terminated with CRLF ?