Rename files with Excel

In a few seconds you will be able to rename thousands of files, be they images, PDF files, compressed files, MP3, etc …

Among several options you will achieve, for example, replace character strings, change from uppercase to lowercase, modify the extension, etc …

Sometimes several customers need you to send them images from your catalog renamed with their ASIN code, reference number or a short description of the product or image. In case of uploading them to a website, they must be renamed correctly to have a good SEO web positioning or so that your sales team has all the product information at hand from an Excel sheet. For example Amazon, in its Vendor Central, before uploading the product images it is necessary that they be sent with the code “EAN” + “main.jpg”.

To avoid doing each file one by one and with the time that that entails … I have created this macro with Excel, a program that will save you a lot of time.

I detail the steps necessary to rename with this simple and fast macro:

  • 1. Select the path of the folder where the images are located.
  • 2. Add the route in column B, clicking on the button “Choose origin route”.
  • 3. Write a text or paste the EAN of the product in column C.
  • 4. Click Run macro “Rename Files”

It’s that simple and in less than 2 minutes you can rename thousands of files. I recommend making a copy of the folder because it is not possible to undo this action in case of an error in some name.

Calculate DUN14 check digit from EAN13

This code is known as DUN-14, in English “Distribution Unit Number” currently the 14-digit barcode, it is used in containers or cardboard boxes with a certain amount of articles, pallets, packaging or logistics…

Read More

Create folders with Excel

Do you need to create many folders and indicate a different text to each of them? I have the tool that you need so much, it is very simple, you just have to…

Read More

Calculate EAN-13 check digit

The barcode code is known as EAN “European Article Number”, it is used in many products to find out their origin, content, country of origin, etc… In short, the code is used to…

Read More
Load More

Leave a Reply

Your email address will not be published. Required fields are marked *