Monday, August 25, 2014

Split huge CSV files into serveral files using CSV splitter




When you have a huge CSV file to import to PHPMyAdmin, you will get a message file too large.
You can use CSV splitter to split the huge CSV file into several small size files:
CSV splitter can be downloaded from:
http://www.freedownloadsplace.com/CSV-Splitter-Download-41523.htm
After you extract the compressed file, you will getCSVSplitter.exe.
Run the exe file, the description of input:
CSV file: the path to the CSV that you wanted to split.
Number of lines: the maximum number of lines/rows in each splitted piece.
Max Pieces: limit the number of output files. 0 means unlimited.

The output files will be under a new folder in the same directory of parent file, folder name is parent file add _Pieces.
Note:
Note: the first line of parent file  is treated as title and  will appear  in all child files.
remove unnecessary ones according to your need.

No comments:

Post a Comment