Rename JPEGs in bulk?

[Max_Power]

I have a large number of JPEGs in a shared area, all the JPEGs file names are listed in column A of a spreadsheet. I want to be able to change the name of all the JEPGs to the contents of column B.

 

Tried via macros in Excel and a couple of scripts i found on the web, but cant get them to work correctly if at all.

 

Anyone ever done something similar with a piece of software (free if possible) or some other method?

 

Cheers

[Jawloms]

Can you insert a new column A, then put "ren" in column A, then do a column D which is column A & " " &column B&" "&column C, then copy column D, then paste values in to a new sheet and save it as a .bat file?

[DJ-1701]

I was just going to say, type this in C1 and drag down...

=CONCATENATE("ren ",A1," ",B1)

[nwkeene]

I once had to rename 25,000 TIF files... but found a utility called BRU (Bulk Rename Utility) which will rename loads of files and gives you options of pre pending names / numbers or adding names numbers at the end or in the middle of the file name...

 

a quick google (Bulk Rename Utility) does still list it... its free for personal / home use...

[Ditto]

We user IrfanView (free) for processing image files. I'm sure it could be used to purely rename, but if you wanted to resize the images or shrink the file size, it'll probably help with that too.

[jthompson]

I once had to rename 25,000 TIF files... but found a utility called BRU (Bulk Rename Utility) which will rename loads of files and gives you options of pre pending names / numbers or adding names numbers at the end or in the middle of the file name...

 

a quick google (Bulk Rename Utility) does still list it... its free for personal / home use...

 

I use Bulk Rename Utility quite a lot. You can import a text file (Actions -> Import Rename-Pairs...) containing file rename pairs (each line of the text file needs to be in the format

oldfilename.ext|newfilename.ext

). Once your list of filename pairs is loaded into BRU, you select the files in the file pane and you'll see the new names previewed. Then click the big rename button. You can browse to different folders and select the next set of files for renaming without having to reload your pairs file each time.

[howartp]

Can you insert a new column A, then put "ren" in column A, then do a column D which is column A & " " &column B&" "&column C, then copy column D, then paste values in to a new sheet and save it as a .bat file?

 

I was just going to say, type this in C1 and drag down...

=CONCATENATE("ren ",A1," ",B1)

This/these, but instead of saving as .bat - just copy the contents of the new column into a command prompt.

[Arthur]

I have a large number of JPEGs in a shared area, all the JPEGs file names are listed in column A of a spreadsheet. I want to be able to change the name of all the JPEGs to the contents of column B.

The following PowerShell script will work if your CSV just contains filenames (as shown in the screenshot below).

 

Set-Location 'D:\Images'

$csv = Import-Csv ".\Example.csv"

ForEach ($image in $csv){

 Try {
   Rename-Item $image.Old $image.New -ErrorAction Stop [color="#FF0000"]-WhatIf[/color]
 } Catch {
   Write-Warning $_.Exception.Message
 }

}

 

Note. Remove -WhatIf to actually rename the files.