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?

1 Answer 1


"sep=/t" for tab delimited

"sep= " for space delimited, should work

  • 1
    I actually never used ", so this did not seem to work for the space issue until i literally typed the quotes.
    – Madmenyo
    Sep 20, 2013 at 10:35
  • Is it a part of CSV standard or custom Excel thing? Jul 28, 2015 at 16:02
  • @BogdanGusiev I'm pretty sure this is part of the way excel processes csv files, but I've never found any documentation on it. see here Jul 28, 2015 at 16:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .