How to Rename Files Using an Excel List on Mac

Here's a scenario that comes up constantly for designers, photographers, and anyone who manages files professionally: you have a folder of files with generic names like IMG_001.jpg, IMG_002.jpg, and so on. Somewhere else — in Excel, Google Sheets, or Numbers — you have a list of the names those files should have.

The naive solution is to rename each file manually, checking your spreadsheet for every single one. For 20 files that's annoying. For 200 files that's an afternoon of your life gone.

There's a much faster way. This tutorial covers exactly how to do it.

Why This Workflow Is So Common

The use cases are everywhere:

• Product photographers receive a shot list from a client with product names and SKUs. Photos come off the camera as IMG_xxxx. The goal is to rename the photos to match the client's product list in order.
• Designers export assets with generic names and have a naming convention list in a project spreadsheet.
• Archivists and librarians maintain catalog data in spreadsheets and need file names to match catalog entries.
• Real estate photographers shoot multiple properties in a day and need to match photos to property addresses from a schedule.
• Teachers and educators need to rename submitted assignments to match a class roster.

In all these cases, the names already exist somewhere — the problem is getting them onto the files without manual clicking.

The Manual Way (and Why It Breaks Down)

The obvious approach: open your spreadsheet on one side of the screen, open Finder on the other, and rename files one by one while reading from the sheet. This works, technically. But:

• It's extremely slow — each rename is 4–5 clicks and keystrokes
• It's error-prone — one slip and the rest of the list is offset by one
• Finder has no undo for batch renames
• It doesn't scale — acceptable for 10 files, miserable for 100+

The Right Way: Copy, Paste, Done

Fast Batch Renamer has an Excel integration feature specifically built for this. Here's the complete workflow:

Step 1 — Sort your files to match your list

Before loading files, make sure they're sorted in the same order as your spreadsheet list. In Finder, you can sort by name, date modified, date created, or size. The most common approach is to sort both your files and your spreadsheet by the same key — usually a number or date.

Step 2 — Load your files into Fast Batch Renamer

Drag your folder (or a selection of files) directly onto the Fast Batch Renamer window. All files appear in the list immediately, in the same sort order they were in when you selected them.

Step 3 — Copy your name column from the spreadsheet

In Excel, Google Sheets, or Apple Numbers:

1. Click the first name cell in your list
2. Shift-click the last name cell to select the entire column range
3. Press Cmd+C to copy

The clipboard now holds all your names, one per line.

Step 4 — Paste into Fast Batch Renamer

In Fast Batch Renamer, select the Paste from Excel mode and press Cmd+V (or click the Paste button). The app reads each line as a separate filename and maps them to your files in order.

The live preview updates instantly — you'll see your exact spreadsheet names paired with the corresponding files, complete with the original file extensions preserved automatically.

Step 5 — Review the preview and apply

Scan through the before/after list to make sure everything lines up. If you spot a mismatch — maybe one file was out of order — you can re-sort and re-paste before committing anything.

When you're satisfied, click Apply Rename. Every file is renamed in under a second.

What Happens to File Extensions?

Fast Batch Renamer preserves extensions automatically. If your spreadsheet names don't include extensions (e.g., you have "Beach Sunset" rather than "Beach Sunset.jpg"), the app keeps whatever extension the file already had. You don't need to include extensions in your spreadsheet — in fact, it's better if you don't, since different files in the same folder might have different extensions.

What If My List Has More Names Than Files (or Vice Versa)?

The app will only rename files that have a corresponding name in your list. If you have 50 files but 60 names, the last 10 names are ignored. If you have 60 files but 50 names, the last 10 files stay unchanged.

The preview makes this obvious before you apply anything.

Does This Work With Google Sheets?

Yes — Google Sheets copies cell content to the clipboard in plain text, just like Excel. The workflow is identical: select your name column, Cmd+C, switch to Fast Batch Renamer, paste. Google Sheets, Excel, Numbers, LibreOffice Calc — any spreadsheet app works.

Real-World Example

A product photographer shoots 180 items for an e-commerce client. Photos come off the camera as DSC_0001.jpg through DSC_0180.jpg. The client provides a spreadsheet with SKUs and product names:

• Row 1: "Blue Linen Shirt – SKU-4421"
• Row 2: "White Cotton Tee – SKU-4422"
• … and so on for 180 rows

Workflow: sort photos by shoot time → drag into Fast Batch Renamer → copy the name column from the client's spreadsheet → paste → preview confirms alignment → apply. Total time: about 45 seconds.

The alternative — renaming each file manually — would take 2–3 hours and introduce errors that are hard to catch later.