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 Sales Invoice?

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

How do I import Etsy csv order to Xero Sales Invoice?

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

Etsy to Xero Invoice Converter

🥦

Xero Sales Invoice CSV Format

valid rows

Convert Etsy CSV Order Items to Xero Sales Invoice format in seconds. No API, no subscription, no sync issues.

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

Download Sample

Tool Rating

4.7 / 5 (169 votes)

How to Convert Etsy Orders → Xero

Export from Etsy Seller

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

Upload and Configure

Upload CSV Order Items CSV and choose Sales Invoice format

Preview and Download

Review converted data, download Xero-ready file

Import to Xero

Business → Invoices → Import → Upload CSV

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

How People Use Etsy Orders → Xero

I was manually typing Etsy sales into Xero every month and it took forever. The converter handles multi-item orders perfectly, grouping line items under the same invoice number. I converted 3 months of backlog in under 5 minutes and my Xero sales records are finally current.

Several of my clients sell on Etsy and need invoices in Xero for proper revenue tracking. The region-aware date formatting is critical since my UK clients use DD/MM/YYYY. Converting Etsy CSV order items to Xero invoice format saves me from reformatting dates row by row.

My orders often have multiple prints per transaction and the converter creates proper multi-line invoices that Xero groups automatically. The ETSY- prefix keeps my invoice numbers unique, and marketplace tax exclusion means I do not record liability for tax Etsy already remits.

Etsy Orders → Xero Conversion Questions

What Etsy export do I need?

Download 'CSV Order Items' from Shop Manager → Settings → Options → Download Data. This contains all sales with line-item detail.

How are multi-item orders handled?

Each item becomes one invoice line. Items with the same Order ID share the same InvoiceNumber, so Xero groups them into one invoice.

What about Etsy fees?

This tool focuses on recording sales revenue. For fee tracking and bank reconciliation, use our Etsy Payments → Xero Bank tool.

Why Use the Etsy Orders → Xero Converter?

No API or App Required

Works with standard Etsy CSV exports. No OAuth, no Etsy API keys, no third-party apps.

Instant Conversion

Upload → Preview → Download. No waiting for sync cycles or API rate limits.

Multi-Item Order Support

Etsy exports one row per item. We create proper multi-line invoices that Xero groups automatically.

Region-Aware Date Formatting

Converts Etsy dates to UK (DD/MM/YYYY) or US (MM/DD/YYYY) format based on your Xero settings.

Marketplace Tax Handling

Etsy collects and remits tax in many jurisdictions. Choose to exclude or record for 1099-K matching.

Browser-Based Privacy

Small files process locally in your browser. Your data never leaves your computer.

Why Etsy Orders Don't Import Cleanly to Xero

The Multi-Line Order Problem

Etsy exports one row per item sold. A single order with 3 products becomes 3 rows. Xero requires specific formatting with repeated header fields for multi-item invoices. Additionally, Etsy dates like "Jan 15, 2026" don't match Xero's expected DD/MM/YYYY or MM/DD/YYYY format.

What This Tool Does

We transform Etsy orders into Xero-compatible invoice format: - Multi-item orders → Proper line-item invoices (same InvoiceNumber groups items) - Date conversion to your Xero region format (UK/AU/NZ or US) - ETSY- prefix prevents duplicate invoice numbers - Shipping as separate line item - Marketplace tax handling (exclude or record for 1099-K)

Field Mapping

How Etsy_Seller Order_Items fields map to Xero Invoice

Etsy_Seller Order_Items	Source Value		Xero Invoice	Target Value	Note
`Order ID`	`3001234567`	→	`InvoiceNumber`	`3001234567`	Order number with ETSY- prefix
`Sale Date`	`Jan 15, 2026`	→	`InvoiceDate`	`Jan 15, 2026`	Date converted to DD/MM/YYYY or MM/DD/YYYY
`Full Name`	`John Smith`	→	`ContactName`	`John Smith`	Buyer name for invoice
`Item Name`	`Handmade Ceramic Mug - Blue Glaze`	→	`Description`	`Handmade Ceramic Mug - Blue Glaze`	Product description
`Quantity`	`2`	→	`Quantity`	`2`	Quantity ordered
`Price`	`25.00`	→	`UnitAmount`	`25.00`	Unit price
`Order Sales Tax`	`4.62`	→	`TaxAmount`	`4.62`	Marketplace tax (optional)
`Currency`	`USD`	→	`Currency`	`USD`	ISO currency code

Your Etsy Orders → Xero 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.

Data Transformation

Each Etsy order item becomes one Xero invoice line

One row per item sold

Key columns: Order ID, Item Name, Price, Quantity

1:1 — One input row creates one output row

One row per invoice line (Xero groups by InvoiceNumber)

Invoice Line Each item becomes one invoice line

Items with same Order ID grouped into same invoice by Xero

Common Sales Invoice Import Errors

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

Invalid Date Format

Etsy uses 'Jan 15, 2026' format which needs conversion

Jan 15, 2026

15/01/2026 (UK) or 01/15/2026 (US)

Our converter automatically transforms dates to your Xero region format

Select your Xero region in options

Duplicate Invoice Numbers

Xero requires unique InvoiceNumbers, Etsy Order IDs might conflict

12345678 (bare number)

ETSY-12345678 (prefixed)

ETSY- prefix added automatically to prevent duplicates

Prefix is added by default

Missing Buyer Name

Xero requires ContactName, some Etsy orders may lack names

(blank name)

Etsy Customer

Falls back to Etsy username or 'Etsy Customer' generic name

Generic contact created if name missing

Marketplace Tax Confusion

Etsy collects/remits tax - not your liability to record

Order includes $4.62 tax Etsy collected

Tax excluded (Etsy remits it)

By default, marketplace-collected tax is excluded

Use 'record' tax mode if you need 1099-K matching

Multi-Item Orders

Orders with multiple items need multiple invoice lines

Order 123 with 3 items

3 invoice lines with same InvoiceNumber

Xero's line-item format is natively supported

Each item becomes one invoice line (Xero groups by InvoiceNumber)

More credits - more savings

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

Frequently Asked Questions

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.

Download 'CSV Order Items' from Shop Manager → Settings → Options → Download Data. This contains all sales with line-item detail.

Each item becomes one invoice line. Items with the same Order ID share the same InvoiceNumber, so Xero groups them into one invoice.

This tool focuses on recording sales revenue. For fee tracking and bank reconciliation, use our Etsy Payments → Xero Bank tool.

In most jurisdictions, Etsy collects and remits sales tax directly (marketplace facilitator). Recording it as your liability would overstate your tax obligation.

Check your Xero organization settings. UK, AU, NZ, and most EU countries use DD/MM/YYYY. US organizations use MM/DD/YYYY.

Yes! Use the Tracking Category option to add 'Channel: Etsy' to all imported invoices for reporting.

The ETSY- prefix (enabled by default) prevents conflicts with other invoice sources. Xero requires unique invoice numbers.

Third-party tools like A2X, Webgility, and PayTraQer often provide more reliable syncing, better customization, and automatic fee categorization than manual methods. They're worth using if you have regular Etsy sales.

Etsy applies a 2.5% currency conversion fee on international sales. Integration tools can auto-match exchange rates, but manual reconciliation may be needed for minor discrepancies in your bank feed.

Yes, most integrations let you choose between per-order transactions or daily summaries. Daily summaries reduce clutter and are easier to reconcile with bank deposits.