Comment by Qem

  9. Excel hates CSV
  It clearly means CSV must be doing something right.

This is one area where LibreOffice Calc shines in comparison to Excel. Importing CSVs is much more convenient.