How to split large CSV files in Mac OS X Terminal, the easy way. And add an extension to them also, so Mac OS X knows how to handle them.
May 01, 2019. The file size of the latest setup package available is 760 KB. This PC software was developed to work on Windows XP, Windows 7 or Windows 8 and can function on 32-bit systems. This software is a product of MegSoft. CSV Splitter && Merger can also be called 'CSV Splitter Merger'. The most popular version among the program users is 1.0. Convert Mac vCard to CSV, PST, PDF, MSG, HTML, TXT, VCF; Allow to convert multiple no of emails and contacts; Option to split single VCF file into multiple individual VCF files; Proficient to convert images from VCF file to other file formats; Capable to export all vCard file contacts into a single PDF file; Ability to upgrade old vCard version (vCard2.1) to newer one (vCard4.0). Apr 25, 2013. Download CSV Split 1.1 for Mac from our website for free. The actual developer of this free Mac application is petRock Software. The program lies within Productivity Tools, more precisely Office Tools. Our built-in antivirus checked this Mac download and rated it as virus free.
How to split a large text file into parts of your choosing:
- by line number;
- or by file size (Kb or Mb);
- and add a '.csv' extension to all splitted files
First example: auto split a single CSV file into multiple files of 200 lines each
Let's say I have one .csv-file that I want to split into multiple files that contain a maximum of 200 lines. I can use the following command:
Where split_me.csv is the filename of the CSV file you wish to split into chunks of 200 lines. The split function itself is smart enough to give the new files a name, so no need to worry about that.
For many cases this alone is enough. But if you want some additional options, read on.
Example 2: split into files of 1MB each, and add a '.csv' extension to all of them
Let's make it more interesting:
- I want to split a file of 6.4MB into files of 1MB each,
- and I want each resulting file to also have the
.csvextension.
For that, we need to alter the split command a little bit.
First we used the -l flag, which separated the files by a number of lines. Now we're going to use the -b flag, which separates by size (bytes). Splitting it in files of 1MB is easy, just use 1m.
And additionally, we'll use a little loop and the mv-command to change the extensions.
First: split into chunks of 1mb each:
And next, add the .csv extension to all of them:
Et voila! We can see the result:
Word of warning
You should know this, but just to make sure.
- Open the Terminal in the right folder.
- If you add the extensions with the command I provided, it will do this for ALL files in the folder. So make sure that files you do not want changed are outside of it
- You can see in the image that all new files are 1Mb each (except the last one of course), and they have all gained an extra suffix / extension of
.csv
Csv Splitter Mac
What's next?
Csv File Download
If you think this was useful to you, it might be for others also. Feel free to share: