Oil Inventory & Blend Log
Type the date you opened a bottle and see its expiry, days left and status. An essential oil inventory for Excel and Google Sheets.
- Instant download after checkout
- A4 and US Letter, print or fill on screen
- A safety note on every recipe
What you get
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
- Open in Excel or make your Google Sheets copy
- Check Settings, then type your bottles with the date opened
- 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
Natural still needs amounts and care. Patch test new skin products, keep oils and herbs away from small children, and ask a doctor or pharmacist first if you are pregnant, breastfeeding, take medicines or have a health condition.
The Essential Oils Bundle
How many drops in a 10 ml roller? 2 at 1 %, 4 at 2 %. The Essential Oils Bundle has the chart, the blends and the safety rules.
- EbookEssential Oils Without the Hype
- Ebook100 Diffuser Blends
- EbookEssential Oils Room by Room
- PrintableEssential Oil Dilution Chart
- SpreadsheetOil Inventory & Blend Log
- PrintableBlend Recipe Cards
Before you buy
How do I get the file?
Checkout opens on our store. After payment you get the download link straight away and by email.
Which sizes are included?
Printables come in A4 and US Letter. Ebooks are PDF and work on phone, tablet and computer.
Can I get a refund?
This is a digital download, so all sales are final. Read the description and the inside preview before you buy.