Oil Inventory & Blend Log — Spreadsheet

You open the oil box and find two lavenders, a lemon you think you opened last spring and a tea tree that smells sharper than it used to. You made a roller everyone loved and cannot remember what went in it. And you just bought another peppermint you did not need.

This spreadsheet keeps your oils and blends in one place. Type the date you opened a bottle and it shows the expiry date from a typical shelf-life table for that oil family, the days left, a clear status (OK, Use soon, Expired, Not opened) and the cost per ml. Write your blends with the carrier and the target %: it works out the drops, checks that your oils add up and checks the % against a safe limit for the face, body, roller, bath or room spray. A shopping list totals what to buy now. Formula cells are locked, a full Example shows how it works, and it opens in Excel, Google Sheets and Numbers.

Who it is for

• Anyone with more than a handful of essential oils and carrier oils
• People who make rollers, body oils, bath and diffuser blends at home
• Anyone who wants to stop using old oils on skin and stop buying duplicates

What's inside

• Start Here tab: 3 steps, colour key, how the numbers work
• Example tab: 15 bottles, 8 blends, shopping list, 3 charts
• Settings: currency, date format, drops per ml, use-soon warning, shelf-life table, % limit for each use
• Oil Inventory (60 rows): expiry, days left, status, cost per ml + status chart
• Blend Recipes (50 rows): target drops, check, actual %, safety check + chart
• Shopping List (40 rows): subtotals, buy-now total, oils to replace
• Quick Start PDF: open it, tab by tab, tips, printable inventory and blend log (filled + blank)

How to use it

1. Open in Excel or make your Google Sheets copy
2. Check Settings, then type your bottles with the date opened
3. Write your blends and let the sheet check drops and %

Formats

• Excel workbook (.xlsx) with working formulas and charts
• Opens in Google Sheets (File → Import) and Numbers
• Printable PDF guide with blank log pages, A4 and US Letter

At a glance: 6 tabs · auto expiry + status · 5 charts · Excel + Google Sheets

Part of The Essential Oils Bundle: https://naturalknows.com/the-essential-oils-bundle/

Digital download · All sales final