How to Download Your CSV File from Etsy (Step by Step)
Etsy's built-in reporting is underwhelming — CSV exports are the workaround. Here's exactly how to download each file type and what to do with the data.
Last updated: March 2026
Etsy’s built-in reporting is underwhelming, and everyone knows it. You can see how many views a listing got, you can check your revenue for the month — but that’s about where it ends. There’s no breakdown of profit per product, no real picture of your costs, nothing that tells you whether you’re actually making money or just keeping busy.
CSV exports are the workaround. They won’t fix Etsy’s reporting gaps entirely, but they get your raw data out of Etsy’s walled garden and into a format you can actually work with. This guide walks through exactly how to download each file type, what the columns mean, and what you can realistically do with the data.
Need to get your orders and inventory in control?
Try Craftybase - the inventory and production solution for Etsy sellers. Track raw materials and product stock levels (in real time!), order management COGS, shop floor assignment and much more.
It's your new production central.
What is a CSV File?
A CSV (Comma-Separated Values) file is a plain text format that spreadsheet apps like Excel, Google Sheets, or Numbers can read. Each row is a record, each column is a field, separated by commas.
Etsy uses CSV for bulk data exports — listings, orders, payments, statements. The files are straightforward to open, but making sense of what’s inside is a different story. That’s what the rest of this guide covers.
The Four Types of CSV Etsy Offers
Etsy gives you four distinct exports, each pulling from a different part of your shop. They’re not interchangeable — you need to know which one you’re after before you start.
1. Listings CSV (Currently for Sale)
This is a snapshot of every active listing in your shop. It’s mainly useful for bulk edits — download, change what you need in a spreadsheet, then re-upload.
Key columns:
TITLE— your listing nameDESCRIPTION— full description textPRICE— current listed price (in your shop currency)QUANTITY— available stock at time of exportTAGS— up to 13 tags, pipe-separatedMATERIALS— materials listed on the itemSKU— your SKU, if you’ve added oneIMAGE1throughIMAGE10— image URLs
What it won’t tell you: cost to make, actual sales, or inventory consumed. It’s a listing catalogue, not a profit tool.
2. Orders CSV (Sold Transactions)
This is the most useful export for sellers trying to understand their sales. It contains one row per item sold, with the buyer’s order details.
Key columns:
Order ID— Etsy’s order reference numberItem— listing titleSKU— if you use SKUs (highly recommended — this is how you match orders to products)Quantity— units purchasedPrice— sale price per unitCoupon Code/Coupon Amount— discount appliedShip Name,Ship Address,Ship City,Ship State,Ship Postcode,Ship Country— buyer shipping infoTransaction ID— individual line item ID within the order
What you can do with it: Identify bestsellers, track order volume over time, reconcile with your Etsy bookkeeping, feed into spreadsheet-based COGS calculations.
What it can’t do: There’s no column for what it cost you to make each item. Your COGS has to come from somewhere else — your recipe costs, your material prices, your labour. The orders CSV only captures the revenue side.
3. Etsy Payments Sales CSV
This export breaks down your Etsy Payments transactions — what you were paid for, in what currency, with Etsy’s fees itemised. It covers a different angle than the orders CSV.
Key columns:
Date— transaction dateType— sale, refund, fee, etc.Title— listing titleCurrency— transaction currencyAmount— gross sale amountFee— Etsy transaction fee for that itemNet— amount after Etsy’s fee
What you can do with it: Reconcile with bank deposits, track Etsy’s transaction fees across a period, identify refunded orders. If you want a full picture of Etsy’s fees and how they eat into your margins, this is the export to pull.
4. Monthly Statements CSV
This is your full payment account summary for a given month — everything that went through Etsy Payments in one file. Sales, fees, taxes collected, shipping credits, adjustments.
Key columns:
Date— date of each transactionType— transaction type (sale, listing fee, transaction fee, shipping credit, etc.)Title— listing or activity nameInfo— order number or additional detailCurrency/Amount— transaction value
What you can do with it: Use it for Etsy bookkeeping and tax preparation. Hand it to your accountant. Reconcile with your bank deposits. This is the closest thing Etsy gives you to a financial statement.
How to Download a CSV File from Etsy (Step-by-Step)
All CSV exports live in the same place — your Shop Manager settings. Here’s how to get to each one.
Downloading Your Listings CSV
- Log into your Etsy account and go to Shop Manager.
- Click Settings in the left menu, then select Options.
- Select the Download Data tab.
- Under “Currently for Sale Listings,” click Download CSV.
The file downloads immediately — no email delay. It covers all active listings at the moment of download.
Downloading Your Orders CSV
- Go to Shop Manager > Settings > Options.
- Select the Download Data tab.
- Under “Orders,” use the two dropdowns to select:
- CSV Type — choose “Orders” for full order records, or “Etsy Payments Sales” for payment-level data
- Month and Year — pick the time period you want. Leave the month blank to download a full year.
- Click Download CSV.
A note on date ranges: Etsy only lets you download one month (or one year) at a time. If you need multiple months, you’ll need to run multiple downloads.
Downloading the Etsy Payments Sales CSV
Same path as orders:
- Go to Shop Manager > Settings > Options > Download Data.
- Under “Orders,” select “Etsy Payments Sales” from the CSV Type dropdown.
- Choose your month and year, then click Download CSV.
Downloading Your Monthly Statement
Statements are generated on demand — there’s a slight delay.
- Go to Shop Manager > Finances > Monthly statements.
- Click View all monthly statements.
- Select the year and month you want.
- Click Generate CSV.
- Wait for the email from Etsy, then click the download link in that email.
The email usually arrives within a few minutes. If you don’t see it, check your spam folder and make sure the email address on your Etsy account is current.
Pro tip: Name your files systematically — something like orders-2025-03.csv or statement-2025-q1.csv. Etsy’s default filenames are generic and become confusing fast when you have six months of exports sitting in a folder.
What Can You Actually Do with Etsy CSV Data?
Etsy CSVs are raw material, not finished analysis. Here’s where they’re genuinely useful — and where they fall short.
Analysing Sales Performance
Import your orders CSV into Google Sheets. Sort by Item and use a pivot table to see your top sellers by unit volume and revenue. Do this across multiple months and you’ll start to see seasonal patterns — which products spike in November, which ones crawl in January.
This is useful. But it’s revenue, not profit. Two products might generate identical revenue while one of them costs twice as much to make. The CSV won’t flag that.
Reconciling Etsy Fees
Pull your Payments Sales CSV alongside your bank statements. The Net column shows what Etsy paid you after their transaction fee. Add your listing fees (from the statement CSV) and you’ll have a clear picture of exactly what Etsy took. If you’ve been curious why your deposit doesn’t match your gross sales, this is where you’ll find the answer.
For a full breakdown of what each fee type is and how to calculate your actual margin, see our guide to Etsy fees.
Bookkeeping and Tax Preparation
Your accountant will want to know your gross revenue, Etsy’s fees paid, and how much tax Etsy collected on your behalf (if applicable). The monthly statement CSV has all of that in one file. Export one per month, label them clearly, and hand them over.
What’s missing: your COGS. Etsy has no idea what your materials cost, how long each item took to make, or what your packaging cost. You have to bring that data from somewhere else — a spreadsheet, a manufacturing tool, your receipts. Without COGS, you can tell your accountant what you sold but not whether you made money doing it.
Managing Orders and Order Fulfilment
The orders CSV can help you spot patterns in your fulfilment — order volumes by day of week, geographic distribution of buyers, orders where a discount was applied. If you’re managing order fulfilment manually, it can also serve as a working list.
The Limitations of Etsy CSV Data
Worth being direct about this: Etsy CSVs are a workaround, not a solution. Here’s what they can’t do.
No COGS data. Etsy has no idea what your materials cost. The orders CSV shows selling price but not the cost to produce. If you want to know whether you’re making a profit on each product, you need to calculate COGS separately — from your material costs, labour, and overheads — and merge that data manually. For a primer on how to do that calculation, see our guide to calculating COGS.
No inventory tracking. Downloading your listings CSV shows you quantities at a point in time. It doesn’t track what you’ve consumed in materials, what you’ve manufactured, or what’s actually sitting on your shelf right now. Etsy’s “quantity” is a number you type in — it doesn’t know what’s physically in your studio.
No automation. Every export is manual. If you need last month’s orders, you log in, go to settings, download a file. There’s no API access for regular sellers, no scheduled exports, no live data feed. If you want current data, you have to go get it.
Date ranges are limited. One month or one year at a time. Multi-year analysis means stitching together multiple CSVs in a spreadsheet.
Columns aren’t always intuitive. “Net” in the payments export doesn’t include your listing fees. “Amount” in the statement includes credits, debits, and adjustments mixed together. You need to read the column headers carefully and understand what’s actually being summed.
These limitations aren’t Etsy’s fault exactly — Etsy is a marketplace, not accounting software. But they do mean that CSV exports have a ceiling. They’ll get you part of the way. For full visibility into your costs, margins, and inventory, you need additional tools.
Frequently Asked Questions
How often can I download CSV files from Etsy?
As often as you like — there's no download limit. The listings CSV and orders CSV download instantly. Monthly statements require Etsy to generate a file first, which typically takes a few minutes before you receive the download link by email. Most sellers download orders monthly at a minimum, and statements each month for bookkeeping.
Can I automate Etsy CSV downloads?
Not directly through Etsy — regular sellers don't have API access to schedule exports. The downloads are always manual. If you want automated order syncing, you need a tool that connects to Etsy via the official API. Craftybase does this — it pulls your Etsy orders automatically each night, so your sales data is current without you having to log in and download anything.
Why is my Etsy CSV blank or showing no data?
A blank CSV usually means one of three things: you selected a time period with no orders, your shop doesn't use Etsy Payments (some older shops use PayPal only, which won't appear in the Payments exports), or you opened the file without a spreadsheet app — some browsers display raw CSV text that looks like garbage. Try opening the file in Google Sheets by importing it, rather than double-clicking. If statements are delayed, check the email address on your Etsy account — the download link goes there.
What's the difference between the Orders CSV and the Monthly Statement CSV?
The Orders CSV covers individual transactions — what sold, to whom, for how much. It's the file to use for sales analysis and order management. The Monthly Statement is a financial account summary — it includes everything that affected your Etsy Payments balance for that month: sales, fees, refunds, shipping credits, adjustments. Use the orders CSV to understand your sales; use the statement for bookkeeping and handing to your accountant.
Does Etsy's CSV include my cost of goods sold?
No — and this is the biggest gap. Etsy's CSV exports only capture the sale side: what you sold, when, and for how much. Your cost of goods sold — materials, labour, packaging, overhead — has to come from your own records. Most sellers have to manually merge their Etsy revenue data with a separate spreadsheet tracking costs. Tools like Craftybase handle this automatically by tracking your material costs and calculating COGS as orders come in.
What Etsy’s CSV Shows vs. What You Actually Need
Etsy’s CSV shows you what sold. Craftybase shows you what it cost to make it.
That gap matters more than most sellers realise. You can have a brilliant month of sales on Etsy — record revenue, lots of orders — and still be losing money if your material costs are high, your prices are off, or your Etsy fees are eating deeper than you think.
Craftybase connects directly to your Etsy shop and pulls your orders automatically — no manual CSV downloads, no stitching together spreadsheets. As orders come in, it tracks your material usage, calculates the real cost per product, and gives you COGS figures that are ready for tax time. It also keeps your material inventory current, so you know what you have on hand without counting shelves.
The CSV workaround gets you part of the way. If you want the full picture — revenue and costs, sales and inventory — that requires connecting your Etsy data to your actual production records. That’s what Craftybase is built for.
Start a free 14-day trial — no credit card required.
