Here in the “we work on computers” industry, we’re always dealing with CSVs – combining, cleaning, analyzing, crying in front of – you name it.
So, allow me make it just one micron less painful for you – by show you how to combine CSVs together in a matter of seconds.
Relax! I’m getting there..
Just kidding – i just needed to stuff that keyword phrase to pick up a couple more terms for SEO purposes.
But actually there’s a few ways to do it:
In this article (and video) I will show you how to quickly & easily combine and merge multiple CSV files into one CSV file for free on a mac using the terminal — but it also works on PCs.
If you run into any problems – we even created a free tool that you can try.
So follow along, and start combining!
Update: Back in the day I shot a video about how to do this manually on a mac, and it still works. But since then we’ve had a lot of people ask about doing it on a PC.
So we actually just made a tool that combines CSVs for you.
And it’s way faster than the manual method.
And it’s free.
Here’s a link to the tool for all you lazies who don’t wanna read or watch a video: CSV Combiner Tool
Create a new folder on your Desktop & put all of your CSV files into the folder.
I will call mine “combine”.
It will look like this:
Caution: Everything in this folder will be combined.
The program “Terminal” is located in your “Applications” folder under “Utilities”
Open Terminal.
It will look like this:
This is a fancy name. Don’t worry about it, just follow the steps.
pwd
return
keypwd
pwd
means “print working directory”. It’s showing you what “directory” (aka folder) you are currently at on your operating system. Don’t worry about it. Just keep following along.
Set your “directory” to the folder you created that has your CSV files in it.
cd /Users/devin/Desktop/combine
<== obviously replace “devin” with your name… unless your name is devin.return
keyNote: you will need to change your file path so it matches your username & folder name
Now you are ready to merge your files.
cat *.csv >combined.csv
return
key
If you followed along correctly, you are done!
Inside your folder there will be a file called “combined.csv”, which contains all of your csv files combined together.
Note: you might have to delete the duplicate header columns though.
Just apply a filter to your entire sheet, and sort A-Z on column A and you should see them.
If this was helpful, subscribe to the yt channel. i’m going to be making a lot more videos that will help you be more productive, faster on a computer, and make your life suck less
My name's Devin Schumacher.
Im widely recognized as the World's Best SEO & grumpy cat impersonator.
I like making stuff easier, so I make these SOPs.
And I figured, why not share them with all you funky folks?!
Also, I get an affiliate commission from Process Street if you find them valuable enough that you want to save them into your own account - which i hope you do!
I've been using this tool for 5+ years now... Pretty sure I was like their first customer ever.
It's not perfect, but it's helped me build & scale a multi-million dollar SEO agency that runs itself now.
And I have 1000s of SOPs I've built in here that I'm happy to share with you if you'd like, so...
Hope you enjoy!
Click here to sign up for Process.St
Want to get updates when as I release more free SOPs, checklists, workflows & productivity hacks?
Click here to stay in the loop via email
YouTube:
Reddit Groups:
Facebook Groups:
Instagram: @dvnschmchr
Twitter: @dvnschmchr
Facebook: @dvnschmchr
Linkedin: @devinschumacher
Tiktok: @dvnschmchr
Website: devinschumacher.com
Create a new folder on your Desktop & put all of your CSV files into the folder.
I will call mine “combine”.
It will look like this:
Caution: Everything in this folder will be combined.
The program “Terminal” is located in your “Applications” folder under “Utilities”
Open it.
It will look something like this:
This is a fancy name. Don’t worry about it, just follow the steps.
pwd
return
keyIt will look like this:
pwd
means “print working directory”.
It’s showing you what “directory” (aka folder) you are currently at on your operating system.
Don’t worry about it. Just keep following along.
Set your “directory” to the folder you created that has your CSV files in it.
cd /Users/devin/Desktop/combine
<== obviously replace “devin” with your name… unless your name is devin.return
keyNote: you will need to change your file path so it matches your username & folder name
Now you are ready to merge your files.
cat *.csv >combined.csv
return
key
It will look like this:
If you followed along correctly, you are done!
Inside your folder there will be a file called “combined.csv”, which contains all of your csv files combined together.
Note: you might have to delete the duplicate header columns though.
Just apply a filter to your entire sheet, and sort A-Z on column A and you should see them.
It will look like this:
Amazon™ pays commissions if I refer people to them, and that person buys something (anything) over the next 24 hours...
So if you click on one of the affiliate links below buy some crap you need/want - I'll get a commission from Amazon™ - you'll get a great excuse to buy that 'thing' you've been wanting!
You don't even need to buy the actual items linked here to support this channel...
You can just buy yourself something you've been wanting, or do your weekly shopping!
(i know you've been trying to squeeze that last little bit of toothpaste from the tube for like 3 months now... it's time for a new one)
Toothpaste: https://amzn.to/3iVK9oB
And that's what I call a win-win!
hi-five amigo!
Amazon Associates™ affiliate disclaimer: As an Amazon™ Associate, devinschumacher.com and/or its related web properties, earn from qualifying purchases. Read more here.