In SEO we are always dealing with CSVs - combining, cleaning, analyzing - you name 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.
Follow along, and start combining!
If you have multiple CSV or Excel files that you need combined, follow this simple process to get them combined in a flash, using the built in "terminal" on your Mac.
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.
1. Type: "pwd" 2. Hit enter
It will look like this:
"PWD" means "Print Working Directory". It simply is showing you what "directory" (aka folder") the Terminal has selected. Don't worry about it. Just keep following along.
Set your "directory" to the folder you created that has your CSV files in it.
1. Type: "cd /Users/devin/Desktop/combine" 2. Hit enter
Note: you will need to change your file path so it matches your username & folder name
Now you are ready to merge your files.
1. Type: "cat *.csv >combined.csv" 2. Hit enter
It will look like this:
If you followed along correctly, you are done!
Inside your folder there will be a file called "combined.csv"
It will look like this:
If you need help with your digital marketing, web hosting, or other services please contact us.
