How to shuffle/randomize big (5M rows) .csv files?

[theorians]

Hi
I have a .csv file containing over 5 million rows. We need to randomize the rows and then split into pieces.
1048000 approx. rows are loaded in .csv and this huge file can't be open normally. Please help...

please help.

 

[sandy666]

try Power Query

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

docs.microsoft.com