Skip to main content

Easily Split Large CSV Files Into Smaller Parts While Retaining Column Headers

Easily Split Large CSV Files Into Smaller Parts While Retaining Column Headers

April 26, 2013 at 06:30PM

Data-crunchers, your attention, please. As you’re all too aware, reviewing copious amounts of data is tedious work, especially when you’re stuck with repetitive, tabular data, like mile-long contacts lists or financial records, preserved in a CSV file. Well, if you can find someone to help you pour over all that data, you can now easily split those long lists into as many segments as you like, and divide your workload between co-workers, with the quick & nimble CSV Splitter.

One of CSV Splitter’s strengths is its simplicity. It is more suited for users who’re easily flustered by the plethora of options some other applications of its kind might have. It opens to a single window with a few simple options.

CSV Splitter

To get started, click the browse button to the right of the “Filename” field, and select the CSV or TXT file you want to split into multiple smaller ones. I loaded up a list of all the countries in the world, which was categorized by column headers like serial number, common name, capital, sovereignty, currency, telephone code, etc., which is why I checked the “First row contains column header” box. This gives you the option to include the entire column header in each of the files the original CSV splits into by checking the the box below.

Enter the number of rows you want each file to have or calculate a value depending upon the number of resulting files you require. If your .csv has about 300 rows like mine did, and you put in “150”, you’ll get two new files with the index numbers “.000” and “.001” appended at the end of their filenames. Hit “Execute” when you’ve entered the required value.

The gray bar at the bottom shows the progress of the task by current “Row index”, “Elapsed time” and percentage “Completed”.

CSV Splitter can be used in conjunction with another application from the same developer. “Dataset to CSV” converts any SQL database you put in it into a comma-separated CSV file, which you can then, via CSV Splitter, split into bite-sized portions for easier consumption. You’ll have to download Dataset to CSV separately, though. Download links for both applications can be found on the page linked at the end of the article.

Testing was carried out on Windows 8 Pro. CSV Splitter is also available for Windows 7, Vista & XP.

Download CSV Splitter

Read Easily Split Large CSV Files Into Smaller Parts While Retaining Column Headers by on AddictiveTips - Tech tips to make you smarter



from AddictiveTips http://www.addictivetips.com/windows-tips/csv-splitter-for-windows/

Comments

Popular posts from this blog

Ten Apps you Must Download when you Buy A New Android Smartphone

Ten Apps you Must Download when you Buy A New Android Smartphone

May 14, 2013 at 11:21PM You have spent loads of time researching which is the best Android smartphone that fits your budget, spoken to people in the know about gadgets and have saved accordingly. After contemplating a fair bit if this is the right time to pick a device and there is no other device you would rather have, you take a plunge into the astonishing world of Android and pick that shiny new Android device. Right now it is sitting proudly in your hands as you admire every curve, every pixel, visible or not of your new Android smartphone.It is the time to load your Android smartphone, to make it truly yours, a device that would be with you through your thick and thin. Time to install those applications which will complete your world, if not complete, at least make your world a lot more organized and a lot more fun. So which apps do you start off with?Like the famous Nokia commercial goes, you have our back. Here …

How to Password Protect & Encrypt Files [Mac/Windows]

How to Password Protect & Encrypt Files [Mac/Windows]

May 16, 2013 at 06:33PM Nowadays, the computer has a very important place in everybody’s life, as a personal gadget used for a lot of different things. Everything is digital and it is stored on a computer’s hard-disk or on a cloud system, offering you easier access to your favorite data.Computers have become the place where you hold pictures, documents, favorite music and everything else in the same place. While storing may include regular data, random and even useless information, people may also keep important stuff, such as wedding photos, work documents, projects and others.Have you ever thought about protecting critical data with a password? Taking into consideration that all information could be vulnerable to hackers or to unauthorized persons, this is a rather obvious procedure. Another reason to encrypt data can appear in case somebody else also uses that computer and you don’t want them to have access to private pict…

Who Needs To Pirate Software With A Free Software List Like This!

Who Needs To Pirate Software With A Free Software List Like This!

May 03, 2013 at 05:30AM I found this interesting list at this random forum on Internet and I found it worth sharing. It is indeed a huge list of free available software that you can use instead of buying or pirating the expensive ones. The list goes as following:3D Graphics:3Delight Free – http://www.3delight.com/index.htm
Anim8or – http://www.anim8or.com/
Aqsis – http://www.aqsis.com/
Blender – http://www.blender3d.org/
Houdini (Free Edition) – http://www.sidefx.com/apprentice/index.html
Now3D – http://digilander.libero.it/giulios/Eng/homepage.htm
OpenFX – http://www.openfx.org
POV-Ray – http://www.povray.org/
SOFTIMAGE|XSI EXP – http://www.softimage.com/products/exp/v3/
Terragen – http://www.planetside.co.uk/terragen/
Toxic – http://www.toxicengine.org/
Wings 3D – http://www.wings3d.com/Anti-Virus:a-squared – http://www.emsisoft.com/en/software/free/
AntiVir – http://www.free-av.com/
Avast – http://www.…