Etsy CSV Export: How to Download Your Orders Report in 6 Steps
We walk you through how to get the sales and order data you need from Etsy's reporting and downloading options — updated for the current Etsy Shop Manager interface.
For many small business owners, Etsy has become the go-to platform for selling handmade goods, vintage items, and craft supplies. But its built-in analytics only scratch the surface.
Etsy doesn’t provide detailed financial reports natively. If you want a real picture of your revenue, orders, or customer data, a CSV export is the most reliable workaround. This guide walks you through exactly how to download your Etsy sales reports as CSV files, updated for the current Shop Manager interface.
Ready to take your Etsy store to the next level?
Discover how Craftybase is the Etsy accounting software you've been missing out on: track raw materials and product stock, expenses and revenue, COGS, pricing and much more. It's your bookkeeping BFF.
Why You Should Download Your Etsy Sales Data Regularly
Keeping a close eye on your order data isn’t just good practice. It’s essential for a healthy maker business.
Track your sales performance: By reviewing your data over time, you can identify seasonal spikes, slow periods, and which product categories are growing. Without this information, you’re making decisions blindfolded.
Simplify tax time: Your orders CSV is the foundation for Schedule C and COGS calculations. Having clean, complete data before tax season saves hours of scrambling. (If you’re just getting started on cost tracking, our guide to tracking COGS on Etsy walks through the full calculation.) For a broader look at keeping your Etsy finances in order year-round, see our Etsy bookkeeping guide.
Manage inventory better: Order reports show which items are selling quickly and which aren’t moving. That helps you decide what to restock, what to make more of, and what to phase out.
Understand your customers: Detailed order data reveals repeat buyers, purchase patterns, and seasonal demand. All of this is useful for planning your production schedule and promotions.
How to Download Your Etsy Orders Report
The orders CSV export lives in Shop Manager → Settings → Options → Download Data, where you select your report type and date range before downloading.
Here’s the full step-by-step using the current Etsy interface:
Step 1: Open Etsy Shop Manager
Log in to Etsy. Click your account icon in the top-right corner, then select Shop Manager from the dropdown. Alternatively, go directly to etsy.com/your/shops/me/dashboard.
Step 2: Navigate to Settings → Options
In the Shop Manager left sidebar, scroll down and click Settings. From the submenu that appears, click Options.
Step 3: Click the Download Data Tab
On the Options page, you’ll see a row of tabs: Info & Appearance, Billing, Download Data, and others. Click Download Data.
This is the page where Etsy lets you export your raw shop data as CSV files.
Step 4: Select Your Report Type
Under What type of CSV would you like to download?, choose the report that matches what you need:
- Orders: one row per order, with columns for order number, buyer name, total amount, and payment status. Best for bookkeeping and revenue totals.
- Order Items: one row per individual item within each order, showing product name, quantity, and price. Best for analysing which products are selling.
Tip: For COGS and tax calculations, start with the Orders report. If you need a per-product sales breakdown, download Order Items as a second pass.
Step 5: Set Your Date Range
Use the Month and Year dropdowns to select the period you want. To capture a full calendar year, leave the Month dropdown as the default and set the Year to whichever year you need.
Etsy lets you download data month by month or a full year at a time. If you need multiple years, you’ll need to run a separate download for each one.
Step 6: Download the CSV
Click Download CSV. Etsy generates the file and saves it to your computer. Once downloaded, open it by double-clicking or using File → Open in your spreadsheet program. Excel, Google Sheets, or Apple Numbers all work fine.
For a full walkthrough of every CSV file type Etsy offers (listings, statements, payments, and more), see: How to download your CSV file from Etsy.
Understanding the Two Main Report Types
Once you’re on the Download Data page, it’s worth understanding what each report actually contains:
| Report | Best for |
|---|---|
| Orders | Revenue totals, tax prep, payment reconciliation |
| Order Items | Per-product sales counts, bestseller analysis |
| Listings | Your active and inactive product catalogue |
| Payments | Etsy deposit details and payout timing |
For most makers, Orders and Order Items are the two you’ll return to most often. The others are useful for specific tasks, like reconciling your bank account against Etsy deposits.
What Columns Are in the Etsy Orders CSV?
The Etsy Orders CSV includes columns for order ID, order date, buyer name, shipping address, items ordered, item subtotal, shipping cost, transaction fees, order total, and payment status.
Here’s a breakdown of the key fields you’ll use most often:
| Column | What it shows |
|---|---|
| Order ID | Unique reference number for each transaction (useful for customer service lookups) |
| Order date | The date and time the sale was placed |
| Items purchased | Product name(s) included in the order |
| Order value | The amount the buyer paid before Etsy fees |
| Shipping | Postage charged to the buyer |
| Coupon code applied | Whether a discount code was used and the value |
| Transaction fees | Etsy’s cut from the sale |
| Payment type | How the buyer paid (Etsy Payments, PayPal, etc.) |
| Buyer name | Customer’s name and shipping address |
| Payment status | Completed, pending, or cancelled |
Tax prep tip: Focus on the Order value, Shipping, and Transaction fees columns. These map directly to gross receipts, shipping income, and deductible selling expenses on your Schedule C.
The Order Items CSV adds extra columns for specific product variants, SKUs, and per-item prices. This is useful when a single order contains multiple different products.
Making the Most of Your Etsy Data
Once you have your CSV files, here’s how to actually put the data to work:
Identify your best sellers: Sort the Order Items CSV by product name and count how many times each one appears. The items appearing most often are where your production focus should be.
Calculate revenue by period: Use a pivot table or SUMIF formula to group revenue by month. This reveals seasonal patterns that let you plan your production schedule and materials ordering months in advance.
Prepare for tax time: Your Orders CSV contains the gross revenue figures you need for Schedule C. Keep in mind it won’t include your materials costs. That part you’ll need to calculate separately or track in a dedicated tool.
Monitor payment status: The Orders report includes a payment status column. Any orders still marked as pending or incomplete should be followed up before you close out a financial period.
How to Use Your Etsy CSV in Craftybase
Once you have your CSV files, you have two ways to bring that data into Craftybase:
Manual CSV import: Download your Orders CSV and import it directly into Craftybase. This works well for a one-time data migration or if you’re setting up your records for the first time. You’ll match each line item to the products and materials in your account.
Automatic Etsy sync: Connect Craftybase to your Etsy shop and your orders pull in nightly with no CSV required. Materials costs are allocated, COGS is calculated per sale, and your reports are always current without you having to do a thing.
For most makers, the automatic sync is the better long-term option. The manual CSV approach is a useful starting point, but it’s not something you want to repeat every month.
Craftybase’s Etsy accounting features include inventory management, recipe-based cost tracking, and profit analysis. So you see what each sale actually costs you to make, not just what it sold for.
If you want to understand how your Etsy sales data fits into the bigger bookkeeping picture, our Etsy bookkeeping guide covers the full process from order tracking to tax prep.
Try Craftybase free — no credit card required →
Frequently Asked Questions
What file format does Etsy use for sales data exports?
Etsy exports sales data as a CSV (comma-separated values) file, which opens in any spreadsheet program: Microsoft Excel, Google Sheets, or Apple Numbers. Each row represents one order or one line item, depending on the report type you select.
What's the difference between "Orders" and "Order Items" exports on Etsy?
The Orders report has one row per transaction (best for revenue totals and bookkeeping). The Order Items report has one row per individual product sold (better for analysing which specific items are selling). For tax purposes, start with Orders. For product performance analysis, use Order Items.
Can I download Etsy order data for a specific date range?
Etsy's Download Data tab lets you filter by month and year before exporting. You can download a single month or a full year in one file. For data spanning multiple years, you'll need to run a separate download for each year and then combine the files in your spreadsheet program.
Does the Etsy CSV include my COGS or profit figures?
The Etsy CSV only shows what each order sold for, not what it cost you to make. To calculate COGS, you need your materials cost, labour, and overhead per product. Most Etsy sellers either calculate this manually in a spreadsheet or use software like Craftybase, which tracks materials and calculates COGS per sale automatically.
What columns are included in the Etsy orders CSV download?
The Etsy Orders CSV includes Order ID, order date, buyer name, items purchased, order value, shipping cost, transaction fees, coupon codes, payment type, and payment status. The columns you'll use most for tax purposes are order value, shipping, and transaction fees. These map to gross receipts, shipping income, and deductible selling expenses on your Schedule C.
Does Craftybase automatically sync my Etsy orders?
Craftybase syncs with Etsy nightly, automatically importing your orders without any manual CSV exports. Once connected, your sales appear in Craftybase with materials costs deducted, COGS calculated, and reports ready to go. Start a free trial at craftybase.com/pricing (no credit card required).
