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


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


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:

{ 20 comments… read them below or add one }

Shakeel Ahmed November 24, 2011 at 12:36 pm

Excellent Software.

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!

Adam October 15, 2014 at 12:35 pm

I was very pleased too uncover this page. I want to to thank youu
for oones time for this fantastic read!! I definitely enjoyed evedy little
bit of it and I have you saved as a favorite to ccheck out nnew stuff in yiur web site.

Shana October 19, 2014 at 4:48 am

Hurrah, that’s what I wwas seeking for, what a material!
present here at this weblog, thanks admin of this website.

publicize November 13, 2015 at 3:58 pm

A technician like a lighting designer, stage manager, sound designer, set designer
or choreographer also can get away with a lot more model and less vanilla structure.
The film headshot is trying to indicate a clean clean slate (tabula
rasa); the theatre headshot can present a bit of character and verve and edge.

c2257660720586234425 February 4, 2016 at 8:40 pm

Oh, and in contrast to the earlier recreation, Rock Band four would not support
the mini-keytar peripheral in any respect.

social studies quiz questions and answers February 13, 2016 at 9:52 am

Hello Janis – I feel it’s an attention-grabbing angle too, a fantastic piece of social historical past.

interiores minimalistas blog March 7, 2016 at 7:52 am

five hundredtwonuclear familyrevolting disgustingNoextended familytwo five hundredtworevolting disgustingdebemosrevolting
disgustingnuclear familyfive hundred twoextended familyrevolting
disgustingolvidarrevolting disgustingtwofive hundred five hundredextended familyrevolting disgustinglaextended familytwofive hundred reglarevolting disgustingnuclear familytwofive hundred fundamental five hundredtwoextended familyennuclear familytwofive hundred five hundredextended familyinterioresextended familyfive hundred five hundredtwonuclear familyminimalistasnuclear
familyfive hundred: five hundredtwodesecharnuclear
family twoextended familyrevolting disgustingtodorevolting disgustingnuclear family
nuclear familyaquelloextended familytwofive hundred twoextended familyinnecesariorevolting disgustingtwo five hundredtwoincómodorevolting disgustingnuclear familytwofive hundred yextended family twonuclear familyrevolting disgustingquerevolting disgusting twosaturerevolting disgustingnuclear familytwofive hundred five hundredtwonuclear familyrevolting disgustinglosextended familyfive hundred five hundredtwoespaciosrevolting disgustingnuclear
familyfive hundred.

reformas integrales zaragoza March 12, 2016 at 4:18 pm

twoEnextended familytwo five hundredtworevolting disgustingOrorevolting disgustingextended familytwo five hundredtworeformasrevolting disgustingextended familyfive hundred five hundredtwonuclear familyrevolting disgustingintegralesextended family, five hundredextended familyrevolting disgustingapostamosrevolting disgustingtwo
revolting disgustingporrevolting disgustingextended familyfive hundred nuclear familyrevolting disgustinglasextended familyfive
hundred five hundredtwonovedadesextended familytwo five hundredextended familyyrevolting disgustingnuclear family extended familylastwo five hundrednuclear familyrevolting disgustingintroducimosextended family five hundredtworevolting
disgustingalrevolting disgustingextended familytwo extended familyrevolting
disgustingmercadorevolting disgustingextended familytwofive hundred twonuclear familyconextended familytwofive hundred five hundredextended familyrevolting disgustingelrevolting
disgustingextended familytwo five hundredtwoextended familyrevolting disgustingpreciorevolting disgusting twomásrevolting disgustingnuclear
familytwo revolting disgustingadsequibleextended family five hundredparatwofive hundred five hundredextended familynuestros five hundredtwoclientesnuclear familytwo.

Pintor Cordoba September 11, 2018 at 4:08 pm

- Pintor de pisos en Cordoba. Profesional reformas.

instagram takipçi October 11, 2018 at 11:36 pm

Good way of telling, and pleasant post to get information on the
topic of my presentation focus, which i am going to deliver in academy.

kerkyraancona.wordpress.com October 21, 2018 at 7:55 am

Do you mind if I quote a few of your articles as long as I provide credit and sources bac to
your webpage? My blog site is in the very same niche aas yours and
my visitors would definitely benefit from a llot of the information you present
here. Pleas let me know if this alrigght with you. Thanks!

Essay-help-247.somee.com October 21, 2018 at 9:15 am

Visit this website for more information on sone excellent Sky Plus Offers.

Flowers appear in a variuety of colors, if you addd stems and vines, you may get a wonderful custom tattoo design. In this Shahrukh
Khan has played role just as the one played in Super

Stevie October 26, 2018 at 2:25 am

If you are going for finest contents like me, simply pay a visit
this web site every day for the reason that it provides
feature contents, thanks

greece ferry December 8, 2018 at 11:10 am

Norally I don’t read article on blogs, but I would like to
say that tis write-upvery forced mme to take a look at and do
so! Your writing taste has been surprised me. Thank you,
very great article.

Leave a Comment

Previous post:

Next post: