The DIY Craft Stores Dashboard in Excel is a five-page analytical workbook that turns a flat sales export into a store-by-store, category-by-category and customer-by-customer picture of a craft retail business. It ships with 5 KPI tiles, 21 pivot charts, 25 pivot tables, 3 page-synced slicers and a 500-row sample dataset spread across 28 columns. Nothing is hard-coded — paste your own sales rows into the Data sheet, refresh once, and the whole workbook rebuilds around them.
Craft retail is deceptively hard to read. A yarn shop, a scrapbooking store and an art-supply counter can share a till and still behave like three different businesses: different margins, different discount habits, different customers, and in many shops a whole second revenue stream from paid workshops. A single turnover figure hides all of it. This Excel dashboard for craft retail exists to separate those threads without asking you to build a pivot model from scratch.
Key Features of the DIY Craft Stores Dashboard in Excel
- Five linked dashboard pages. Overview, Store Performance, Product Analysis, Sales Trends and Customer Insights, navigated by a hyperlinked sidebar rather than sheet tabs.
- Five KPI tiles on the Overview. Total Gross Sales, Net Gross Profit, Total Orders, Total Units Sold and an Average Customer Rating tile drawn as stars. In the shipped sample these read $99.8K, $33.4K, 500 orders, 4.5K units and 3.9 stars.
- Three slicers that filter all five pages at once. Month (Jan–Dec), Product Category (7 categories) and Store Name (8 stores) sit in a fixed panel on every page.
- Profit is calculated, not assumed. Three calculated pivot fields do the work: Gross Profit = Gross Sales − Discount Amount − Cost of Goods, plus Profit Margin and Completion Rate.
- Workshop revenue modelled separately. Class and workshop income is a first-class column, split by customer segment on the Customer Insights page — something generic retail templates almost never do.
- 25 pivot tables on a hidden-away Support sheet. Every visual is pivot-driven, so there are no volatile formulas to break when you paste new data.
- No macros and no add-ins. Native Excel pivot tables, pivot charts and slicers only. It opens in locked-down corporate environments where macro-enabled files are blocked.
Dashboard Pages Explanation
Page 1: Overview
The landing page. Five KPI tiles run across the top, followed by a Completion % gauge (80.4% in the sample), Total Orders by Product Category, Total Units Sold by Sales Channel and Completion % by Store Name. The sales-channel chart is the quiet star here: it separates In-Store, Online, Marketplace and Workshop Counter volume, which is the split most craft retailers argue about without data.
Page 2: Store Performance
Four views that rank your locations against each other: Total Gross Sales vs Total Cost of Goods by Store Name, Net Gross Profit by Store Name, Avg. Customer Rating by Store Name shown as star tiles, and Total Gross Sales by Region across Northeast, Midwest, Southeast, Southwest and West. Reading the profit chart against the rating chart is where the interesting arguments start — the best-loved store is not always the most profitable one.
Page 3: Product Analysis
The margin page. Total Gross Sales vs Cost of Goods by Product Category, Total Units Sold by Product Category, Net Gross Profit by Product Line across six ranges (CraftCore Basics, Artisan Select, BrightSpark Kids, Studio Pro, Heritage Handmade and EcoMake), and Total Discounts by Product Category. That last chart is the one buyers should read first: it shows exactly how much discount each craft category is absorbing.
Page 4: Sales Trends
The time view. Total Orders vs Completed Orders by Month, Total Gross Sales by Quarter, Total Orders by Order Status (Completed, Returned, Exchanged, Cancelled) and Returned Orders by Month. The sample data shows a clear Q3–Q4 climb into the gifting season, and a returns line that spikes in the same months — a pattern worth catching before it repeats.
Page 5: Customer Insights
Total Gross Sales by Customer Segment across Professional Crafter, Hobbyist, Workshop Group, Gift Buyer and Student; Total Orders by Membership Tier (Basic, Silver, Gold); Total Workshop Revenue by Customer Segment; and Total Orders by Spend Band. In the sample, workshop groups produce several times the class revenue of any other segment while placing far fewer product orders — two different businesses sharing one till.
The Data sheet and the Support sheet
Behind the five pages sit two working sheets. The Data sheet is a formatted Excel Table with 500 sample craft-retail orders across 28 columns — Sale Date, Store Name, City, Region, Product Category, Product Line, Sales Channel, Customer Segment, Membership Tier, Order Status, Units Sold, Unit Price, Gross Sales, Discount Amount, Cost of Goods, Shipping Cost, Workshop Revenue, Stock On Hand, Reorder Point and Customer Rating among them. The Support sheet holds all 25 pivot tables. You edit the first and never touch the second.
DIY Craft Stores Dashboard in Excel vs. a Google Sheets Build vs. Paid Retail Analytics SaaS — Feature Comparison
| Feature | DIY Craft Stores Dashboard in Excel | Google Sheets equivalent | Lightspeed Analytics / Zoho Analytics |
|---|---|---|---|
| Cost | $17.99 one-time | Free, but you build it yourself | $30–$149 / user / month |
| Platform | Excel 2016+ / 365, Windows & Mac | Browser only | Browser, vendor-hosted |
| Setup time | ✅ Under 10 minutes | Hours of formula and chart work | Days, plus POS integration |
| Works offline | ✅ Yes | No | No |
| Real-time team collaboration | Via OneDrive / SharePoint co-authoring | ✅ Native | ✅ Native |
| Mobile access | Excel mobile app (view) | ✅ Full | ✅ Full |
| Customisable fields & charts | ✅ Full — it is your workbook | ✅ Full | Limited to vendor schema |
| Workshop & class revenue tracking | ✅ Built in | Build it yourself | Rarely modelled |
| Year-1 cost at 5 users | $17.99 total | $0 + your build time | $1,800–$8,940 |
For craft retailers who want store, category and customer analysis without paying per seat every month, the DIY Craft Stores Dashboard in Excel sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Independent craft, yarn, scrapbooking and art-supply shop owners running 1–20 locations
- Multi-store craft retail managers who need to rank stores by profit rather than turnover
- Sellers who trade both in-store and through online marketplaces and want one combined view
- Craft studios running paid classes who need workshop revenue separated from product revenue
- Bookkeepers and analysts who already work in Excel and want a finished pivot model
Not a fit if:
- You need a live POS connection — this reads a data sheet you export or paste, it does not sync with Square or Shopify on its own
- You need per-user permissions, audit trails or SOC 2 compliance
- Your dataset runs past roughly half a million rows, where Power BI or a database performs better
- You want a single-page monthly scorecard with targets and traffic lights instead of five analysis pages
Real-World Use Cases
Maria owns three yarn and needlecraft shops. Every Monday she exports the week’s sales, pastes them into the Data sheet and refreshes. The Store Performance page showed her that the smallest shop had the highest average customer rating but the thinnest net gross profit — the rent-versus-footfall conversation she had been avoiding, finally with numbers attached.
Dev runs a scrapbooking and paper-craft store with a workshop room at the back. Customer Insights told him workshop groups drive far more class revenue than any other segment, so he doubled his weekend sessions and moved beginner classes into the slot the Sales Trends page identified as his quietest trading window.
Priya buys for an eight-branch craft chain. Comparing gross sales against cost of goods per category on Product Analysis, she found one range absorbing the largest share of the discount pool while shifting the fewest units. She dropped it and rebuilt the seasonal order around the two highest-margin product lines instead.
Advantages of the DIY Craft Stores Dashboard in Excel
It costs once. A retail analytics subscription at $30–$149 per user per month reaches $1,800–$8,940 in year one for a five-person team. This workbook is $17.99, forever, with no seat count.
It respects the data you already have. Almost every POS can export a CSV of sales lines. That export is the input — no integration project, no API keys, no waiting on a vendor’s connector roadmap.
It is genuinely yours to change. Add a column, add a chart, recolour the theme, rename every store. Because the visuals are ordinary pivot charts, anything you know about Excel applies. Microsoft’s own guide to slicers and PivotTable documentation are all the reference you need to extend it.
It works when the internet does not. Stock take in a back room with no signal, a market stall, a landlord meeting on a train — the file opens and the slicers still work.
Opportunities for Improvement
Honesty helps here more than hype. The workbook refreshes from a data sheet, so it is only as current as your last paste — there is no automatic nightly sync. If you want that, a Power Query connection to a folder of exports is a sensible next step, and the pivot model will happily sit on top of it.
Second, the sample dataset is 500 rows. It will handle tens of thousands comfortably, but past a few hundred thousand rows you will feel the refresh, and Power BI becomes the better home. Third, there is no forecasting layer — the Sales Trends page describes what happened, it does not project what will. And finally, stock is present as Stock On Hand and Reorder Point columns but is not the focus; if inventory is your main problem rather than sales analysis, a dedicated inventory template will serve you better.
Best Practices
- Keep the 28 column headers exactly as shipped. Rename the values inside the columns freely, but not the headers — the pivots bind to them.
- Paste as values. Pasting formatted cells from another workbook drags formatting into the Excel Table and can break the number formats on the KPI tiles.
- Refresh with Ctrl + Alt + F5 after every data change, not just F5. That refreshes all 25 pivot tables at once.
- Clear your slicers before sharing a screenshot. A filtered slicer on page 1 is still filtering page 5, and it is the most common cause of “these numbers look wrong”.
- Keep a raw copy of each export. The Data sheet is your working copy; keep the untouched CSV somewhere so you can rebuild a month if you need to.
- Add a Year column if you track multiple years, then add it to the slicer panel so the Month slicer does not blend two Januaries.
Explore Relevant Templates
- DIY Craft Marketplaces Dashboard in Excel — the online-marketplace sibling for Etsy-style selling; we covered it in detail in our post on the DIY Craft Marketplaces Dashboard.
- Art Supply Store Management System Web App — a full multi-user system with billing and stock when a workbook stops being enough.
- DIY Home Improvement Stores KPI Dashboard in Excel — the monthly target-and-traffic-light format; see our write-up of the DIY Home Improvement Stores KPI Dashboard.
- Craft Winery and Vineyard Dashboard in Excel and Garden Centers KPI Dashboard in Excel for neighbouring specialty-retail niches.
- Online Order Tracker Data Entry System in Excel — a lightweight form-driven companion if you are still capturing orders by hand.
Also available as: a Power BI build of the marketplace edition — the DIY Craft Marketplaces Dashboard in Power BI.
Frequently Asked Questions
What KPIs does the DIY Craft Stores Dashboard in Excel track?
The DIY Craft Stores Dashboard in Excel tracks 5 headline KPIs — Total Gross Sales, Net Gross Profit, Total Orders, Total Units Sold and Average Customer Rating — plus completion rate, profit margin, discounts, returns and workshop revenue across 21 charts on five pages. All of them recalculate from the Data sheet.
How long does setup take?
Under 10 minutes. Open the workbook, replace the 500 sample rows in the Data sheet with your own sales export using the same 28 column headers, then press Ctrl + Alt + F5. Every pivot table, chart and KPI tile in the DIY Craft Stores Dashboard in Excel updates automatically.
How does this compare to Lightspeed Analytics or Zoho Analytics?
Those platforms cost $30–$149 per user per month and need integration work before they show anything. The DIY Craft Stores Dashboard in Excel is a one-time $17.99 purchase, works offline, and delivers the same store, category and customer analysis without per-seat fees or a fixed vendor schema.
Do I need macros, add-ins or Power Query to use it?
No. The DIY Craft Stores Dashboard in Excel uses only native pivot tables, pivot charts and slicers. There is nothing to enable and nothing to install, which means it opens cleanly in corporate environments that block macro-enabled workbooks.
Which Excel versions does it support?
Excel 2016, 2019, 2021 and Microsoft 365 on Windows and Mac. Excel for the web will display the DIY Craft Stores Dashboard in Excel but does not drive slicers reliably, so use the desktop app for interactive filtering.
Can I add my own stores, categories and product lines?
Yes. The sample ships with 8 stores, 7 product categories and 6 product lines, but those are just values in the Data sheet. Type your own, refresh, and every chart, slicer and ranking in the DIY Craft Stores Dashboard in Excel rebuilds around your names.
Is this the same as a craft store KPI scorecard?
No. The DIY Craft Stores Dashboard in Excel is the analytical dashboard — five pages of store, product, trend and customer analysis. A KPI scorecard is a single-page monthly grid with targets and traffic lights. They answer different questions, and many shops end up using both.
About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Conclusion
Craft retail runs on thin margins, seasonal swings and a customer base that behaves nothing like general retail. The DIY Craft Stores Dashboard in Excel gives you five pages that read those differences directly — which store earns, which category is being discounted away, when returns spike, and which customer segment your workshop programme is actually built for — from a data sheet you can fill in ten minutes.
👉 Click here to Purchase the DIY Craft Stores Dashboard in Excel
Instant download · One-time payment · No subscription · Lifetime access
For step-by-step Excel dashboard tutorials, visit Youtube.com/@PKAnExcelExpert.
Last updated: September 2026
