How to Rename Files from a List on Mac
You have a folder of files and a spreadsheet that says what each one should be called. macOS has no built in way to connect the two. This guide shows two methods that work: a short Terminal script, and Batchio's Rename from List rule with a live preview and undo.
Can you rename files from a list with Finder?
Finder is fine for simple patterns, and our guide to batch renaming files on Mac covers what it can do. Names that come from outside the files themselves, such as a product catalog, a shot list, or a client delivery sheet, are exactly where it stops.
How do you rename files from a CSV in Terminal?
mv.Open Terminal, move into the folder with cd, and run:
while IFS=, read -r old new; do
mv -n -- "$old" "${new%$'\r'}"
done < names.csvThe -n flag stops mv from overwriting a file that already has the new name, and the ${new%$'\r'} part removes the hidden line ending that Excel adds to every row. Both columns must include the file extension, and the CSV should have no header row. Names that contain commas will break the split, so this method suits simple names best.
The bigger limitation is safety. The script renames immediately, shows no preview, and has no undo. A typo in the spreadsheet is applied to your files before you see it. Our guide to renaming files in Terminal covers more command line options.
How do you rename files from a list in Batchio?
- Drag your files or folder into Batchio.
- Use the sort control above the file list so the files appear in the same order as your list, for example by name.
- Click Add Rule and choose Rename from List.
- Copy the column of new names from Excel, Numbers, or Google Sheets and paste it into the field.
- Check the preview, then click Rename.
You do not need extensions in the list. Each file keeps its own extension automatically, and if a line includes it anyway, Batchio drops the duplicate. Files beyond the end of your list keep their current names.
How do you match old and new names from two spreadsheet columns?
This is the reliable choice when your spreadsheet covers only some of the files, or when the files are not sorted the same way as the sheet. Matching ignores upper and lower case, and the current names can be written with or without their extension. Files without a matching row stay exactly as they are.
Because Rename from List is one of Batchio's composable rules, you can keep going after the list is applied, for example adding a number sequence or the date to every new name. If anything looks wrong after renaming, one undo restores all of the original names. The Rename from List feature page covers every option in detail.
Frequently Asked Questions
Can Finder rename files from a list?
How do I rename files from an Excel spreadsheet on Mac?
Do the files need to be in the same order as my list?
Can I undo a rename from a list?
Rename Files from Your Spreadsheet Safely
Paste your list, check every new name in the preview, and undo with one click. Batchio is free with all 13 rule types.
Download BatchioMarcel Iseli is an indie app developer and the creator of Batchio. He builds native macOS utilities focused on productivity and file management.