Never thought about it but comma seperated values can obviously be parsed backwards (reading the bytes of the file in reverse).

Also this article covers how csv files can be streamed line by line (row by row) minimizing ram consumption.