How to export eBay sold data to a spreadsheet

If you price inventory in a spreadsheet, you want sold comps sitting right next to your items. Here is how to pull eBay sold data into a CSV in a few lines.

Pull the sales

Call the API for your keyword and write the results to CSV:

import csv, requests
r = requests.get(
    "https://api.ebaysoldlistingsapi.com/scrape",
    params={"keyword": "dyson v11"},
    headers={"Authorization": "Bearer YOUR_API_KEY"},
).json()

with open("sold.csv", "w", newline="") as f:
    w = csv.writer(f)
    w.writerow(["title", "soldPrice", "currency", "endedAt", "condition", "shipping"])
    for i in r["results"]:
        w.writerow([i.get("title"), i.get("soldPrice"), i.get("soldCurrency"),
                    i.get("endedAt"), i.get("condition"), i.get("shippingPrice")])

Open it anywhere

The resulting sold.csv opens directly in Excel, Numbers, or Google Sheets. From there you can pivot, chart, or run =MEDIAN() over the price column.

Google Sheets, live

For a live sheet, put the request behind a small Apps Script or a serverless function that returns CSV, then pull it with IMPORTDATA. Now your comps refresh on demand instead of going stale.