Rename from List: Rename Files from a Spreadsheet

Sometimes the new names already exist somewhere else: a shot list, a product catalog, a client spreadsheet. Batchio's Rename from List rule takes those names as they are. Paste them in, one per line, and every file gets its new name, with each change shown in the live preview first.

How do you rename files from a list in Batchio?

Add a Rename from List rule and paste your new names, one per line. Batchio gives the first name to the first file, the second name to the second file, and so on. The preview shows every pairing before anything is renamed.

This is the By order mode, and it is the fastest option when your files are already sorted the same way as your list. Use the sort control above the file list to put the files in the right order, for example by name or by date created, then paste the names. Lines that are empty are ignored, and extra spaces around a name are trimmed, so a column copied from a spreadsheet works as is.

If your list is shorter than your set of files, the remaining files simply keep their current names. Nothing is renamed by accident.

How do you match new names to the right files when the order differs?

Switch the match mode to By original name. You get two columns: current file names on the left and new names on the right. Each file is matched by its current name, so the order of your files no longer matters.

This mode is built for the classic spreadsheet setup with an old name column and a new name column. Copy the column of current names into the left field and the column of new names into the right field. Rows are paired line by line, and matching ignores upper and lower case. The current name can be written with or without its extension, so both IMG_0412 and IMG_0412.jpg find the same file.

Files that have no matching row are left untouched, which makes By original name safe to run on a large folder where only some files appear in your spreadsheet.

What happens to file extensions when you rename from a list?

Extensions are kept automatically. Write the new names without an extension and every file keeps its own .jpg, .pdf, or .mp4. If a line already includes the file's extension, Batchio removes it so the extension is never doubled.

Lists rarely agree on extensions. Some include them, some do not, and a single folder often mixes several file types. Because Batchio always handles the name and the extension separately, a mixed list still produces clean results. If you do want to change the extension itself, add an Extension Handling rule to the chain.

Can you combine Rename from List with other rules?

Yes. Rename from List is one of Batchio's composable rules. Stack it with other rules, for example a Numbering rule to add a sequence or a Date Insertion rule to add the shoot date after each new name.

Rules run in the order you set, so the names from your list can be refined further down the chain. Conflict detection catches duplicate names before anything is written to disk, and full undo restores every original name in one step if you change your mind. For a step by step walkthrough with a real spreadsheet, read our guide on how to rename files from a list on Mac.

Frequently Asked Questions

Can I rename files from an Excel or Numbers spreadsheet on Mac?
Yes. In Batchio, add a Rename from List rule and paste a column of new names straight from Excel, Numbers, or Google Sheets. Choose By order to assign the names top to bottom, or By original name to pair a column of current names with a column of new names.
Do I need to include the file extension in the list?
No. Leave the extension off the new names and Batchio keeps each file's real extension automatically. If a line does include the file's own extension, Batchio drops it so you never end up with a doubled extension like photo.jpg.jpg.
What happens to files that are not in the list?
They are left unchanged. In By original name mode, only files whose current name matches a row are renamed. In By order mode, files beyond the end of the list keep their names.
Is Rename from List free?
Yes. Rename from List is one of Batchio's 13 rule types, and all of them are included in the free version along with live preview and full undo.

Turn Any List into Filenames

Paste names from a spreadsheet and preview every rename before it happens. Batchio includes all 13 rule types free.

Download Batchio
Marcel Iseli
Marcel Iseli

Creator of Batchio · Indie App Developer

LinkedIn ↗

Marcel Iseli is an indie app developer and the creator of Batchio. He builds native macOS utilities focused on productivity and file management.