What Etsy export file format does this tool accept?

This tool accepts Etsy CSV Order Items files. Export from Etsy and upload the Items file directly.

Can I convert Etsy CSV to Xero Contact?

Yes, this tool converts Etsy CSV Order Items exports directly to Xero Contact CSV format compatible with Xero Contact.

How do I import Etsy csv order to Xero Contact?

Export your csv order from Etsy, upload the CSV file to this converter, then import the converted file to Xero Contact.

Etsy Customers to Xero Contacts Converter

🥦

Xero Contact CSV Format

valid rows

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

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 Etsy Export

Sample CSV to test contact extraction

Download Sample

Tool Rating

4.5 / 5 (85 votes)

How to Convert Your File

Export from Etsy Seller

Shop Manager → Settings → Options → Download Data → Order item → Download CSV

Upload and Configure

Upload CSV Order Items 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 needed to import my Etsy customers to Xero before converting invoices. The deduplication caught repeat buyers automatically and kept the most recent shipping address for each. Country codes converted to full names so my Xero contacts looked professional.

I always convert contacts before importing invoices for my clients. The tool extracts unique buyers from Etsy orders, splits names into first and last fields, and generates ETSY- prefixed account numbers. Xero matches invoices to contacts perfectly on the first import.

My repeat customers were showing up as duplicates in Xero because I was importing invoices without contacts first. Converting my Etsy buyer list to Xero contact format with automatic deduplication fixed the problem. Each customer now has one clean record with their address.

Common Conversion Questions

Do I need to import contacts before invoices?

Recommended. If contacts exist, invoice import will match them correctly. Otherwise, Xero creates minimal contacts (name only, no address).

What if the same customer has different addresses?

We keep the most recent order's shipping address. You can update addresses in Xero later if needed.

What about email addresses?

Etsy doesn't include buyer email in CSV exports for privacy. Email field will be blank - you can add manually 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.

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 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

Why Use This Converter?

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.

Data Transformation

Multiple orders per buyer deduplicated to single contact

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

One row per unique contact

Contact Unique contacts extracted from orders

Names must be unique in Xero

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

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.

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.

Yes, export your Etsy customer data as CSV, map the columns to Xero contact fields, then use Xero's import tool or a third-party service to bulk upload all contacts at once.

Etsy doesn't collect buyer phone numbers. Contact buyers directly through Etsy Messages to request this information before importing.

No, you need to manually review and merge duplicate contacts in Xero after import. Use Xero's merge contacts feature to clean up duplicates.

Yes, ensure Xero's multi-currency feature is enabled and international addresses are properly formatted for accurate contact creation and invoicing.

Sync regularly based on your sales volume—weekly or monthly is typical. Set up a recurring schedule to keep contact data current without creating duplicates.