Extracting JPEG data to Excel

Is there a program that will allow me to extract the photo number from a series of JPEG photos and then paste the numbers in a column on an Excel spreadsheet? I am using Excel to list names & other information about each of 1000's of photos and do not want to have to manually enter each photo number.
Thank you.
HKWat

If you are using windows.. Open command prompt, Navigate to the directory which has the jpeg images and type the following command..

DIR /B /O:N > filename.txt

This command will save all the jpeg file names as a list in a txt file in the same directory itself.

Then copy,paste to excel..

Thank you for your instructions. I followed them and was excited to see my computer say it was converting my JPEG photographs. It took several hours to complete. However, what I ended up with was a new Excel spreadsheet with all of the columns blank, except the first one which contained words that appeared in the photographs themselves (ie where visible in the photograph). The conversion did not appear to provide any data (including the photo number) of any of the photographs. Did I do something incorrect to get this result? Is the data converted, but somehow still hidden? Any suggestions on where I go from here?
Thank you.
HKWat

Not sure what's gone wrong. Really sorry for that.. Should have been more elaborate. This process should NOT take more than a minute or two

Step 1 : If you are using windows.. Open command prompt.
Step 2 : In command prompt, navigate to the folder where the jpeg images live. For example if the images are in d:\images\jpegs\ you should get into folder in command prompt.
Step3 : now Command prompt window will something similar like the attached file.
Step4 : type DIR /B /O:N > filename.txt. This command will save a text file (with all the file names in the folder) - filename.txt in the directory where your images live.
Step 5 : Open the text file. You will see all the jpeg names in the text file.
Step 6 : Copy the TEXT and open excel and paste in a column.

See attachments.
1. Command prompt navigating to d:\images\jpegs
2. Text file which has 21 file names of the jpeg images i have in the above folder

Again sorry for any trouble my post i have made.

Thank you for the more detailed instructions. I never used the Command prompt before. I searched and found it via Start/All Programs/Accessories/Command. I have tried numerous times to enter the file name with its location (ie C:\Documents and Settings\Owner\DEsktop\ss 1981-82 back-up) and I get the following message: 'C:\Documents' is not recognized as an internal or external command, operable program or batch file. The long file name I am using is the Location for the specific file as given to me by my compute. I do not know if what I am doing is one space click off or putting in too much information. I have tried several variations, but still no success. Can you call me at 559-435-1992 (Fresno) and maybe you can walk me through what I need to do. Your help is most appreciated!
Thank you.
HKWat.

hkwat:

Assuming you are running Windows, you need to access the command prompt first. However, once you do this, it may be difficult to find the directory in which your jpegs reside.

As an alternative, go to the directory (folder) in which your jpegs are contained, and create a new text file. To do this, right-click inside the directory window, and select New and then Text File Document (I am assuming you have Windows 7; if not, then the exact dialog may be slightly different.) You should end up with a new file in that directory called New Text Document.txt.

Click on the New Text Document.txt file and rename it to Dir2File.bat. Ensure that the .txt portion of the extension is no longer there. (Windows will tell you that changing file extensions is bad; that's okay. Accept it.)

Right-Click on the file and select Edit (NOT OPEN). Type DIR /B /O:N > filename.txt into the file and save it. Close out of the edit window.

Now double-click the Dir2File.bat file, and it will execute the instruction without the need to open a command prompt. When you do this, it will create a new file called filename.txt which contains the filenames you are after. If you later change the content of the directory, you can re-execute the file & it will overwrite the old one.

You can then open the filenames.txt file from Excel.

I have Windows XP. Does this make a difference in your directions of what I need to do? I was able to create a Dir2File.bat file within the folder containing my JPEG photographs, but nothing more seems to happen. Any further suggestions on what I need to do?
Thank you.
HKWat

If your Dir2File.bat file contains the DIR /B /O:N > filename.txt instruction, then all you should need to do is double-click it to generate the filenmam.txt file. IF not, then you need to edit it to add that instruxction as noted in my previous post.

Not sure if the problem is solved.

If not, then copy the attached file into the folder where you have your images (C:\Documents and Settings\Owner\DEsktop\ss 1981-82 back-up)

Removed .txt in end. Windows will say the file will be unusable. click yes.

Double click on the copied Dir2File.bat file. This will create a new txt file named "filename.txt" in the same folder. This txt file will have all the jpegnames.

Hope I am not confusing more :0

HKWat:

Sounds like you may have your system set to not show file extensions. If this is the case, then when you renamed Dir2File to Dir2File.bat, it was actually Dir2file.bat.txt, which would not be an executable file.

Google "Show file extensions" for instuctions on how to show these, then it should be more apparent when you rename the file.

I might add that the macro approach posted above by Leith is probably a better method if you will do this often.

Thank you for your suggestions. Unfortunately, my tech savvy is very limited and I could not follow your suggestions. I do appreciate the time you and others spent trying to help me. I was able to find a free program called PhotoStudio, which allowed me to extract the photo numbers from the thousands of digitized photographs I have.
HKWat

elayaz,
Thank you for taking the time to help me out. I was unsuccessful in utilitizing your information. I do not know if it was my Windows XP or my limited computer skills. Fortunately, a friend found me a program from the UK entitled PhotoStudio, which I was able to use to pull the photo numbers from my thousands of digitized photographs.
Wishing you the best.
HKWat

Thank you for your efforts to be of help to me. Unfortunately, my limited computer skills were insufficient to make use of your help.
I appreciate you taking your time to respond.
Wishing you the best.
HKWat

hello, You can try out the following as an easy first attempt, and take a look how much organizing work would take to reordening data once in excel, its convenience will depend on number columns /files of your jpg data base and also rate letters/numbers:
1- Attach your jpg table to blanc Word document,save it as a PDF
2-Open pdf and select & copy de numeric data inside your database4
3- Paste data into Excel cell. This should get your data in excel ( mixing a hole row of your original datatable into a single cell)
4-In EXCEL menu use Command DATA-->TEXT IN COLUMNS ( choose blanc space as delimitator when you are asked to) to separate mixed data into different cells.

I hope it helps :-))