How To Merge Multiple CSV Files on MacBook Pro for FREE! 

Holy Cow! After struggling for 2 hours while trying multiple solutions, your steps led to success in 3 minutes! Thank you soooooo much!

lifesaver! Thank You very much. I ran across a different video first with no audio and it just wasn't very helpful. Thanks for putting this together. worked like a dream!

Thanks, Trent! Your tutorial is clear and your method is effective. Keep up the good work!

PERFECT. Thanks. Learned more than I intended.

YOU ARE MY HERO! This is SUCH a timesaver!!! Your directions are clear and this worked PERFECTLY! THANK YOU SO MUCH!!!

SO HELPFUL --- thanks for posting this!

This was exactly what I needed. Thank you so much!!!

thanks so much-executed my 1st terminal (nervously) commands with your patient help. thanks from austin, texas!

AWESOMENESS! Mega props! Now I'm off to figure out how to use terminal for splitting csv. I'll come back and post answer when(if) I find it.

amazing!! worked perfectly! Thanks!

Thank you so much - you just saved me a lot of time!

Trent, thank you so much! Very useful video! Good luck to you!

Very useful! Thanks for posting!

YOU ARE A HEROOOOOO!!!!!!!!!!!!!! Thank you so much T_T. I really don't understand tech, and I was almost in tears trying to figure this out!! The written instructions make NO sense!!! Thank you, thank you, thank you!!! Hope you are safe and well during this crazy time!!! If you celebrate any winter holidays, happy holidays!! Will be wishing you well!!

Wow that makes it super simple! I'm not sure when I'd use it.... (hmm) but if/when I do thanks for the simple step by step!

Great job. cd means change directory. Thanks for your video!

Great video! Thank you so much for the tip.

This just saved me hours a painstaking tedious work - thank you so very much :)

That was very helpfull! Tnx Trent

Excellent ! Thanks for posting this, helped me out a lot :)

Hey Trent! Just wanted to say that you totally saved my life and I'm so grateful you also provided a cheat sheet too. Looking forward to sharing this online and linking to you. You rock! :)

Thanks so much! This saved me a TON of time! :)

Thanks so much for this super helpful.

Best video on the web!!!! Thank you!

Thanks, very helpful!

Thanks a million bro, you saved me several hours here.

You are the true hero bro, thank you so much.

Amazing. Thanks a lot!!!

Thank you so much! You are a life saver!

great video, thanks. FYI, you can combine step 2 and step 3 - there's no need to navigate to the desktop first. In fact, the easiest way would be to just drag the folder containing your files and drop it on the little grey rectangle after 'cd' in terminal. Terminal will automatically add the full file location

Thanks a lot! It's really a great help to me. More Power!

This is amazing, Trent! Thanks for making this vid!

I can’t believe this came out 7 years ago and is still super helpful you dk the pain of having a MacBook at trying to do data analysis

thank you! That was incredibly helpful. FYI, CD = Change Directory :-) I used to be a power DOS user in the dark ages. LOL! That was fast and easy. Appreciate you making this video.

Worked like a charm

Lifesaver thanks!

Could it be any easier! Thanks for providing this solution.

AWESOMEEEEEE THANKS BUDDY REALLY COOL STUFF

holy crap I LOVE YOU. Thank you so so much.

THANK YOU!!

Thanks! Very useful :)

THANKS, that solved it!

Magnificent, thankyou

thank you!!

Saved me hours, thank you If you had a thank button, I'd be buying you a coffee (add one)

Moreover it works also with VCF files. Thanks much. This was the easiet way to solve my problem. Real Hero :))

Still works!

Very helpful, thank you. What I discovered while doing this. You can right-click your folder and then choose "new terminal with folder" I don't know if I translated this correct but something like that should me there if you right click it. Then you have to type only the cat command :)

thanks!

Thank you your the best.. :-)

cool video.

AWESOME!!! Too bad email marketing softwares don't do this for you

Almost 3 years later still work

First of all, thank you very much for this description. However, a problem arises for me when using it. I have customer data in .csv files consisting of last name, first name, street, phone number, etc. The individual details are separated by a comma. The data is meant to be imported into Excel and I use the commas to map the columns there. After the last entry in each individual csv. File is of course no comma. If I use the method you mentioned to import several of the csv. files. Files together, the first entry of the second file is added after the last entry of the first file ... the first entry of the third file with the last entry of the second file, etc. Is there a command I can add in terminal that when merging the files a comma is added to the end of each file?

Champion

Great video! Don't see the cheat sheet with the code anymore...

Is there a way to do this that includes the title of each csv file?

Hi Trent... I try this and I get "no such directory' any advice? These are MSExcel files saved as CSV running Mojave. Thank you

Any way to do this with .xls files?

Trent, good video, but note "cd", is for "change directory" (from the school)...

cd stands for "change directory"

this is so fucking nice. i first followed another tutorial that teaches me to use python for file concatenation. it sucks. this one is awesome. thxxxxx bro

Mann take your like!

Hi, I can't seem to access the cheat sheet download. It nothing happens when I click the download link. Can you help? Many thanks!

ok

any idea why Im getting "-bash: cd: All: No such file or directory"

I have followed this simple tutorial but the file size is zero..

I get an empty merged file? What do I do wrong?

👍👍 Excellent! Thank you Trent... 👍👍