Etsy CSV Files: Listings, Orders, and Stock Exports

Etsy’s Bulk Language Is CSV

Etsy sellers in the US, UK, Canada, Australia, and EU use CSV for bulk listing edits, order downloads, and stock updates. The templates are strict: wrong headers, broken variation rows, or Excel-mangled SKUs send you into edit-and-reupload loops during peak seasons.

Always start from Etsy’s current template or an export from your own shop — not a generic product spreadsheet.

Which Etsy CSV Are You Working With?

Do not mix listing and order schemas.

Step-by-Step: Bulk Edit Listings via CSV

The highest-traffic seller workflow.

• Export your listings CSV from Etsy (or download the official blank template).
• Open a copy in the Online CSV Editor — keep a raw archive untouched.
• Edit only columns you understand; leave listing IDs intact for updates.
• Preserve variation structure: parent/child style rows must stay consistent with Etsy’s rules.
• Save UTF-8 CSV so £, €, and accented titles survive.
• Re-upload; read the error report row-by-row; fix and retry failed lines only.
• Spot-check live listings for price and quantity after processing completes.

listing_id,title,description,price,currency_code,quantity,tags,materials,sku
221122,Handmade Mug,Stoneware mug...,28.00,USD,12,"mug,pottery,gift",stoneware,MUG-BLUE-01

Orders CSV for Fulfillment and Books

Order exports feed shipping stations and accountants.

• Export orders for the shipment window you need (not “all time” if the file is huge).
• Keep Order ID and Transaction ID as text.
• Separate gift messages and buyer notes into columns you will not paste into public tracking uploads.
• For bookkeeping, remember Etsy fees and advertising are often in separate reports — orders CSV alone is not net profit.
• UK/AU/EU VAT-registered sellers: use Etsy’s tax documentation alongside CSV; do not invent VAT columns on listing files.

Order ID,Sale Date,Buyer,Ship Name,Ship City,Ship Country,Quantity,Price,SKU
1234567890,2026-05-03,jdoe,Jane Doe,Austin,United States,1,28.00,MUG-BLUE-01

Variations, SKUs, and Quantities

Where bulk CSV edits usually break.

• Each purchasable variation needs a stable SKU if you sync inventory elsewhere.
• Do not collapse variation rows into one cell with commas — Etsy expects structured columns/rows per template.
• Quantity edits on the wrong row leave one size in stock and another at zero.
• Leading zeros in SKUs die in Excel — format as text or edit outside Excel.
• Currency_code must match the listing’s shop currency expectations.

Excel and Encoding Traps for Etsy Sellers

Handmade titles are UTF-8 stress tests.

• Prefer CSV UTF-8 exports; verify curly apostrophes and é/ñ/ü characters.
• German and EU sellers editing on de-DE Excel: watch semicolon saves — convert back to comma CSV before Etsy upload if required.
• UK sellers: £ in descriptions is fine in UTF-8; ANSI saves corrupt symbols.
• Never open-and-save a CSV in Excel without checking SKUs and long IDs afterward.
• Image URL columns must remain valid absolute URLs; line breaks inside cells break rows.

Multi-Marketplace Shops (Etsy + Shopify + Amazon)

Common in US/UK growth shops.

• Keep a master inventory CSV keyed by SKU; push quantities outward carefully.
• Etsy listing IDs are not Shopify product ids — maintain a mapping sheet.
• Price parity: remember Etsy fees differ from Shopify/Amazon when setting retail.
• Clean exports per channel; do not upload a Shopify product CSV into Etsy.

Regional Shops: US, UK, AU, CA, EU

Same CSV tools; different compliance and shipping fields.

• Ship Country and state/province codes must match Etsy’s expected names/codes.
• AU/UK address lines often need county/region fields handled carefully for carriers.
• EU sellers: profile and VAT settings live in Etsy account configuration — CSV cannot fix a missing VAT number.
• Date fields on order exports may follow locale; normalize for QuickBooks/Xero imports.

Common Mistakes

Peak-season failures.

• Editing listing_id values “to be tidy.”
• Uploading an Excel .xlsx renamed to .csv.
• Tag lists that exceed Etsy’s limits or use forbidden separators.
• Deleting columns Etsy still expects (even if empty).
• Re-uploading the entire catalog when only 20 rows failed.
• Using order export columns in a listing template.

Best Practices

Treat Etsy CSV like production code.

• Version your listing CSV in dated folders before each bulk run.
• Change one concern per upload (prices XOR tags XOR quantities) when possible.
• Validate with a 3–5 listing pilot upload.
• Keep SKUs unique across variations.
• Edit in a browser tool when Excel keeps destroying IDs.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Preview Etsy listing and order files in the Online CSV Editor, convert to Excel for teammates, and fix delimiter issues from European Excel before upload. Works on Windows, macOS, and Linux browsers for sellers worldwide.

Conclusion

Etsy CSV bulk tools save hours when templates, variations, and UTF-8 encoding stay intact. Export from Etsy, edit carefully, pilot upload, then scale — especially across US, UK, AU, CA, and EU shops with different tax and address realities.