Anxingji ToolsEVERYDAY TOOLS

How to batch rename files with an Excel name list

Anxingji Tools · Published 2026-11-17 · Updated 2026-11-17

Use two Excel columns to match each old file name to its new name. In Batch file renamer, select the files, import the workbook, check the preview and download the renamed copies in a ZIP.

Open Batch file renamer →

Preview the name mapping before downloading. ZIP export requires sign-in and an active online pass.

Turn three draft names into invoice names

The fictional practice bundle includes three text files and name-map.xlsx. The workbook contains Old name and New name columns.

Download the files and Excel name map · Compare the renamed ZIP

Old nameNew name
draft-a.txtinvoice-001.txt
draft-b.txtinvoice-002.txt
draft-c.txtinvoice-003.txt

Import the workbook and select its two columns

  1. Unzip the bundle. Select only the three draft text files in the renamer.
  2. Choose the Excel name-list option and import name-map.xlsx. Select its Names worksheet.
  3. Pair Old name with the original file-name field and New name with the destination-name field.
  4. Check all three preview rows, including their .txt extensions. Download the renamed copies as a ZIP.

The originals remain under their old names. Unzip the downloaded result into a separate folder before comparing it.

Resolve missing matches and duplicate destinations in the preview

Original names must match the selected files, including extensions. If a row does not match, check spelling, spaces and whether you selected the correct file.

When two new names are the same, check the tool's conflict handling and the final preview. Give each file a distinct intended name in Excel if the automatically resolved name would be unsuitable. File-name restrictions still apply.

Check the names and contents after unzipping

The example result should contain invoice-001.txt, invoice-002.txt and invoice-003.txt. Open each file to confirm its content still identifies the matching draft. A correct file count alone cannot show that the right names were paired.

If you first need an inventory, use the folder-to-Excel exercise. Use File checklist when the task is checking expected submissions.