Quantitative finance collector
C++ Matlab VBA/Excel Java Mathematica R/Splus Net Code Site Other
Aug 6

Excellent Free CSV Splitter

Posted by abiao at 16:19 | Code » VBA/Excel | Comments(7) | Reads(29520)
Share an excellent free CSV splitter I found recently, as my csv file is too large to be openned in Matlab & R, I have to split the csv into several smaller files. As far as I have tried, Matlab & R warn "short of memory" for reading csv file larger than 10,000,000 number of rows (it may be varied across computers), while my tick-by-tick corporate bond data has nearly 30,000,000 number of rows.

This CSV splitter allows you to split your large file into several smaller files either by number of lines or by max pieces,
Open in new window

The amazing point of it is the smaller files keep the original header of the big csv file, very cool. Download the free csv splitter here.

Tags: ,
csv splitter software is very useful
Many Thanks!!! Really helpful!
great little application.  thanks a ton!
deadlydave Email Homepage
I made an online that anyone can use for free...


Maybe you could include it in your post?
I made an online CSV splitter too!
thanks for the tip, running now, and the only tool that I've found that works under windows 32 for a file over 800Megs... Cheers!
I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well. armor games com
Pages: 1/1 First page 1 Final page
Add a comment
Enable HTML
Enable UBB
Enable Emots
Nickname   Password   Optional
Site URI   Email   [Register]