How can i split up my large .csv file?

I have a .csv file with 4 columns and about 3 million rows. When i open it up in excel, it will only show about the first 1,048,500 rows. Is there some way that i can take the subsequent rows that are not showing and place them in a separate sheet in the same excel file?

Answer 1

[dpb]

If you can read the file into Matlab, sure...just write the sections you wish

doc xlswrite

for details on the writing. If can't read the whole thing into Matlab, either, can always use the 'headerlines' option on textread or textscan or the [R,C} optional argument to csvread (altho I've never tested it w/ any huge size like this)