4 ms·

People who say that CSV is "simpler" are talking about whatever format Excel exports. Also these people have only ever had to deal with the American Excel loca

• cgio 2y ago
  Also keeping in mind all the locales where comma is the decimal point…tsv for the world.
  • matwood 2y ago
    And all the 'simple' formats start failing when dealing with blocks of text.
• mbnielsen 2y ago
  As someone living in a country where , is used as the decimal separator, I cannot begin to describe the number of times CSV data has caused me grief. This becomes especially common in an office environment where Excel is the de facto only data handling tool that most people can and will use. Here the behavior of loading data becomes specific to the individual machine and changes over time (e.g. when IT suddenly forces a reset of MS Office application languages to the local one). That said, I don't really know of any alternative that won't be handled even worse by my colleagues...