CSVJ open standard addresses many common problems of CSV. It is basically a CSV where rows are encoded as a JSON.

Unfortunately it is not widely adopted yet and the language support is yet to be improved.