Export eBay Orders to CSV — Clean, Filtered, Ready to Use

Exporting your eBay order data to a CSV should be simple: choose a date range, click download, and get a clean spreadsheet. In practice, eBay makes this harder than it needs to be. Seller Hub’s download options produce files that need significant cleanup before they are useful.

What eBay’s order exports are missing

Seller Hub lets you download order reports, but the output has several issues for UK sellers who need clean data:

  • Too many columns: You get 30+ columns including buyer details, shipping addresses, and internal eBay fields you do not need for bookkeeping.
  • No net amount: There is no column showing sale amount minus fees. You have to calculate this yourself.
  • Mixed transaction types: Sales, refunds, and adjustments are not clearly separated or filterable.
  • Date format inconsistency: Dates may not match your locale or accounting software expectations.

What a clean order export looks like

Our transaction export gives you one row per transaction with exactly the columns you need:

Transaction export (bookkeeping template) — one row per order line.
DateTypeOrder IDItemSKUQtySale AmountFeesNet Amount
25/03/2026SALE12-09876-54321Vintage Penguin Paperback - Orwell 1984BK-ORW-19841£14.50-£2.18£12.32
26/03/2026SALE12-09876-54322Royal Mail Stamps Edward VII CollectionSTMP-EDV-0021£62.00-£8.68£53.32
27/03/2026REFUND12-09876-54310Tea Set, Royal Albert Old Country RosesRA-OCR-0061-£48.00£6.72-£41.28
28/03/2026SALE12-09876-54325Hornby OO Gauge Class 47 LocomotiveHRN-C47-0121£89.99-£12.60£77.39
29/03/2026SALE12-09876-54330Pokémon TCG Charizard Holo PSA 8PKM-CHZ-PSA81£180.00-£25.20£154.80

Columns explained

  • Date: Transaction date in YYYY-MM-DD (bookkeeping) or DD/MM/YYYY (accountant template)
  • Type: SALE, REFUND, CREDIT, or SHIPPING_LABEL
  • Order ID: eBay order reference for cross-referencing
  • Item: Item title from the listing
  • SKU: Your custom SKU if set on the listing
  • Qty: Quantity sold
  • Sale Amount: The gross amount (positive for sales, negative for refunds)
  • Fees: Total eBay fees for this transaction (negative)
  • Net Amount: Sale Amount + Fees = what you actually keep

Filtering by date range

Choose from preset date ranges (last 30 days, this month, last month) or set a custom date range. The free tier covers the last 30 days; Pro gives you up to 3 years of historical data.

Date filtering happens on eBay’s side, so you only download the data you need — no waiting for a massive file to download and then filtering in Excel.

Three template options

Every export type (transactions, payouts, fees) supports three templates:

  • Raw: Every field from the eBay API, unmodified. Maximum detail for power users.
  • Bookkeeping: Clean columns, YYYY-MM-DD dates, filtered to sales/refunds/credits. Good for your own records and most spreadsheet workflows.
  • Accountant (Pro): DD/MM/YYYY UK dates, truncated descriptions, transaction references, and a VAT Note column. Designed to hand directly to a UK accountant.

How to export your eBay orders

  1. Install the eBay Seller Reports Chrome extension from the Chrome Web Store
  2. Click the extension icon and connect your eBay UK seller account
  3. Choose “Transactions” as the export type
  4. Select your template and date range
  5. Click export — the CSV downloads directly to your computer

The entire process takes under a minute. No account creation beyond connecting your eBay account via OAuth. The free tier includes 5 exports per month.

Excel compatibility

All CSV exports include a UTF-8 BOM marker, which ensures that special characters in item titles (accented letters, symbols) display correctly when opened in Microsoft Excel. The files also open cleanly in Google Sheets, LibreOffice Calc, and Numbers.