While trying to find out how to get CSVs to open correctly in Excel on a Spanish PC (belonging to a customer) I found many answers recommending using
sep=, at the top of the file:
- Easiest way to open CSV with commas in Excel
- How to control CSV import into Excel 2010
- How to open semicolon delimited CSV-files in US-version of Excel
- Space or tabs as separator in CSV
- How to get Excel to interpret the comma as a default delimiter in CSV files?
On the face of it, this approach works but none of those answers give any further information on where this metadata option comes from. I have tried to search for what it means (and hence found all of those answers) but have been unable to get any further information especially given that punctuation is notoriously hard to search for.
My primary concern is whether or not this is an Excel-specific feature. I suspect it is but have found nothing definitive to confirm it.
Some related questions are:
- What characters can be used in this setting?
- What other settings are available (eg. line termination character, quote character, etc).
- Are there any other tools that officially support this feature?
I'm hoping there is a piece of documentation somewhere that someone can point me to that will answer all these questions and more; I just haven't been able to find it.
sep= is not a parameter to a parser. It is meant to be placed inside the CSV. Example:
sep=| "LETTER"|"ANIMAL" "a"|"aardvark" "b"|"bear" "c"|"cow"