Skip to main content

Craft Store Inventory Tracker in Craft & Hobby Store

A suggested spreadsheet layout for craft & hobby store work, tracking skus, department, on hand, cost, margin.

Last updated: August 2026

We haven’t built a ready-made workbook for this one yet. The templates below do the same job, with formulas and sample data, and you can download them today. The suggested columns are further down if you’d rather build your own.

Build your own

Suggested columns for “Craft Store Inventory Tracker”

Format: No ready-made file yet (column guide)Columns: 5

Columns to start with

  • SKUs
  • Department
  • On Hand
  • Cost
  • Margin
  1. Copy the column list and paste it into cell A1 of a new Google Sheet or Excel workbook.
  2. Split it into columns: Google Sheets Data → Split text to columns; Excel Data → Text to Columns (comma).
  3. Or skip the setup and start from one of the working templates on this page.

Review evidence

What to verify before choosing Craft Store Inventory Tracker

Use the review criteria below to decide whether this template fits your workflow.

Review criteria

  • +SKU by department and supplier
  • +On hand, cost, and retail
  • +Margin per SKU
  • +Low-stock flags

Often worth considering when

  • +Craft stores tracking SKUs and margin
  • +Anyone managing many small items

Pause before choosing when

  • -Barcode POS scanning
  • -Vendor catalog lookup

About Craft & Hobby Store

Why people consider this option

  • +Track inventory, classes, and sales without paid software
  • +Keep every SKU and class roster in a file you own
  • +Know your margin per SKU and per class

What to review before acting

  • -No barcode POS or class-booking portal without a tool
  • -Multi-store shops eventually need retail software

Trust FAQ

Questions people ask before copying a template

Does the Craft Store Inventory Tracker work in both Google Sheets and Excel?
Yes. It is built with standard functions and no macros, so it opens and works the same in Google Sheets or Microsoft Excel — on desktop or your phone.
Is the Craft Store Inventory Tracker really free?
The core template is free to copy and use. There is no paid tier — copy the suggested columns into a new sheet, or start from one of the working templates on this page.
What does the Craft Store Inventory Tracker track?
It tracks skus, department, on hand, cost, margin. The suggested columns are listed in order; add totals or highlights with basic formulas like SUM once your data is in.