Strange Question: I would like to transfer my photo listings to excel then transfer to ebay

[nevadallc]

Thanks for reading:

This is my first post.

I'm an ebay powerseller currently, and I have a private photo collection of over 10,000 unique photographs in several digital folders. (yes they are all digital).

They also have the titles already there as the file name for each photograph.

1) I already know how to upload excel files to auctiva/ebay for other items.

2) My question then is how can I get excel to "accept" or open my photo folders and paste just the title/file name line by line. That would give me a great start, and then
I could fill in the rest.

3) So....(sorry this is going on a bit its just not a straightforward question)............

So if I had to sum it up in one sentence: "How can I transfer the file names of all my photos to excel in bulk so it only shows their titles line per line"


Thanks!

They are standard JPEG and TIFF images with their titles as the filenames.

 

[Gary's Student]

First open a Command Prompt and type a command like:

dir /b F:\pics\*.jpg > C:\Users\Mike\Desktop\Pictures.csv

where F:\pics is my picture folder and
C:\Users\Mike\Desktop is the path to my Desktop


Then open Pictures.csv with Excel.

 

[nevadallc]

Thanks for the reply, I'm not that familiar with excel just ebay and auctiva....if you could go in a bit more detail I'd really appreciate it! Thank you!

Dave

 

[rjwebgraphix]

What Gary was talking about is a dos level command. If you're not familiar with dos, I wouldn't recommend it. It would just confuse you.

Your question gave me an idea for something else I have going on at home and thought I could re-purpose it for your needs.

I just need to know exactly how you need it in a spreadsheet.

I understand the filenames are the title, but do you need a separate "title" and Filename in two different columns or just the filename? Do you need the extension with the filename. IE: FILENAME.JPG Would the path be helpful to have also in a column?

I'm not sure how the excel to ebay thing works. I don't do much on ebay, but I pretty much have a macro all set up for your needs, will just need that info to adjust what is going in which columns.

Currently its setup as...

colA        ColB
path2file    filename.ext

let me know and I'll get it finished up.

 

[rjwebgraphix]

If you're still looking for a solution. Check this spreadsheet out. If this isn't what you need, let me know and I'll change it up.....

http://rjfiles.nelacat.com/mrexcel/FileNamesToXLS.xls