An essential oil inventory spreadsheet makes it easier to keep track of the oils you own, the bottles you have already opened, and the products you may need to replace. Instead of relying on memory, you can record each oil's name, quantity, purchase date, storage location, and relevant shelf-life information in one place.
Whether you have a few favorite oils or a growing collection, a simple inventory system can help you organize essential oils, avoid unnecessary duplicate purchases, and find the bottle you need without searching through several drawers or boxes. The key is to create a system that connects your digital records with your physical storage space.
Why Keep an Essential Oil Inventory?
As your collection grows, it becomes easier to forget which oils you already own, how much remains in each bottle, and when you purchased them. An inventory gives you a reliable reference point before your next shopping trip.
Avoid buying oils you already own
Check your stock before buying another bottle of lavender, frankincense, or peppermint. You might have an unopened bottle tucked away somewhere or even a partially used one that will suit you.
A record of the oil name, bottle size, and remaining quantity helps you distinguish between an oil you need to replenish and one you simply haven't used recently.
Keep track of quantities and usage
An inventory can show which oils are nearly empty and which have barely been used. This is especially useful if you own several individual oils alongside pre-made blends.
You can also record which oils you reach for most often, helping you decide which bottles deserve a more accessible place in your storage area.
Keep purchase and shelf-life information accessible
Keep notes like purchase dates, opening dates and manufacturer shelf-life directions – these are all helpful to have on hand. They assist in checking on other bottles with time, rather than using memory or presuming that all oils have the same shelf life.
For information about shelf life, see Gya Labs' guide to whether essential oils expire and how to increase their shelf life.
How to Create an Essential Oil Inventory Spreadsheet
You don't need complicated inventory software to get started. Google Sheets, Microsoft Excel, or another spreadsheet application can work well. Start with a single sheet and add fields as your collection grows.
1. Add these columns
|
Column |
What to record |
|
Oil name |
The name on the bottle |
|
Brand |
Who made it |
|
Type |
Single oil, blend, or carrier oil |
|
Bottle size |
For example, 10 ml or 15 ml |
|
Amount left |
Full, three quarters, half, quarter, or nearly empty |
|
Purchase date |
When you bought it |
|
Opening date |
When you first opened it |
|
Shelf life (years) |
From the label, or the guide below |
|
Check by |
Calculated from the opening date (see step 3) |
|
Storage location |
Drawer, box, shelf, or fridge |
|
Status |
In stock, running low, buy again, or check |
|
Notes |
Batch number, favorite uses, or recipes |
If you have a small collection, start with just oil name, amount left, opening date, storage location, and status.
2. Use filters and simple status labels
Filters are a great way to help you search for specific oils without having to scroll down through the entire sheet. For example, you could filter by brand, oil type, or where you store your oils.
Keep the status labels consistent. For example:
-
In stock: You have enough for your current needs.
-
Running low: You may need to replace the oil soon.
-
Buy again: You've decided a replacement is necessary.
-
Review: Check the bottle's age, condition, or product guidance before deciding what to do next.
You can make use of the colours within the spreadsheet also to identify these statuses, but keep the write-ups clear to ensure the system is not dependent on the colours.
3. Add a practical example
Suppose you own a bottle of Frankincense Essential Oil. An illustrative inventory entry might look like this:
| ield | Example Entry |
|---|---|
| Oil Name | Frankincense Essential Oil |
| Oil Type | Single Essential Oil |
| Original Bottle Size | Enter the size printed on your bottle |
| Quantity Remaining | Approximately half |
| Purchase Date | 15 June 2026 |
| Opening Date | 1 July 2026 |
| Storage Location | Essential Oil Box, Compartment 2 |
| Restock Status | In Stock |
| Notes | Review the supplier's shelf-life guidance when needed |
Note: The dates and quantities above are hypothetical examples. Enter the actual details for your bottle and purchase history.
How to Organize Essential Oils Physically
A spreadsheet is most useful when it matches the way your bottles are arranged. If your records say an oil is in a particular drawer but you moved it to another box, finding it can become just as frustrating as having no inventory.
Group oils by category
Categories will depend on what you want to do. For example, you can organize your essential oils as: – individual oils vs blends vs carrier oils. You can even organize your bottles by how often you use the oil.
If you own a growing range of individual oils, the Gya Labs Essential Oil Singles collection provides a useful reference for the category. Carrier oils can be recorded separately using the Gya Labs Carrier Oil collection.
Avoid creating too many categories at the beginning. A few clear groups are easier to maintain than a complicated system with overlapping labels.
Assign each bottle a storage location
Give each storage area a consistent name, such as:
-
Drawer A
-
Storage box 1
-
Shelf B, section 2
-
Travel case
Enter the location name you used in your spreadsheet. Locations are not interchangeable -- if you move a bottle, change the location to keep your inventory accurate.
Keep labels easy to identify
Store bottles so you can read their labels without having to remove every item. Keep any personally prepared blends clearly labelled with their contents and preparation details where appropriate.
Follow the storage instructions supplied with each product, and avoid keeping bottles in places exposed to direct sunlight or excessive heat.
How to Store Essential Oils and Track Shelf Life
Organizing your collection isn't only about finding bottles. It also helps you keep track of older products and review their condition and storage history.
Record information that helps you review older oils
While the purchase and opening date can help inform a judgement, they do not necessarily determine whether the oil is okay to use. Shelf life ranges by oil and product so note any date or expiry advice given by the manufacturer, rather than a blanket expiry date across your collection.
During an inventory review, look at the bottle label, packaging, and guidance given by the supplier. If you observe any different appearance or aroma, do not consider that a simple difference is evidence of the oil being incorrect for your use.
For a more detailed explanation, read Do Essential Oils Expire? Explained With Tips To Increase Shelf Life.
Organize your storage conditions
Keep bottles tightly closed when not in use and follow the manufacturer's storage recommendations. A designated storage area also helps reduce the likelihood of bottles being misplaced or exposed to unsuitable conditions.
Your spreadsheet can include a short storage note if a product has specific instructions. This is more useful than assuming every essential oil should be stored in exactly the same way.
How to Prevent Duplicate Purchases and Know When to Restock
The most practical use of an inventory is checking it before placing an order. Rather than buying based on memory, use the spreadsheet to make a more informed decision.
Check your inventory before shopping
Before adding an oil to your shopping cart, follow these steps:
-
Type the name of the oil in the search field. Verify if the oil is already existing.
-
Check the volume left. There is a possibility the bottle you already have can last for your needs.
-
Check the product information. Make sure the bottle is the oil or blend you actually want.
-
Check the use-by or expiry dates and guidance. If you have any old bottles of disinfectant, check with the manufacturer or supplier about whether you should keep using them.
-
Update your shopping list. Add the oil only if you've decided that a replacement is needed.
This process is particularly helpful when two bottles are stored in different places or when you own both individual oils and blends containing similar ingredients.
Create a simple restock rule
Determine what "running low" means on your own shelf. You might decide that you need to limit the frequency you add certain oils when they get used up. For oils you don't use all the time, you may want to check what you need and then replace.
Avoid automatically restocking every bottle that reaches a particular level. Your usage habits, storage history, and the product's condition should all inform the decision.
How Often Should You Update Your Essential Oil Inventory?
An inventory works best when updates take very little effort. You don't need to conduct a full stocktake every time you use a bottle.
Use this simple routine:
-
After a purchase: Add the oil, brand, bottle size, and purchase date.
-
When filling a bottle: Note the date it was filled.
-
For correcting bottle placement: Change bottle's storage location.
-
Periodically review: old stocks, quantities left and any other manufacturer guidance.
-
Before shopping: Review the inventory and restock list.
If you have very few oils, a weekly or bi-weekly quick scan should be enough to keep them organized. You may need to do more if you have many oils. Select a schedule you can stick to consistently.
Final Thoughts
An essential oil inventory spreadsheet can help you keep up with your collection by consolidating bottle information, stock levels, location, and restock choices in one document. You can begin with the oils you have on hand, fill in the information you already know, and update your spreadsheet whenever you open, add, or move a bottle. With a simple and easy way to keep track of everything, you'll rest easier knowing you can access your oils when needed and think more clearly when it's time to restock.
