Etsy orders to dashboard

Etsy sales, with the dates read the American way.

Download the orders CSV from Etsy Shop Manager and drop it here. Two things get fixed on load: the Sale Date column is in MM/DD/YY form and is read as American rather than guessed at, and Price is per unit so it is multiplied by Quantity before anything is ranked. Discount Amount, Shipping Discount and Order Sales Tax are kept separate from what you actually earned.

Prefer the full explorer? Open the app, or start from the generic dashboard builder.

American dates handled

MM/DD/YY is parsed as month first, with the two-digit year resolved sensibly.

Per-unit prices multiplied

Price times Quantity, reconciled against Item Total so a mismatch would show.

Discounts kept separate

Discount Amount and Shipping Discount are subtractions, not revenue.

Nothing uploaded

Buyer names and ship-to cities stay inside your browser tab.

Small file, two very specific landmines

Etsy's order download is one of the cleaner ecommerce exports. It is small, the column names are in plain English, and there is no preamble junk at the top. The problem is that its two most important columns are both quietly ambiguous. Sale Date is written as 03/09/26, which is the ninth of March to most of the world and the third of September to a US reader, and Etsy means the latter. A two-digit year does not help either.

Price is the second one. It is the price of one unit, not the line value, so a two-quantity order for a fifteen dollar candle shows Price 15.00 and Item Total 30.00. Rank your products by Price and you have ranked them by how expensive they are, not by how much they earned, which is the sort of chart that leads a shop to discontinue its bestseller. This page multiplies before it ranks and uses Item Total to check itself.

How to export from Etsy

Open Shop Manager Sign in at etsy.com and click the Shop Manager icon at the top right. If you run more than one shop from the same account, switch to the right one before you go anywhere near the download screen.
Go to Settings, then Options In the left sidebar of Shop Manager choose Settings, then Options. The tabs across the top of that page include Download Data, which is where every Etsy CSV lives. It is not under Orders, which is where most people look first.
Pick the Orders CSV type The dropdown offers Order Items, Orders, Direct Checkout Payments and a few others. Order Items gives one row per item with the item name and SKU on it, which is the shape this page is written for.
Choose a month and year Etsy downloads one calendar month at a time, or a whole year if you leave the month blank. A quarter therefore means three files, and the year option is the easier route if you want a trend worth looking at.
Download and drop the file The CSV downloads immediately, no email step. Drop it here and Item Name becomes the first breakdown, with Ship Country feeding the map.

If you took the Orders CSV rather than Order Items, you get one row per order with no item detail. Both load fine here, but the product panels only appear on the Order Items version.

Try with sample Etsy data (the same columns, 98 rows, no upload needed).

What the dashboard shows

Every panel below is built from a column that is actually in the export, named the way Etsy names it.

Sales over time. Sale Date parsed as month first becomes the axis, with Item Total summed. A daily view usually shows the weekend lift that Etsy shops live on.
Bestsellers by revenue. Item Name ranked by Price times Quantity rather than by Price, which is the difference between what sells and what is expensive.
Discount cost. Discount Amount and Shipping Discount summed against Item Total, so the real cost of running a sale event is one number rather than a feeling.
Shipping paid against shipping given away. Order Shipping collected next to Shipping Discount, which for a lot of shops is close to a wash.
Where the orders go. Ship Country on the map, Ship State ranked below it, and Ship City available when you want to know whether one metro carries you.
SKU coverage. How many rows have a SKU at all, which for most handmade shops is an uncomfortable answer and worth seeing.

Sample header row

Sale Date,Order ID,Item Name,Buyer,Quantity,Price,Coupon Details,Discount Amount,Shipping Discount,Order Shipping,Order Sales Tax,Item Total,Currency,Transaction ID,SKU,Ship City,Ship State,Ship Country

What to watch in an Etsy download

Dates are MM/DD/YY. Month first, two-digit year. Any reader guessing from your locale will misread every day of the month below the thirteenth, which is about forty percent of the calendar, and it fails silently.
Price is per unit. Item Total is the extended value. Use Price only when you want the list price of a product; use Item Total or Price times Quantity whenever you are adding money up.
Order-level columns repeat per item. Order Shipping and Order Sales Tax belong to the order and appear on each of its item rows. Group by Order ID before summing either of them or a three-item order pays postage three times.
Order Sales Tax is not yours. Etsy collects and remits marketplace facilitator tax in most US states and the EU. It appears in the file, it passes through you, and counting it as income overstates a US-heavy month.
Coupon Details is free text. It carries a human readable description of the promotion rather than a clean code, so it groups badly. Discount Amount is the column to trust for the numbers.
Buyer is a display name. It is the Etsy username or display name, not a stable customer identifier, and it can change. Repeat-buyer analysis from this column is approximate at best.

Read the dates as American, multiply before you rank, and keep sales tax out of your income. Do that and this export is genuinely pleasant to work with, which is more than can be said for most marketplaces.

Frequently asked questions

Why are my Etsy dates out by several months?

Because Sale Date is written month first, in MM/DD/YY form, and your spreadsheet is probably guessing day first based on your machine's regional settings. The two agree only when the day is above twelve, so roughly six days in ten come out wrong and nothing warns you. This page reads the column as American, which is what Etsy actually writes, regardless of where you are sitting.

Should I use Price or Item Total?

Item Total, whenever you are adding money together. Price is the unit price and stays the same whether the buyer took one or six. Item Total already accounts for quantity. If you rank products by Price you get a list sorted by how expensive your catalog is, which tells you nothing about what people are buying and can lead to some genuinely bad decisions about what to stock.

Does the Etsy CSV include fees?

No. The orders download covers what buyers paid you: item price, shipping, tax and discounts. Listing fees, transaction fees, payment processing and any advertising spend live in the separate payment account CSV, which you download from the same Download Data screen. If you want true profit per order you need both files, and joining them on Order ID is the usual approach.

How do I get more than one month at a time?

Leave the month dropdown empty and pick just a year, which downloads the whole year in one file. Otherwise you get one CSV per calendar month and a quarter takes three downloads. If you already have several monthly files, merge them before loading so the trend chart is continuous, then check for duplicate Order ID values at the month boundaries.

Why is the sales tax figure so large?

Because Etsy operates as a marketplace facilitator, which means it collects sales tax and VAT on your behalf in most US states and across the EU, and remits it directly. The Order Sales Tax column shows the amount collected, but that money was never yours. It also repeats on each item row of a multi-item order, which can double or triple the apparent figure if you sum the column raw.

Is my buyer list private here?

Completely. The file is read by JavaScript in your browser and never sent anywhere. An Etsy order export lists buyer names alongside the city and state they had things shipped to, which is exactly the sort of file you should not paste into an unfamiliar web tool. There is no server here to receive it and no account to sign up for.