How to combine multiple CSV files

# **Step 1 – Create a new folder**

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:**

!https://s3-us-west-2.amazonaws.com/secure.notion-static.com/ba429c31-b53a-408f-945b-e93e2dadd079/Untitled.png

# **Step 2 – Open Terminal**

The program “Terminal” is located in your “Applications” folder under “Utilities”

# **Applications > Utilities > Terminal**

Open Terminal. It will look like this:

!https://s3-us-west-2.amazonaws.com/secure.notion-static.com/500b8335-54e2-45c8-aa21-5605c3301782/Untitled.png

# **Step 3 – Print Working Directory**

This is a fancy name. Don’t worry about it, just follow the steps.

Type: “pwd”

“`
pwd
“`

Hit enter

“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.

# **Step 4 – Choose the folder you created**

Set your “directory” to the folder you created that has your CSV files in it.

Type: “cd /Users/jake/Desktop/combine”

“`
cd /Users/jake/Desktop/combine
“`

Hit enter

# **Step 5 – Merge the files**

Now you are ready to merge your files.

Type: “cat *.csv >combined.csv”

“`
cat *.csv >combined.csv
“`

Hit enter

**It will look like this:**

!https://s3-us-west-2.amazonaws.com/secure.notion-static.com/8ea9608f-be5c-453e-95d8-aff66b21d7f9/Untitled.png

# **Step 6 – Check your folder**

If you followed along correctly, you are done!

Inside your folder there will be a file called “combined.csv”

**It will look like this:**