How do I take dates of images in win 10, and paste them into word?

I have thousands of images and I need to list the dates taken in excel 2002.

And of course the file names.

Thanks all

Edited by hamluis, 08 April 2024 - 12:46 PM.
Moved from All Other Apps to Business Apps - Hamluis.

I'm just using Google Fu here, but this might work, assuming creation date =  Date taken.

https://www.reddit.com/r/excel/comments/164uz9x/how_to_quickly_import_file_creation_dates_into/

I am not sure, but I'd guess one of the major photo organizing programs, such as Adobe Lightroom would have a feature that would allow you to scan a folder or folders and create some sort of index of all the photos. Once you have that index, there's probably a file format you could export it to.

Wait, the title of this thread lists Word, but in the body of the message, you make it sound like you want these data imported into Excel. Can you please clarify?

Edited by Shplad, 08 April 2024 - 02:41 PM.

Typo should say excel 2002.

What i have is thousands of images, I need to know how many images were taken on each date, including zero.

Thanks for your help

Well, do you just need the numbers, or do they have to be in Excel?

I say that because Explorer will let you display column headings, including tags, such as date photo was taken. If you turn that on in each folder, and sort by the column header, you'd know the numbers.

Edited by Shplad, 08 April 2024 - 08:22 PM.

I have thousands of images and I need to list the dates taken in excel 2002.

And of course the file names.

Thanks all

Well, do you just need the numbers, or do they have to be in Excel?

 

I say that because Explorer will let you display column headings, including tags, such as date photo was taken. If you turn that on in each folder, and sort by the column header, you'd know the numbers.

Excel would probably count them.  8000 images to go thru

Okay, I'm not clear on what you want. If all you want is to count them, what's wrong with the method I described above? Why does it have to be done in Excel, rather than Explorer?

I guess i need a printed list so i dont have to keep looking at explorer and counting each date again

thanks

Needing a printed list and needing it from Excel are two different things. I suggest you try the above suggestion and see how it works for you. It would only take a minute or less for each folder with the "dir" command from within a command prompt. You could also use the "/s" switch to see a list of everything, including subfolders (subdirectories).

https://www.computerhope.com/dirhlp.htm#:~:text=The%20dir%20command%20displays%20a,in%20the%20DIRCMD%20environment%20variable.

If you want the ease of doing this in Explorer, there are programs that allow you to print a list of files/directories from there too.

Edited by Shplad, 09 April 2024 - 10:20 AM.

thanks

close this thread

You're quite welcome.

We don't close threads here.