Excel – Space or tabs as separator in CSV

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