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(6) | Reads(14454)
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: ,
ismayil_thappy
csv splitter software is very useful
Many Thanks!!! Really helpful!
flickerstalk
great little application.  thanks a ton!
deadlydave Email Homepage
I made an online that anyone can use for free...

http://www.promotional-products.org/automatic-online-csv-file-splitter.html

Maybe you could include it in your post?
I made an online CSV splitter too!
http://csvlivesplitter.com/
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!
Pages: 1/1 First page 1 Final page
Add a comment
Emots
Enable HTML
Enable UBB
Enable Emots
Hidden
Remember
Nickname   Password   Optional
Site URI   Email   [Register]