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:

{ 24 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!

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.

vegetarian chili slow cooker December 6, 2015 at 11:16 am

Bear in mind, being vegetarian does not imply you get
free vary to eat as many excessive-carb snack foods as you need.
You still do undoubtedly need to be eating healthy
and making an effort to maintain a recent weight loss
program that accommodates entire grains, fruits, greens, and

violin covers of rock songs December 21, 2015 at 11:06 pm

Nevertheless, the extra I hear of this nice man’s music the extra I
appreciate it. Now we have two wonderful cycles of the seven symphonies (Naxos
& Chandos), the three piano concertos, the Requiem and lots of songs
and choral items. Charles Proctor isn’t included within the present edition of Grove’s Dictionary of Music nor
the British Music Society’s British Composer Profiles
(third version, 2012).

12 week body transformation female January 24, 2016 at 1:58 pm

Yet she still performed well enough to maintain her place at 8 beneath par, and with Choi going over par, Lydia ended
the day within the lead all by herself.

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.

uçak bileti rezervasyon iptali February 6, 2016 at 1:00 pm

Dubrovnik-Kotor arası, bilet aldığımız veznedekilerin 2 saat
sürüyor iddialarının aksine 3 saatten fazla sürdü.

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.

modern architects austin April 29, 2016 at 1:12 am

The fashionable city was strangled by a motorway that
divided residential areas and largely decrease social courses had been transferred to very
large developments on the sting of town or past.

reformas integrales zaragoza May 1, 2016 at 4:44 pm

Hi there all, here every person is sharing these kinds of know-how, so it’s nice to read this web site, and I used
to pay a visit this website every day.

apps for pc free May 7, 2016 at 2:50 am

When you find an app you need, tap or click Buy or Try (free trial) if it’s a paid app, or Install if it’s free.

week diet detox May 8, 2016 at 10:13 am

Now that you already know what to eat and what to drink it’s time to fill out your Detox Meal Plan This
might seem like an unnecessary step, nevertheless it’s an important
step to help you stay on track.

rap music download sites May 17, 2016 at 10:15 pm

They may be able to work with native radio and tv stations and report labels-particularly those started and owned by
African-Americans, similar to Def Jam and Bad Boy-to
supply opportunities for internships, excursions, and job
shadow days that give youth experience in the music trade.

Leave a Comment

Previous post:

Next post: