Home > Softwares > How to Split CSV File into Multiple Parts Easily and Quickly

How to Split CSV File into Multiple Parts Easily and Quickly

by Shivaranjan on November 6, 2008

ADVERTISEMENTS

At my work place I have to many times work with large CSV files. The problem is that Microsoft Excel 2003 cannot handle a file that contains data more than 65,536 rows in a column and most of the time I end up working with CSV file that has got data more than 65,536 rows.

In these cases, I open the CSV file in notepad and copy the data less than 65,536 rows and paste into another file and this way I used to split up the CSV file. The problem with this method is takes some time get this done and doing this when the number of rows are greater than 500,000 becomes a real pain.

On Googling around I found that there is free tool called CSV Splitter, that can do this quickly with out me having to do all the work. Happy

csv_file_splitter

The CSV Splitter can split the files based on two parameters,  first is based on the number of lines specified and second is based on number of files that you intend to split of the original CSV file. I prefer to use the number of lines feature so that I can split the CSV file with less than 65,536 lines of data so that it can be opened in Microsoft Excel 2003 for further processing.

To split CSV file just point the location of the CSV file and enter the parameter that you intend to use for splitting up the file and hit the “Split Now” button, the tool will split the CSV files into multiple CSV files.

Another feature worth to note here is that this utility does not touch the original file rather it creates new set of CSV files based on the selections that was made. Also there is no need to install this as it can be run directly so makes lot of sense to carry it portable drive if you are working with CSV files frequently.

We tested this software in Windows XP and Windows Vista.

Download CSV Splitter (Direct Download) Home Page

Did you enjoy this article? Please subscribe to RSS Feed to receive all the updates!

Related Posts:

{ 8 comments… read them below or add one }

Shakeel Ahmed November 24, 2011 at 12:36 pm

Excellent Software.

thomy March 5, 2013 at 3:05 am

It’s the best solution for my 1GB csv file +- 2.700.000 lines
Tested in WINDOWS 8, just some mallware issues by the scanner.. but i think its just because this software is a little bit old.
So conclusion it worked out for me, and better than gsplit3

anonymouse April 21, 2013 at 3:42 pm

Great tool, thanks!

Baljit Singh August 19, 2013 at 8:50 am

Great tool.

Thanks mate.

Kristin September 13, 2013 at 3:27 am

This is EXACTLY what I needed. I have a massive (8gb) .csv that is essentially useless in its current state. Thanks for the post!

buy instagram followers with itunes card February 2, 2014 at 11:47 pm

Wow, marvelous weblog format! How long have you ever been
running a blog for? you made blogging glance easy.
Thee wjole glance of your web site is magnificent,as neatly as
the content material!

How to open csv Share a file in excel 2010 June 3, 2014 at 1:16 am

Hi, I do believe this is a great web site. I stumbledupon it ;
) I am going to come back once again since i have book-marked it.

Money and freedom is the best way to change, may you be rich and
continue to guide others.

best wordpress premium themes September 23, 2014 at 1:30 pm

My spouse and I absolutely love your blog and find almost all off
your post’s to bee exacyly wwhat I’m looking for.

Does one offer guest writers to write content for yourself?

I wouldn’t mind publishing a post or elaborating on a number of the subjects yoou write
regarding here. Again, awesome weblog!

Leave a Comment

Previous post:

Next post: