I've tried to export a list to a CSV file. I shut it down after about 20 minutes of processing. The list has 261,000 rows and 30 columns. I finally exported it to a txt file and its size was 111 ...
|Technology||Life / Arts||Culture / Recreation||Science||Other|