It's an ad hoc text format that is often abused and a last-chance format for interchange. While heuristics can frequently work at determining the structure, the

It's an ad hoc text format that is often abused and a last-chance format for interchange. While heuristics can frequently work at determining the structure, they can just as easily frequently fail. This is especially true when dealing with dates and times or other locale-specific formats. Then, people outright abuse it by embedding arrays or other such nonsense. You can use CSV for interchange, but a duck db import script with the schema should accompany it.