Simple Way to Rename File Using Excel

I often have the need to modify a large amount of filenames, and I have often found it easiest to turn to Excel and a simple bash script.

Combine this formula with a sequence number and you have a very easy way to rename a massive amount of files and keep the filenames unique.

 =concatenate("cp ",char(34),A1,char(34)," ",char(34),"renamed/", B1,char(34))

cp "oldfilename" "renamed/newfilename" 

  1. Drag that formula down the entire column.
  2. Copy the column to a text editor and save as rename.sh. 
  3. Open a terminal/console and change to the directory containing the files you wish to rename.
  4. If you haven't made a directory called renamed, type mkdir renamed. 
  5. Run bash rename.sh