Cosmetic & Bath Product Testing Template – Stability Tracker & Development Spreadsheet for Makers

Product Development & Stability Testing Template

For Bath, Body, Cosmetic & Perfume Makers

Developing new products properly means keeping clear records of your tests, results and improvements. This Product Testing Template is designed to help makers organise their development process and track how formulas perform over time.

Perfect for small batch cosmetic makers, this spreadsheet helps you record test batches, gather tester feedback, monitor stability and track product development — all in one place.

Whether you're developing bath salts, scrubs, lotions, soaps or perfumes, this template keeps your testing organised and easy to review.

What’s Included

This downloadable spreadsheet includes several organised sheets to support your product testing process:

Product Test Record

• Log each test batch

• Record formula versions

• Add batch numbers and assessment references

• Document observations, issues and improvements

Tester Feedback Sheet

• Collect structured feedback from testers

• Record scent strength, texture and skin feel

• Gather packaging feedback and purchase interest

Stability Tracking

• Monitor products over time

• Includes checkpoints for

  • Day 1

  • Week 1

  • Week 2

  • Week 4

  • Week 6 (ideal for perfume maceration)

  • Week 8 (extended maceration checks)

Development Tracker

• Track how many versions of a product you’ve tested

• See tester feedback totals

• Monitor stability test logs

• Record development decisions (continue, revise or finalise)

Customisable Lists

• Add your own product types

• Dropdown menus update automatically

• Easy to adapt for different product ranges

Features

✔ Colour-coded stability checks
✔ Structured tester feedback
✔ Editable dropdown lists
✔ Development tracking dashboard
✔ Works in Microsoft Excel
✔ Compatible with Google Sheets

Perfect For

• Bath & body makers

• Cosmetic formulators

• Perfume makers

• Handmade product businesses

• Product development records

Important Information

This is a digital download.
No physical product will be shipped.

After purchase you will receive the spreadsheet file which can be opened in Excel or uploaded to Google Sheets.