Export data (4million rows) from Webplayer but not able to read downloaded data in R or Python

I can right click and Export long data (4 million rows) as csv from Webplayer but not able to read it in R or Python. If I open it in a text editor like sublime, I see the data is actual Tab seprated. So I even tried reading it as tab separated in R but no luck.

As Excel has row limit, I cant open it in Excel and save as csv. I noticed the csv data shows Unicode (AllFormat) when I do save as. 

When I did save as .csv, I was able to read it in RStudio but it was chopped due to Excel's row limit. I tried looking up similar problem on Tibco Commuity and Stack Overflow but none of them were relevant as my case has large number of rows.


(1) Answer