It’s really important to us that we keep our business organized, from inventory to sales tracking, we want to make sure that we have all our ducks in a row. That’s why we love being able to export eBay listings to Excel!
Each week we do an Excel CSV export of all our active listings so that we can use the “vlookup” function to compare with our main inventory spreadsheet.
Use can use this feature on more than just active listings. You can even export your unsold and scheduled listings!
Step-by-Step Instructions to Export eBay Listings to Excel
- Select your listings and open the bulk editor.
- Click the checkboxes on the right of all the items you want to export.
- Click on Action > Export to file.
- When the box pops up, click on Export to CSV (spreadsheet format) and then the blue Export button.
- Depending on your browser settings, you might have a box pop up where you can select the file location. Otherwise, the file should automatically open.
Don't Have Microsoft Excel?
While you can use free services, such as Google Sheets, we’ve found that Microsoft Excel really is the best platform to use for tracking our eBay sales and inventory. It has the best functionality and does everything we need it to do.Get Microsoft Office
Here is a quick tutorial we created for how to export eBay listings to excel.
If you like this blog post, you might also like....
We love our Excel spreadsheets! If you haven’t set up a sales tracking spreadsheet for your eBay business, you need to check out our blog post titled, “How to Set Up Your eBay Sales Spreadsheet”.
Export eBay Listings to Excel: IMPORTANT UPDATE
Recently there has been some problems with exporting from eBay. When you follow the instructions from the video, you might find out that nothing happens.
Unfortunately, this is a security issue that eBay is having with the different browsers.
We have not been able to figure out a workaround for Firefox, Internet Explorer, or Edge. However, if you have Chrome, we have found a solution.
Don’t worry, if you don’t have Google Chrome, you can download it here.
Step 1: Using the Chrome browser and in the eBay bulk editor, click all the checkboxes for the items you want to export. Then click on Action > Export to file just as you normally would.
Step 2: Leave the bullet clicked on Export to CSV (spreadsheet format) and click the blue Export button.
Step 3: After you click the blue Export button, you notice that nothing happens. However, a little gray shield with a red X icon should have popped up on the right side of the URL bar. Click on the icon.
Step 4: Once you click on the icon a box should pop up. Click on Load unsafe scripts. The page will refresh and the icon will disappear.
Step 6: Once the page has refreshed, you will see a box from eBay pop up. Select Yes, continue with the listings I was working with and click the blue OK box.
Step 7: After hitting the blue OK button, your listings will come back up as normal and you can follow the steps again to export the listings.
Every eBay Seller Can Relate to This Shirt
Get yours and wear it proud!Get This Shirt