Our Blog

Cool Tools: Mass File Renaming with spreadsheet

In our constant effort to provide not only the best products in all areas but also the best and most efficient way to order them online we have undertaken a massive project that requires us to rename the images we use. Normally this might require simply arranging everything in an ascending order and replacing with a numbered list. This time isn’t that simple, so I took the challenge of finding a tool that could rename thousands of files from an old name to a new name via a spreadsheet that contained both. Simply put I had an excel document with two columns…Column A had the old (current) filenames and Column B had the new filenames. I went on the lookout in all manner of websites, blogs, forums until I came across this site… ( http://www.labnol.org/software/tutorials/rename-multiple-files-bulk-excel-googl-docs/2481/ ) Being a Mac guy, this hurt a little as the technique requires the use of DOS to complete the filename change. I decided to move forward with this technique nonetheless and found that it worked perfectly to rename 3000+ jpgs…Awesome! Again here’s the link to the technique…enjoy!

http://www.labnol.org/software/tutorials/rename-multiple-files-bulk-excel-googl-docs/2481/

This entry was posted in Products, Resources. Bookmark the permalink.

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>