I usually put "sep=," or "sep=;" as first line on my csv files so i can easily open them with excel. But is there a way to use this with space and tab separated files?
Excel – Space or tabs as separator in CSV
csvmicrosoft excel
csvmicrosoft excel
I usually put "sep=," or "sep=;" as first line on my csv files so i can easily open them with excel. But is there a way to use this with space and tab separated files?
Best Answer
"sep=/t"for tab delimited"sep= "for space delimited, should work