File Exchange Download Instructions:

These instructions assume that you have already subscribed to eBay's File Exchange and have a File Exchange link in your My eBay's My Subscriptions nav bar. If you have not yet subscribed to File Exchange, please see Subscribing to eBay's File Exchange.

To get a list of all of your active eBay listing item numbers (ItemIDs in File Exchange parlance) along with some other fields such as ItemTitle, CategoryLeafName and CategoryNumber that may be useful for identifying your listings, as well as some other fields that likely won't help you at all:

1. Open Excel if it is not already loaded, else a confusing shell instance of Excel will likely open up in step 7. The Excel shell may even load despite Excel already being open - I have not discovered a pattern that explains this seemingly inconsistent program behavior.

2. Switch to your browser program and go to EBay and then your My eBay. Regardless of your My eBay default view (unless it is My Messages or Dispute Console, in which case you should click on any other My eBay Views selection), you should see a My Subscriptions nav bar under your My eBay Views nav bar. Click on the File Exchange link to get to the File Exchange Center.

3. Click either the Download Files link in the nav bar or the Create a Download Request link in the downloads column.

4. Select Active from the Listings and records dropdown selection box, and leave the resulting All active listings radio button selected.

5. Enter your email address(es) to receive download notifications if the Email address box is blank or needs to be changed (the box will be filled in for you on subsequent visits), then click the Save button.

6. The email address(es) you specified will receive an email when the download file has been completely processed. There will be a link in the email that will take you to your File Exchange View Completed Downloads page.

Whether the email has arrived or not, you can click the Completed Downloads link in the File Exchange nav bar to get to the same View Completed Downloads page to check the file's processing status, refreshing the page until the file has been 100% processed and the status column says File Complete.

7. On the View Completed Downloads page, click the Download link in the rightmost column, which should result in an Excel spreadsheet opening up within your browser window that contains the downloaded CSV format file.

I can't tell you what will happen if you don't have Excel or don't have the csv extension associated with Excel.

8. If you ended up with an Excel shell, close the Excel shell. Open up Excel if necessary, create a blank Excel worksheet if necessary, then cut and paste the browser spreadsheet into the Excel spreadsheet (the easiest way to do this is to right click on the blank cell at the top left of the browser spreadsheet, above the row 1 label and to the left of the A column label, then select copy; switch into Excel and select either the corresponding cell at the top left of the Excel spreadsheet (above the row 1 label and to the left of the A column label) or cell A1, then right-click and select the Paste option.).



9. Save the file as is in case you screw up and want to start over, so that you do not have to download the file again. If your Excel workbook has multiple worksheets, you will have to delete the empty worksheets before you can successfully save the file in CSV format, because the CSV format does not support multiple worksheets. Select File then Save As... from the Excel menu, change the file name in the File name box if you wish (I recommend that you do so), select the CSV (Comma delimited) option in the Save as type dropdown selection box, change the folder in the Save in dropdown navigation box at the top of the Save As dialog box if you wish, then press Enter or click the Save button.

10. In the Excel file, you probably want to widen column A so that the items numbers/ItemIDs do not display in exponential format. If you are going to revise all of your listings with the same set of revisions, you can delete all other columns. If you need to select only some of the listings or want to make different revisions to different listings, you probably do not want to delete the ItemTitle, CategoryLeafName or CategoryNumber columns yet, but can likely delete the rest; in that case, widen the ItemTitle and CategoryLeafName columns so that they are easier to read.

11. After you have deleted the item numbers, if any, that you do not wish to revise, you can add columns to create an upload submission file. You can download the eBay File Exchange User Guide if you want to learn what you can revise and how. Don't forget to delete the ItemTitle, CategoryLeafName and CategoryNumber columns and any other columns that you have kept so far from the original download file before you upload your revisions.

If you want to revise shipping services/costs, I have created a template for that purpose with the instructions at Bulk Revising Shipping Services/Costs. You can paste the item numbers list you ended up with after step 11 above into the ItemID column of that template and follow the instructions to complete and upload your submission file.