What eBay export file format does this tool accept?

This tool accepts eBay Orders CSV files. Export from eBay and upload the CSV file directly.

Can I convert eBay CSV to Xero Contact?

Yes, this tool converts eBay Orders CSV exports directly to Xero Contact CSV format compatible with Xero Contact.

How do I import eBay orders to Xero Contact?

Export your orders from eBay, upload the CSV file to this converter, then import the converted file to Xero Contact.

eBay to Xero Contacts — Sync Buyers to Xero CRM

🥦

Xero Contact CSV Format

valid rows

Build your Xero customer database from eBay order history. Extract unique buyers with shipping addresses, emails, and account references.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample

Sample eBay orders export CSV

Download

Tool Rating

4.6 / 5 (63 votes)

How to Convert Your File

Export from Ebay Seller

Reports → Download → Download report

Upload and Configure

Upload Orders Report CSV and choose Contact format

Preview and Download

Review converted data, download Xero-ready file

Import to Xero

Contacts → All Contacts → Import → Upload CSV

Output is in Xero Contact CSV format — ready to import directly, no manual reformatting needed.

How People Use This

I had two years of eBay order history but no customer database in Xero. The converter extracted unique buyers with deduplication by username, parsed names into first and last fields, and included shipping addresses. I imported all 1,800 contacts before my first invoice batch.

Most of my eBay buyers are repeat customers who need invoices. Converting my order export to Xero contacts gave me a complete customer database with eBay usernames stored as account numbers. Now I can look up any buyer instantly and their details auto-fill on new invoices.

My clients needed their eBay customer data in Xero for proper accounts receivable tracking. I converted their order history and the tool handled address extraction and batch processing for each account. Importing contacts first made the subsequent invoice imports match correctly.

Common Conversion Questions

Which deduplication method should I use?

eBay Username is most reliable - it's unique per buyer. Email works well but eBay may show masked addresses. Name-based deduplication is least accurate since the same person might ship to different names (gift orders, business vs personal).

Should I import contacts before or after invoices?

Import contacts FIRST if you want addresses and details. When you import invoices, Xero matches by name or creates basic contacts. Pre-importing gives you complete contact records with addresses.

How many contacts can I import?

Our tool handles unlimited contacts and automatically batches for Xero's import limits. Large exports are split into multiple files packaged in a ZIP.

Building Your Customer Database from eBay

eBay Doesn't Export Customers

Unlike other e-commerce platforms, eBay doesn't have a dedicated customer export. Your buyer information is scattered across order history. This tool extracts unique customers from orders and creates proper contact records for Xero.

Why Customer Data in Xero Matters

Having eBay customers in Xero enables invoicing repeat buyers, tracking sales by customer, creating quotes, and building marketing lists. It also speeds up invoice creation since contact info auto-fills from existing records.

Your Conversion is Secure

Browser-Only Processing

All conversion runs in your browser. Files are never uploaded to any server.

No Data Retention

Nothing is stored after conversion. Close the tab and your data is gone.

GDPR Compliant

Full EU data protection compliance. Your privacy rights are fully protected.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Field Mapping

How Ebay_Seller Orders fields map to Xero Contact

Ebay_Seller Orders	Source Value		Xero Contact	Target Value	Note
`Buyer name`	`John Smith`	→	`Name`	`John Smith`	Contact name (required)
`Buyer email`	`john@example.com`	→	`EmailAddress`	`john@example.com`	Primary email
`Buyer phone`	`+1-555-123-4567`	→	`PhoneNumber`	`+1-555-123-4567`	Phone (may be masked)
`Buyer username`	`john_buyer123`	→	`AccountNumber`	`john_buyer123`	eBay user ID as reference
`Ship to address 1`	`123 Main Street`	→	`SAAddressLine1`	`123 Main Street`	Shipping address
`Ship to city`	`New York`	→	`SACity`	`New York`	Shipping city
`Ship to state`	`NY`	→	`SARegion`	`NY`	Shipping state/region
`Ship to zip`	`10001`	→	`SAPostalCode`	`10001`	Shipping postal code
`Ship to country`	`US`	→	`SACountry`	`US`	Shipping country

Why Use This Converter?

Automatic Deduplication

Smart deduplication by username, email, or name prevents duplicate contacts.

Address Extraction

Captures shipping addresses from orders as contact street addresses.

eBay ID Reference

Stores eBay username as account number for easy customer lookup.

Name Parsing

Automatically splits full names into first and last name fields.

Batch Processing

Handles years of order history efficiently with Xero-compatible batching.

Browser Privacy

Customer data processes locally. Never uploaded to external servers.

Data Transformation

Multiple orders from same buyer become single contact

Order records with buyer info

Key columns: Buyer username, Buyer email, Buyer name

N:1 — Multiple input rows aggregate to one output row

Contact Record Deduplicated customer record

No duplicate contacts in output

Common Contact Import Errors

Issues you might encounter when importing Orders Report data to Contact - and how we solve them

Repeat Buyers in Export

Same buyer appears multiple times

john_buyer: 5 orders

john_buyer: 1 contact record

Deduplication keeps most recent info

All orders linked, but only one contact created

eBay Masked Email Address

eBay shows anonymized email

buyer123-abcd@members.ebay.com

Email field populated with masked address

Masked emails still work for eBay messaging

Update with real email if customer provides it

Phone Number Not Available

eBay may not export phone numbers

Buyer phone: (blank)

PhoneNumber: (empty)

Phone field left blank if not available

Add phone manually in Xero if needed

Same Person, Different Names

Buyer uses different shipping names

John Smith, J Smith, John D Smith

Deduplicated by username or email

Use username deduplication for accuracy

Merge contacts in Xero if needed

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.

No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

We keep the most recent address when deduplicating. In Xero, you can add multiple addresses to a contact if needed. The primary address will be the latest shipping address from your export.

eBay shows anonymized emails like buyer123@members.ebay.com for privacy. These still work for eBay messaging. Real emails may not be available unless customers provide them directly.

Import contacts FIRST if you want addresses and details. When you import invoices, Xero matches by name or creates basic contacts. Pre-importing gives you complete contact records with addresses.

Our tool handles unlimited contacts and automatically batches for Xero's import limits. Large exports are split into multiple files packaged in a ZIP.

Xero matches by exact name. New names create new contacts. Existing names may create duplicates unless you use Xero's 'Update existing contacts' option during import. Review matches carefully.

eBay doesn't provide a direct customer export, but buyer information is embedded in order history. Tools can extract unique buyers from your order history and format them for Xero import.

Buyer name maps to Contact Name, buyer email to Email Address, and shipping address details map to physical address fields. Phone numbers are also captured when available.

The tool uses automatic deduplication to identify repeat buyers by name and email. When the same customer purchases multiple times, it keeps one record with their most recent information.

The import process creates new contacts in Xero without modifying existing records. Only contacts matching exactly on name and email are considered duplicates.