How to Export eBay Sold Listings to CSV and Excel

A spreadsheet makes a search easier to work with, but it does not make unrelated listings comparable. Start with the model, size or variant that matters. For this walkthrough, we use Sony WH-1000XM5 and the US marketplace, ebay.com.

Open Dashboard Search, enter the product, and choose the eBay site beside the search box. Use More filters to adjust the result ceiling, condition and price range. UK prices belong on ebay.co.uk; Australian prices belong on ebay.com.au. Choose the marketplace before exporting rather than changing the currency symbol afterward.

Leave AI Relevance enabled for an initial cleanup, then review the results yourself. It helps remove irrelevant items but does not establish that every row matches the exact variant or condition you need.

Sign in or create an account if prompted. The link preserves the keyword and marketplace; it does not run a search until you press Search.

After the search finishes, inspect the titles, condition, sold dates and prices. Keep replacement parts, bundles and different models out of the comparison you build in your spreadsheet. Next, select Export CSV above the results table.

The browser downloads a file named after the search, such as compsniper-sony-wh-1000xm5.csv. Exporting uses the results already loaded in your browser, so clicking the button does not run another search.

Download the example CSV to follow the spreadsheet steps without running a new search. It is a fixed example captured for this guide, not a live feed.

In this demonstration, we requested up to 60 results and received 35. The table showed 25 rows on its first page, while the CSV contained all 35. The export is unchanged: it includes mixed conditions and source dates that need review before a pricing analysis.

Google Sheets works in a browser. Start a blank spreadsheet, choose File > Import > Upload, and select the downloaded CSV. Import it into a new spreadsheet or a new sheet so you do not replace an existing worksheet.

Choose Comma if automatic separator detection does not split the columns correctly. Turn off Convert text to numbers, dates, and formulas for a text-preserving import. This keeps listing IDs intact and prevents spreadsheet software from interpreting text unexpectedly. You can convert the price and date columns deliberately afterward.

Freeze the header row and turn on a filter if you are reviewing many rows. Widen Title enough to read the product identity, and keep Currency visible beside Sold price. When you need an Excel workbook, choose File > Download > Microsoft Excel (.xlsx).

If you used the text-preserving import and want to calculate with prices, add a working column called Numeric sold price. Use =IF(C2="","",VALUE(C2)) for the first data row and fill it down through the imported rows. Keep the original Sold price column unchanged, and check the sheet's locale if decimal points are not interpreted correctly.

Google documents the File, Import and Upload workflow and working between Sheets and Excel.

In desktop Excel, use Data > From Text/CSV rather than relying on a double-click import. Select the file, check that the delimiter is a comma, and review the preview before loading. Use the transformation step to keep Item ID as text and assign numeric types to prices deliberately.

If the entire row appears in one cell, the delimiter was not interpreted correctly. If the title contains broken accented characters, select UTF-8 as the file encoding. A CSV file does not preserve column widths, colors or extra worksheets, so save your working copy as .xlsx after formatting it.

The screenshots in this guide show CompSniper and Google Sheets. Excel menu guidance follows Microsoft's import documentation; no Excel installation is required to use the Google Sheets workflow.

The standard dashboard CSV is a compact ten-column export. It does not contain every JSON response field. In particular, it does not include bestOfferAccepted. Check the JSON when that marker matters: the visible price on an accepted-offer listing may differ from the amount the buyer actually paid.

Before calculating a median, separate currencies, conditions, variants and lots. A blank shipping amount is unknown, not automatically zero. Keep a copy of the untouched export and do your filtering in a working copy. Our sample-size guide explains why the quality of the comparisons matters more than a large row count.

The standard /v1/scrape endpoint in the CompSniper REST API returns JSON rather than CSV. If you need scheduled files or an inventory integration, request the data and write the fields into a CSV with your language's CSV library.

# Python 3. Uses only the standard library.
import csv
import json
import os
from urllib.parse import urlencode
from urllib.request import Request, urlopen

params = urlencode({
    "keyword": "Sony WH-1000XM5",
    "ebaySite": "ebay.com",
    "sold": "true",
    "count": 60,
    "relevance": "true",
})
request = Request(
    "https://api.compsniper.com/v1/scrape?" + params,
    headers={"Authorization": "Bearer " + os.environ["COMPSNIPER_API_KEY"]},
)
with urlopen(request, timeout=75) as response:
    data = json.load(response)

with open("sold-listings.csv", "w", newline="", encoding="utf-8-sig") as output:
    writer = csv.writer(output)
    writer.writerow(["Title","Condition","Sold price","Currency","Shipping","Total","Date","Seller","Item ID","URL"])
    for item in data.get("items", []):
        writer.writerow([
            item.get("title"), item.get("condition"),
            item.get("soldPrice"), item.get("soldCurrency"),
            "Free" if item.get("shippingType") == "free" else item.get("shippingPrice"),
            item.get("totalPrice"), item.get("endedAt"),
            item.get("sellerUsername"), item.get("itemId"), item.get("url"),
        ])

print("Exported", len(data.get("items", [])), "rows to sold-listings.csv")

Written by CompSniper's founder. Screenshots and the example export use an owner-run demonstration, not customer activity. CompSniper is independent of eBay. Read our methodology and source limitations.