Guide · Storage & aging
Cigar Inventory Spreadsheet: The Columns to Use, and When to Switch to an App

A cigar inventory spreadsheet needs about twelve columns: brand, line, size, wrapper, origin, quantity, price paid, date bought, where it is stored, date smoked, rating, and notes. One row per purchase, three formulas, and you can see what you own, what it cost, and how long it has been resting.
I am not going to hand you a file to download, because the file is not the hard part. Any spreadsheet you set up in ten minutes will work for the first thirty cigars. What matters is choosing columns you will still fill in six months from now, and knowing the point where a spreadsheet starts costing you more time than it saves.
I should say that I make a humidor app, so I have an interest in where this ends up. I will lay out the spreadsheet properly first, since for plenty of people it is the right answer, and be specific about where it falls short and where the app does too.
The columns worth keeping
Start with fewer columns than you think you need. Every extra column is one more thing to type each time you buy cigars, and the spreadsheets that die are the ones that asked for too much.
The twelve below split into three groups. The first group identifies the cigar. The second tracks the stock, which is the reason the spreadsheet exists. The third is your opinion, filled in after you smoke one. If twelve feels like a lot, the stock columns are the ones you cannot skip.
A note on size: write the vitola name and the dimensions together, like Robusto 5 x 50, so you can sort and still know what you are looking at. And put the date bought in a real date format, not text, or the aging formula below will not work.
| Column | What goes in it | Why it earns its place |
|---|---|---|
| Brand | Padron, Oliva, Arturo Fuente | The first thing you sort and filter by |
| Line | 1964 Anniversary, Serie V | A brand makes many cigars; the line is the one you actually liked |
| Size | Robusto 5 x 50 | The same blend smokes differently in different sizes |
| Wrapper | Maduro, Connecticut, Habano | The fastest way to spot what you tend to enjoy |
| Origin | Nicaragua, Dominican Republic | Useful for patterns, and for filtering |
| Quantity | A number, reduced by one each time you smoke | The reason the sheet exists |
| Price paid | Per cigar, not per box | Lets the sheet total your collection's value |
| Date bought | A real date, like 2026-03-14 | Drives the resting-time formula |
| Location | Desktop humidor, cabinet, tupperdor | Only if you store cigars in more than one place |
| Date smoked | The most recent one | Shows what you have not touched in a year |
| Rating | Your own scale, used the same way every time | Tells you what to rebuy |
| Notes | One line in your own words | The detail the rating cannot hold |
The three formulas that do the work
A list of cigars is a list. Three formulas turn it into an inventory. These work the same in Google Sheets and Excel.
Total cigars on hand. Sum the Quantity column. If quantity is column F, that is =SUM(F2:F500). This is the number you will be surprised by.
Value of the collection. Multiply quantity by price for each row and add it up in one step with =SUMPRODUCT(F2:F500, G2:G500), where G is price paid per cigar. It is what you paid, not what the cigars would sell for, and it is the honest number to keep.
Months resting. In a new column, =DATEDIF(H2, TODAY(), "M") gives the whole months since the date bought in H2. Copy it down the column. Sort by it and the cigars that have had their time rise to the top.
One optional extra: conditional formatting that turns the Quantity cell red when it drops to 1. That is your running-low warning, and it takes thirty seconds to set up.
How do I track how long cigars have been aging in a spreadsheet?
Put the purchase date in its own column as a real date, then add a column with =DATEDIF(H2, TODAY(), "M") where H2 is the purchase date. It returns the whole months since you bought the cigar and updates every time you open the sheet.
How do I calculate the value of my cigar collection?
Record the price you paid per cigar and the quantity on each row, then use =SUMPRODUCT on the two columns. It multiplies each row and totals the result, so the figure stays correct as you smoke cigars and reduce the quantities.
One row per purchase, not one row per cigar
The decision that trips people up is what a row means. There are two sensible answers and one bad one.
One row per purchase is the version I would use. Five Padron 2000 Maduros bought in March is one row with a quantity of 5. If you buy five more in September, that is a second row, because they have a different date and maybe a different price. Your aging numbers stay honest that way.
One row per cigar line, with the quantity bumped up when you restock, is simpler but loses the purchase dates. It is fine if you do not care about aging.
One row per individual cigar is the bad one. It feels thorough for a week and then you have 140 rows and you stop opening the file.
When you smoke the last cigar on a row, do not delete it. Set the quantity to 0 and keep the rating and notes. A year from now the rows at zero are the most useful part of the sheet, because they are the record of what you thought.
Where a spreadsheet stops working
A spreadsheet is good at arithmetic and bad at the moment you actually need it. Here is where it tends to give out.
It is a desk tool. You smoke on the patio and buy in a shop, and editing a twelve-column sheet on a phone is miserable. So updates wait until later, and then they do not get made at all. A sheet that is three weeks behind is a sheet you no longer trust.
Every field is typed by hand. Wrapper, origin, size: you look each one up and type it, and you will spell Arturo Fuente three different ways, which quietly breaks your sorting.
It holds one opinion per row. Smoke the same cigar four times over a year and you have one Rating cell to put four experiences in.
And there are no photos. When you are trying to remember which cigar a row refers to, a picture of the band does more than any column.
None of that matters at twenty cigars. It usually starts to matter somewhere past fifty, or the first time you buy a box you already had.
Spreadsheet or app: an honest comparison
Here is how the two compare on the things that decide whether an inventory survives. The app column describes Cigarista, since it is the one I can vouch for. Other apps differ, and several keep data on your device with no account, which is closer to the spreadsheet's strengths.
The short version: a spreadsheet wins on control and cost, and you own the file outright. An app wins on entry speed and on being in your pocket when you are holding a cigar. Cigarista's humidor is free with no cap on cigars, so the cost column is closer than it looks. The real tradeoff is that the app needs an account and, today, has no spreadsheet import or export. If having your data in a file you fully control is the priority, stay with the sheet.
| Spreadsheet | Cigarista humidor | |
|---|---|---|
| Cost | Free | Free humidor and wishlist; paid plan for extra AI scans and taste features |
| Adding a cigar | Type every field | Search a 17,000+ cigar catalog or photograph the band; specs fill in |
| Updating on your phone | Awkward | Built for it |
| Aging time | A DATEDIF formula you maintain | Automatic from the day you log the cigar |
| Running low | Conditional formatting you set up | Flagged automatically |
| Collection value and stats | Formulas you write | Built in |
| Repeat smokes of one cigar | One rating cell per row | A separate dated entry for each smoke |
| Photos | No | Yes |
| Your data as a file | Yes, it is the file | No import or export yet |
| Account required | No | Yes, that is what syncs it across devices |
Common questions
Is there a free cigar inventory spreadsheet template?
You can make one in ten minutes without downloading anything. Create columns for brand, line, size, wrapper, origin, quantity, price paid, date bought, location, date smoked, rating, and notes. Add a SUM for total cigars, a SUMPRODUCT of quantity and price for collection value, and a DATEDIF from the purchase date for months resting. That covers what the downloadable templates do.
What should I track in a cigar inventory?
At minimum: what the cigar is (brand, line, and size), how many you have, and when you bought it. Price paid is worth adding because it lets you total the collection's value. A rating and a one-line note, filled in after you smoke one, are what make the inventory useful for deciding what to buy again.
Should I use Excel or Google Sheets for a cigar inventory?
Google Sheets, for most people, because it is free and opens on your phone without syncing a file around. The formulas in this guide are identical in both. Use Excel if you already live in it or want the file to stay on your own computer.
Is an app better than a spreadsheet for tracking cigars?
It depends on the size of the collection and where you update it. Under about fifty cigars, updated at a desk, a spreadsheet is fine and you own the file. Past that, or if you want to log a cigar while you are smoking it, an app is faster because it fills in the specs, tracks aging on its own, and works on a phone. The cost of an app is usually an account and less direct control over your data.
Can I import a spreadsheet into Cigarista?
Not today. There is no import or export, so moving a collection over means adding the cigars through catalog search or by scanning bands. Catalog search is free and unlimited, so it does not use up scans, but it is manual work and you should know that before you start.
Explore the catalog
Start browsing the catalog
Every line, its specs and sizes, and what members have logged.
Keep reading
More guides like this
Tired of typing wrappers into cells?
Cigarista's humidor fills in the specs from a catalog of 17,000+ cigars, tracks aging on its own, and totals what the collection is worth. The humidor is free, with no limit on cigars.

