Bulk File Change from CSV in MacOS

csvterminal

I'm trying to change about 50 file names using a CSV format. My CSV file is setup with Col A as Old Name and Col B as New Name. I'm running the following scripts in terminal:

I followed this guide: Renaming files/names in bulk, any smarter solution?

But it wasn't working for me. I kept getting the error:
mv: rename Screen Shot 2020-03-10 at 3.03.00 PM.png to Test 1.png: No such file or directory.

I was in the correct directory and the file was also in that directory, so I'm not sure why it couldn't find it.

Is there an alternative way of bulk renaming in MacOS?

Best Answer

Go to Finder and go to the directory with the file names you want to change, then select the files you want to change the name of. Then go to the gear icon in the top of the Finder window, or just right-click on the files you selected. There is a command to change x-number of file names. See the first image below.

When you click on the rename x items you get the following pane.

From here you can set up the new file names.

Related Solutions

How to open .CSV file with Microsoft Excel

Assuming you have a valid/consistent CSV file, create a new workbook and then choose File -> Import. The first option on the list is "CSV file":

enter image description here

Merging Multiple CSV Files without merging the header

You'll need more than the cat command, as described here:

Say you have 3 CSV-files: file1.csv, file2.csv, and file3.csv and want to join them to bigfile.csv and your header is always (only) the first line, then use

either (keep header from first file "file1.csv"):

cat file1.csv <(tail +2 file2.csv) <(tail +2 file3.csv) > bigfile.csv

or (remove header from all files who's names begin with "file"):

awk 'FNR > 1' file*.csv > bigfile.csv

Best Answer

Related Solutions

How to open .CSV file with Microsoft Excel

Merging Multiple CSV Files without merging the header

Related Question