Argthtjtr

up vote 20 down vote favorite 9 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