I just tried something with one of my spreadsheets......

Saved the file as a text.csv

then opened it, but as it's a txt.csv you get to make a few selections as to how the data should be imported, you can select an option and it will show you a small preview of what the data will look like. All my data ended up in A1, A2, A3 etc

This is using Excel 2007