How can i split up my large .csv file?
2 views (last 30 days)
Show older comments
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?
0 Comments
Accepted Answer
dpb
on 8 Aug 2014
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)
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!