Combining .csv Files

Can .csv files be combined (merged) into a single file on a macbook pro with Sonoma 14.2.1? If so, where can I find the instructions? I am not a techie, so I cannot write code if that is what is required.


MacBook Pro (2017 – 2020)

Posted on Mar 10, 2024 12:57 PM

Reply
1 reply

Mar 10, 2024 1:33 PM in response to JKD2

If no headers, same delimiters, and equal data columns, you can append them in the Terminal. If you have two .csv files (e.g. name1.csv, name2.csv) meeting those conditions — then:


cd ~/Desktop

cat {name1,name2}.csv >> merged.csv


But, if they are different you will need to open them in a spreadsheet application and fix what is different in the first sentence above, and then export as a differently named CSV.



This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Combining .csv Files

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.