The most common problem when opening CSV files is that when you double click on them they open up in Excel but look all mixed up. The way to do this the correct way is to instead create a new empy excel sheet and instead select File > Import and select CSV. After this select comma as the delimiter character and preview it so that you see that it splits the data correctly into columns and hit Finish.