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:

{ 41 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.

TroyKGinns June 21, 2016 at 9:21 pm

Hi there, after reading this awesome article i am too delighted to share my know-how
here with mates.

safari baby shower invitations July 9, 2016 at 6:57 pm

This is the exact thing I did when I made "Oh, a few more minutes can’t want it to be underdone!" I ended up with medium rather than mid-rare but it was still Trust the 110 when you see it!

incline bench hammer curls July 14, 2016 at 2:41 pm

My suggestions would be to get your carbs in after your butt workout; it’s essential to replenish glucose levels in your muscle
tissue (glutes) and have a protein shake after your exercise.

Clark July 17, 2016 at 10:16 am

I am really enjoying the theme/design oof your
blog. Do you ever run into any web beowser compatibility issues?

A handful of my blog audience have complained about my site not operating correctly in Explorer but looks
great in Opera. Do you have any suggestions to
help fix this issue?

Wally July 17, 2016 at 1:54 pm

I feel this is among the such a lot vital info for me. And i’m happy reading your article.
However wanna statement on some general issues,
The web site taste is great, the articles is truly excellent : D.
Good activity, cheers

Bernard July 17, 2016 at 5:24 pm

It’s awesome to pay a quick visit this site and reading the views of
all colleagues regarding this paragraph, while I am also zealous of getting know-how.

fantasy pack July 17, 2016 at 7:56 pm

Nevertheless, the long term traits are not insignificant; they’ll not
necessarily help you though if you should be trading intraday.

bloomberg businessweek undergraduate business school rankings methodology July 17, 2016 at 10:13 pm

Forbes journal is just one of the best-known business publications around.

Elizabeth July 17, 2016 at 11:28 pm

The New York State Vendor Responsibility Program makes it possible for
business entities to enter and retain their Vendor Duty Questionnaire info in a safe, centralized database.

Venus July 18, 2016 at 9:58 am

We checked into the Motel Six for the night, a good
place to stay because the rooms are clean and the rates are reasonable.
The beautiful property is home to two signature courses, along with the hotel’s plethora
of accommodations, dining options, and recreational
facilities. While you are at it take the time to look into the
golf carts and the accessories that you will need while on the course.

https://www.youtube.com/channel/UC9c-xgyfOgpbr-O-x-cAT5w July 18, 2016 at 11:29 am

In it you will find a number of beautiful suites that will leave you
with a smile on your face as you experience all that can be
offered from a quality establishment. Use the Internet in order to look into different golfing vacation packages that are currently available.
They offer comfortable and cosy rooms in which the players can relax and if that is not enough, there are luxurious spas that help soothe their minds after a hard day’s play.

Ofelia July 26, 2016 at 9:47 pm

Simply a smiling visitant here to share the lovee (:
, btw great layout.

gsa seo tool July 27, 2016 at 1:05 am

This VPS/toolset is perfect for someone who isn’t a very
heavy person or who’s just wants to make use of instruments lightly and sporadically.

david andrews diabetes destroyer August 2, 2016 at 2:23 am

Loss of the operate of those cells compromises the physique’s skill to manage blood sugar and underlies the development of diabetes.

iherbs coupon August 4, 2016 at 3:02 am

each time i used to read smaller content which also
clear their motive, and that is also happening with
this article which I am reading at this place.

Myron August 7, 2016 at 9:17 pm

Excellent beat ! I wish to apprentice at the same time as you amend your web site, how could i subscribe for a blog
web site? The account aided me a applicable deal. I had been tiny bit acquainted of
this your broadcast provided vivid clear concept

ticket busters hours September 23, 2016 at 1:29 am

Kami dah beli tiket masuk sejak di Malaysia lagi pada harga Euro eight/pax di -tickets/.

Leave a Comment

{ 1 trackback }

Previous post:

Next post: