How to Rename Files using Excel (windows)

I sell lots of things to hardware stores. Retail stores keep track of items by their own internal number. We refer to those numbers as 'customer numbers' because we have lots of customers and customers each have their own numbers.

They each call them the SKU number aka STOCK KEEPING UNIT.

I had 450 image files listed by model number(our number) that needed to be changed to customer numbers(their number). Here's how i did it.

Create an excel spreadsheet with current filename(with file extension) in column A
Put the filename you want in column B.
Put an equation in column C that is "ren " and column A and " " and column B.

spreadsheet should look like this:

Current Filename	Filename You Want	="ren "&A1&" "&B1
10036.jpg	B000HJDBAU.pt01.jpg	ren 10036.jpg B000HJDBAU.pt01.jpg
10038.jpg	B000VRDIA6.pt01.jpg	ren 10038.jpg B000VRDIA6.pt01.jpg
10040.jpg	B000BQ7UW4.pt01.jpg	ren 10040.jpg B000BQ7UW4.pt01.jpg

After you have a completed the spreadsheet open CMD like this:

After the CMD is open, you need to open the folder where your images are. find your pictures and right click to 'copy address as text'

Back in the CMD type: CD [right click to paste the address that you just copied]

Now copy column C from your spreadsheet and paste into the CMD. It will find all the current filenames and change them to the ones you want!

Comments

Life Hacks

DIY Distilling with a Wok Still DIY AC DIY Fleshlight DIY Outdoor Luxe DIY PBR Burner Downloading Free Sunlight Forever Guide to Downloading ebooks on IRC Part 1 Guide to Downloading ebooks on IRC Part 2 Steampunk Goggles Weapons Delayed Fire and Incendiary Bomb DIY Shotgun Pipe Hand Grenade Drugs Drugs Venn Diagram Hallucinogen Awareness Painkillers Periodic Table of Beer Styles The Golden Age of Pills Recipes Creating LSD Extraction of DMT How to Cook Crack Mescaline Capsules Weed Green House Seed Flavour Pie How D'ya Smoke Pot and Stay Out of Jail? Okay You've Been Careful But... Stoner Etiquette Fashion A Very Short Guide to Dressing Well The 20 Laws of Fashion The MANual Food About Bread Foods on the Cheap Drinks Coffee Types Emergency Coffee Hollywood Happy Hour Mind Fuck Coffee Mixing Drinks Recipes 3 Minute Brownies 3-Bean Bu

Amazon Product Image Shortcut URL from ASIN

I'm trying to find a better way to build my affiliate pages. I've discovered a great way to find images of items that i hadn't known about before. http://images.amazon.com/images/P/B0051VVOB2.01.LZ.jpg http://images.amazon.com/images/P/ <- this is required B0051VVOB2 <- this is the ASIN .01.LZ.jpg <- this is required to follow the asin for large photos If you would like smaller, remove the LZ. http://images.amazon.com/images/P/B0051VVOB2.01.jpg

How-To: I'm Feeling Lucky Short Cut

Google's answers usually get me the best result first. Here is a chrome shortcut how to get to "i'm feeling lucky" first result! 1. Copy this URL: http://www.google.com/search?hl=en&q=%s&btnI=I%27m+Feeling+Lucky&aq=f&oq= 2. Go to Chrome Settings 3. Go to Manage Search Engines 4. Scroll to bottom and you'll see blanks to create new 5. In first box type "I'm Feeling Lucky" 6. In second box type "iflucky" or "ifl" (whatever you type here will be your shortcut in the search bar. 7. In the third box paste the URL i asked you to copy It should look like this image below. Now it should work. Open a new tab and in the search bar type "ifl best waffles"

Archived Notes

Search This Blog