There are many ways to open csv file in excel i.e Import export wizard etc.
Here is a simple ways which i generally use a lot
Open your csv file in notepad and tell the seperator type i.e
This will tell Excel how to read csv file with seperator ..
Thats it !!!