How to Rename PDF Files in Bulk Using Excel

The Excel Method: Columns, Formulas, and a Rename Command

The classic version looks like this. Open Excel and list every current filename in one column, exactly as it appears in the folder. In the next column, type or build the new name you want for each file. A formula such as =CONCAT("ren \"", A2, "\" \"", B2, "\"") turns those two columns into a ready-to-run command line for every row. Copy the whole result into a plain text file, save it with a .bat extension, and double-click it inside the same folder as your PDFs. Windows runs each line as a rename command, one after another, and the job is finished in seconds.

This is the workaround threads on Reddit, Microsoft's own Q&A forum, and a handful of Alteryx and Apple Discussions posts all land on when someone asks how to rename a pile of files using a spreadsheet list. It works. It's also entirely manual to set up, and it stays that way every time the folder changes.

Where This Method Breaks Down

The spreadsheet only knows what you type into it. Mistype a filename in column A, and that row's command fails silently, you won't notice until you check the folder afterward and find one file untouched. Formula errors are just as common. Miss a quotation mark inside the CONCAT string and the whole batch file can stop partway through, leaving some files renamed and others not, with no easy way to tell which is which without comparing folders by eye.

There's also no live preview built into any of this. You're writing new names for files you may not have actually opened, so the "new" name is only as accurate as whatever you already knew about that document going in. And every time a fresh PDF lands in the folder, you're back in Excel, typing another row by hand.

What Renamer.ai Reads From Each PDF Instead

Renamer.ai skips the spreadsheet step entirely. It reads what's on each page and builds the new filename from that, not from a list you maintained yourself.

There's no column to fill in and no formula to get right. You set the order those four fields appear in once, and every statement dropped in afterward lines up the same way, whether it came from one client or forty different ones.

Before and After: No Spreadsheet Required

Take a single client statement pulled from a folder of thirty, sitting there named:

No spreadsheet row identified this file. Renamer.ai pulled the client's name and the billing period straight from the page.

Every other statement from that batch got the same treatment, read on its own, with nothing typed into a spreadsheet column first.

Rename Other File Formats

See all our PDF renaming guides to browse every other PDF-specific tool renamer.ai offers.

Skip the Spreadsheet, Not the Renaming

Try renamer.ai instead of building another CONCAT formula. Drop your folder of statements in, let the AI read each one directly, and download them already renamed, no list to build and nothing to retype the next time a new statement lands.