asked for text import when I tried to open

Ok tried to open my spread sheet application and got a pop up window asking for "Text Import’ and then asked to pick a selection from the “Character Set” with a bunch of options. So why did this happen, what do I pick and how to prevent in future?
Any help would be appreciated.

Are you using the csv file type?