Want to know an easy and free way of merging multiple CSV files on your MacBook Pro or other Apple laptop? I’ll also show you how to split huge CSV files into smaller chunks or files for easy upload to a database etc.
A few weeks ago I found myself in a challenging situation where I had 254 CSV files that I had to merge into one CSV to make it easy to upload to my email marketing platform. It would have been a huge pain in the rear end to upload all 254 CSV files separately.
There are a number of paid software solutions that allow you to easily merge bulk CSV files into one, but I didn’t want to go that route, especially after knowing how easy it is to do it now for free!
I took some time to browse around to a number of websites, blogs and videos to piece together the video tutorial I did today for you. This video tutorial below will walk you through 4 easy steps to merge hundreds of CSV files, or more if you have them, into one CSV file.
Let me know how it works for you in the comment section below along with any tips you have to offer or questions!
Video Tutorial On How To Merge Multiple CSV Files Into One
How to Split Big CSV Files on a Mac for Free
I had a client project involving cleaning a 100 MB CSV file of data to import into a database. I needed to chunk up that 100 MB file into 5 MB smaller files to do this. So if this is the same challenge you’re facing here are the 2 command lines to enter into your mac terminal to split huge csv files into smaller files:
Split large file into 1 MB files: split -b 1m HO1M.csv
Add CSV to the end of each file: for i in *; do mv “$i” “$i.csv”;done