Note: I’m a beginner to Powershell and a bit more familiar with Bash (though still a beginner for that too).

*I have multiple PDF files and I want to rename each file based on a list of names found in an Excel/CSV (could be a text file if easier) file.

*The list begins at the A2 cell and the A1 cell has the header ‘name’.

*The files are in sequential order and match the order of the list of names.

Thanks for your help!

  • BobTheDestroyer@lemy.lolOP
    1·
    7 months ago

    Just figured it out! Added ‘.pdf’ in the second half of the command.

    $names = cat "\path\to\names.txt"; $i=0; dir | % { ren $_ "$($names[$i]).pdf"; $i++ }

    Thanks for all your help!