Friday 8 February 2019

How to force Excel to open CSV files with data arranged in columns


I generate a CSV file with an extension .csv in which every piece of data in one line is separated with a comma:


1,2,3,4
1,2,3,4

The file is sent via email and I want that when a customer opens it she sees data arranged into columns.


Is such thing possible?


PS: I may freely change the delimeter.



Answer



Use tab instead of comma. And if that doesn't work, give your tab-delimited file an xls extension.


No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...