When I used MS I didn't have problems opening the CSV's, however I feel like an idiot as when I open the file everything gets pushed into different columns.

I know this is user error but this has led to complaints from my prospects as I'm not getting back to them quickly! Can someone help me understand how to open my real estate leads from CSV and have it formatted properly? Before I would just open the file and it would work fine.
Thanks in advance.