The max size of a CSV report in Heap varies based on where you download it. When you download a .csv file from the users view, it will export the most recent 5,000 users who fit the criteria of the query. When you download a .csv file from reports (graphs and funnels), the export will show up to 100,000 rows of data.