Etsy Customers to Xero Contacts Converter

🥦

Convert Complete

Xero Contact CSV Format
valid rows

Convert your Etsy buyer list to Xero Contact CSV format. Build your customer database from sales history.

No API required
Browser-based processing
Run on Google Cloud Platform

Download Sample Etsy Export

Sample CSV to test contact extraction

Download Sample

Tool Rating

4.5 / 5 (256 votes)

How It Works

1

Export from Etsy

Download CSV Order Items from Etsy Shop Manager → Settings → Options → Download Data

2

Upload and Configure

Upload your orders CSV (contact info extracted from buyer and shipping fields)

3

Preview and Download

Review deduplicated contacts with addresses, then download Xero CSV

4

Import to Xero

Import to Xero via Contacts → Import

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

ISO/IEC 27001 Certified GDPR Compliant Swiss Privacy CCPA Compliant

Field Mapping

How Etsy_Seller Order_Items fields map to Xero Contact

Etsy_Seller Order_Items Source Value Xero Contact Target Value Note
Full Name John Smith → Name John Smith Contact name (unique in Xero)
First Name John → FirstName John Contact first name
Last Name Smith → LastName Smith Contact last name
Street 1 123 Craft Lane → POAddressLine1 123 Craft Lane Billing/postal address
Ship City Portland → POCity Portland City
Ship State OR → PORegion OR State/region
Ship Zipcode 97201 → POPostalCode 97201 Postal/ZIP code
Ship Country United States → POCountry United States Country
Currency USD → DefaultCurrency USD Default currency for transactions

Data Transformation

Multiple orders per buyer deduplicated to single contact

Input Etsy CSV Order Items

One row per item (may have same buyer multiple times)

Key columns: Full Name, Buyer, Ship Address
N:1 — Multiple input rows aggregate to one output row
Output Xero Contact deduplicated by name rows per input

One row per unique contact

Contact Unique contacts extracted from orders
Names must be unique in Xero

Why You Need to Import Contacts Before Invoices

The Xero Contact Matching Problem

When you import invoices to Xero, it tries to match the ContactName to existing contacts. If no match is found, Xero creates a new contact with just the name - no address or details. If the same customer ordered twice with slightly different names, you'll get duplicate contacts.

What This Tool Does

We extract unique customers from your Etsy orders and create proper Xero contacts: - Deduplication by customer name - Most recent shipping address preserved - First/last name extraction - Country code to full name mapping - Account numbers generated (ETSY-00001, etc.) Import contacts first, then invoices will match correctly.

Common Contact Import Errors

Issues you might encounter when importing CSV Order Items data to Contact - and how we solve them

Duplicate Contact Names

Xero requires unique contact names, Etsy may have duplicates

John Smith (appears in 3 orders)
John Smith (single contact with latest address)

Contacts are deduplicated, keeping most recent address

Review contacts in Xero after import

Missing Buyer Name

Some orders may not have Full Name populated

(blank name)
craftlover123 (Etsy username)

Falls back to Etsy username as contact name

Update contact names in Xero if needed

Same Buyer, Different Addresses

Buyer may have shipped to different addresses

John Smith: 3 different shipping addresses
John Smith: Most recent shipping address used

Uses most recent order's shipping address

Manually update addresses in Xero if needed

Why Use This Tool?

Automatic Deduplication

Same customer ordered 10 times? You get one contact with their most recent address.

Address Extraction

Shipping address from Etsy orders becomes postal address in Xero.

Name Parsing

Full names split into FirstName/LastName fields for proper Xero formatting.

Country Normalization

Country codes (US, GB, CA) converted to full names (United States, United Kingdom, Canada).

Account Numbers

Auto-generated account numbers (ETSY-00001) for easy reference.

Privacy-First Processing

Customer data processes locally in your browser. Never uploaded.

Frequently Asked Questions

Recommended. If contacts exist, invoice import will match them correctly. Otherwise, Xero creates minimal contacts (name only, no address).
We keep the most recent order's shipping address. You can update addresses in Xero later if needed.
If 'Full Name' is blank in Etsy export, we fall back to the Etsy username (Buyer field). These may need manual cleanup.
Xero's contact import updates existing contacts if Name matches exactly. New addresses will overwrite old ones.
Etsy doesn't include buyer email in CSV exports for privacy. Email field will be blank - you can add manually in Xero.

Etsy Seller → Xero Data Ecosystem

All available data flows from Etsy Seller to Xero

Etsy Seller CSV Order Items Etsy sold items with fees, taxes, shipping, and buyer details
→
Xero Contact Customer or supplier contact records
Full Name → Name First Name → FirstName Last Name → LastName
Customer sync, supplier management
Etsy Seller CSV Order Items Etsy sold items with fees, taxes, shipping, and buyer details
→
Xero Sales Invoice Sales invoices for accounts receivable (B2B, payment terms)
Order ID → InvoiceNumber Sale Date → InvoiceDate Full Name → ContactName
B2B sales, invoiced orders, payment terms
Etsy Seller Monthly Statement Etsy payment account statement with fees, deposits, and adjustments
→
Xero Bank Statement Bank transactions for reconciliation
Date → Date Net → Amount Type → Description
Payout reconciliation, fee tracking