Copy new files names into excel column

Advanced Renamer forum
#1 : 05/06-14 14:42
Gina Donovan
Gina Donovan
Posts: 2
Is there a way to open renamed images folder and export each renamed image name into an excel file column.

I renamed thousands of images and need to compare to existing image names in excel that were not included in the renaming.


05/06-14 14:42
#2 : 25/06-14 22:08
cindermouth
cindermouth
Posts: 2
Reply to #1:

Not sure if this is what you're looking for but here's an old school solution. (I'm assuming you're using Windows 7 or similar)


Hit Start button
Type "Command" into the box and hit Enter (You'll get an old dos command window)
Change to the folder containing your renamed images with the CD comannd
(ie. CD \USERS\JOHN\RENAMED IMAGES
Once you are in the folder type:

DIR /B > renimages.csv

Type "Exit"

You can now load renimages.CSV in Excel by just finding it and double clicking on it to open.

Once in Excel you'll want to do a "Save As" with filetype "Excel Worksheet" so that you'll have a spreadsheet and not a text file to work from.

Hope this helps.

C


25/06-14 22:08 - edited 25/06-14 22:09