During the 90's I was anal for using them, pissing the hell out of my teammates and users for forcing them to use these 'standard compliant' files.
Had to give up.
As a co-op student I used a library to achieve fool proof encoding in csv so it escaped and quoted everything as necessary so commas,\, and quotes and any other character could be included in the data, but it was rejected since the plain text files were difficult to read and edit by hand!
The .usv separators make things easier to read at the expense of a bit more space.
Main point for me making the parsing so much simpler.
Who writes .csv files by hand anyway?
Easiest example is geo, I need 20 states listed as US-CO, US-CA, etc but one tool exported as US CO.