3 ms·
A couple of extras: * CSV files will have consistent EOL markers * CSV files will always have a trailing EOL marker * CSV files will never have a trailing EO
by dspillett 9y ago
A couple of extras:
* CSV files will have consistent EOL markers
* CSV files will always have a trailing EOL marker
* CSV files will never have a trailing EOL marker
* Any file with a name ending .csv is a CSV file (or something close to)
> Excel can losslessly save CSVs it opens
A particular problem we've had many times with some clients is Excel messing around with date/time formats: files with dates formatted YYYY-MM-DD being changed to American style, columns containing both date and time having one or the other chopped off, dates being converted to numeric representations, ...