Ever been in the situation where you need to rename a bunch of files without giving them then same name with a number extension? Ever needed to rename a long list of images so they're search engine friendly? Well if the answer is yes, then your in for a real treat. There's a quick and easy solution to renaming files using Microsoft Excel (or any other spreadsheet software) and the windows command prompt.
Trusted Mac download Quick File Renamer 5.0.3. Virus-free and 100% clean download. Get Quick File Renamer alternative downloads.
For this example, I'll be renaming a folder of images so the name replaces spaces with dashes and adds a keyword to the end, making them more SEO friendly.
- Fast File Renamer is a freeware program that can help you with the task of renaming large numbers of files. The program can be used to keep large collections of files organized (such as mp3 files.
- ReNamer 7.2 Portable 4.04 MiB: 2020-03-30: Latest development ReNamer Beta 4.04 MiB: 2020-10-06: Older versions ReNamer 7.1 Installer 3.79 MiB: 2019-05-28.
- Why Quick File Rename? Powerful recursive renaming, allowing you to rename all files in a folder, as well as files in that folder's subfolders.; International character support i.e Unicode, the only renaming application to do so.; Rename from a list, the ability to rename files and folders from a custom list.; Rules system, create infinite ways of renaming files and folders using only.
- Or you want files to follow a different renaming system like file-A.jpg instead of the default file(1).jpg. To rename files in bulk more efficiently, you can either learn some complex shell scripting language (SED, AWK, Perl) or switch to something more simple - a spreadsheet. Step 1: Type cmd and switch (using “cd” command) to the.
Here's how to go about doing this..
Step 1 - Generate Your File List
First thing is to get a list of all the files you want to rename. Start by opening the command prompt by clicking Start then typing
cmd
(in XP, hit run and then type cmd). This will open up the command prompt.Then we need to change the current directory to the one we want. An easy way of doing this is to open the folder and copy the location. Got the command prompt, type
cd
and then right-click and hit paste. Hit enter and the directory we're working within will change to the one with all our images in.Now we need to generate the list of images. Type this:
This will create a list of all the files in the folder and export them to a new file called
_list.txt
. You can call this file what you want.Step 2 - Edit In A Spreadsheet
Open our newly generated file in a text editor and copy the list to a spreadsheet. Remember to remove any unwanted files, such as the list itself.
Then add the following formula to the next cell across, replacing what you want to change with what I've put:
This replaces all the spaces with dashes. We put the text source (our original file name) then what we want to replace (in my case, the spaces) and then what we're replacing it with (the dashes). Drag this formula down so it renames all our files.
Now we want to add
worktop
to the end of each filename, so we copy the process from before:What I'm doing here is replacing the full stop before our file extension and replacing it with
-worktop
, but remembering to add the dot again.That's the file names changed, now we need to write our command so that the command prompt can do the hard work for us.
Step 3 - Writing Our Command
The syntax for renaming files with the command prompt are as so: Aiseesoft heic converter v1 0 for mac free download.
So in our spreadsheet we are going to create this. To make sure we don't encounter any errors, we're going to wrap our old and new file name in quotes. Whenever we want to write quotes within excel, we need to use four of them together. This is so it knows to print a quote symbol and not to interpret it as a string. This is what our next column should look like:
Step 4 - Watch The Magic Happen
![Renamer Renamer](https://www.easyfilerenamer.com/img/screenshot/efr2300/music-fixer.jpg)
Now, copy the last column and paste it into our command prompt (remember to right-click, Ctrl+V doesn't work). The window will now start working away, renaming all our files. And that's it. We've changed alot of images to be more SEO friendly and with no time at all. Once this method sticks in your head, it can be a real time saver!!
The ReNamer interface is shown below. Click on any part of the screenshot to see full description.
Using ReNamer is very simple. Just follow the four steps shown below.
Step | What to do |
---|---|
1 | Select the files from various folders and add them to the working area.
|
2 | Add rules to create a sequence of operations. Delete or edit an existing rule. Change the order of the rules.
|
3 | Preview the results (check before proceeding with the actual renaming).
|
4 | Press this button to rename files and folders. |
ReNamer is so intuitive that you would be able to use it without reading the manual any further.
The rest of the chapters provide more details on all aspects of ReNamer. Use them as reference.
File Renamer Download
There is an older version of this guide available here: Quick Start.
File Renamer Software
Retrieved from 'http://www.den4b.com/w/index.php?title=ReNamer:Quick_Guide&oldid=3316'