Home/Spreadsheets/Small Business/Etsy Shop Dashboard

Etsy Shop Dashboard

An Excel dashboard that reads the Order Items CSV you download from Etsy and turns it into a one-page view of your shop, compared with the period before. It opens in Microsoft Excel, has no macros and nothing to install, and is yours to reuse as often as you like.

What it does

Paste Etsy's Order Items CSV; the dashboard fills itself (up to 5,000 item rows)
KPI cards for net revenue, orders, average order value and repeat buyers vs the prior period
Revenue by product line, grouped by simple name rules or by Listing ID; nothing drops out of the totals
Top 10 listings, coupons used and where orders ship
3, 6 or 12 month window and an optional monthly goal
Buyer names and addresses stay in your file; the Dashboard shows totals only
Opens in Excel

$14.99one-time, no subscription

Buy on Etsy

Instant digital download · one-time purchase · no subscription

Etsy Shop Dashboard — the workbook open in Excel

See it in action

What it looks like

Every tab in the workbook

These are the actual sheet names in the file, in order, read out of the workbook itself.

Getting Started
Dashboard
Setup
Listings
Import

Works in

Microsoft Excel 2016 or later on Windows or Mac; Microsoft 365 recommended
Not for Google Sheets or Apple Numbers
No macros

Honest scope

This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.

Others in Small Business

Etsy Shop Dashboard$14.99Buy on Etsy