Did you try to change the extension manually to .xlxs and try to open using excel? what happened?
I agree everything is coming in single column
Yes, I tried it but it fails to save the data in proper format, I mean data being shown was without any deliminator.
It's like all the file data gets saved in a single row and column. Something like that.