A Free Nail Polish Collection Spreadsheet Template
If you searched for a nail polish collection spreadsheet, here is one you can build in five minutes, for free, and an honest look at where a spreadsheet stops keeping up with a growing stash.
A spreadsheet is a fine place to start. It is free, you already know how to use it, and it makes you write down what you own. The trick is tracking the right columns from day one, so you are not redoing it at bottle two hundred.
The columns that actually matter
The classic collector’s sheet is Brand, Shade, Color, Finish and Untried. That is a good spine. Here is the version worth copying:
- 1Brand and Shade name in two columns, so you can sort and search each one.
- 2Color family (red, teal, nude) and Finish (creme, shimmer, holo), the two things you actually filter by.
- 3Status: owned, wishlist, or untried. The most useful column and the one people skip. It turns the sheet into a list you can shop.
- 4Swatch link. A spreadsheet cannot really hold a photo, so paste a link to one. This is where sheets start to hurt (more below).
- 5Date added and a swatch number if you number your sticks or palettes, so you can go from “this one” to finding it in a drawer.
- 6Notes: two coats or three, stamping polish, a gift, anything the columns above do not capture.
Copy this starter sheet
Open a blank sheet in Google Sheets or Excel and paste this as the top row:
Brand · Shade · Color · Finish · Status · Swatch link · Date added · Swatch # · Notes
Freeze that first row, make Status a dropdown (owned, wishlist, untried), and you have a working tracker. Sort by Color to see your gaps, filter Status to “untried” to shop your own shelf, and check the sheet before you buy. That is most of the value right there.
Where the spreadsheet starts to hurt
Every collector’s sheet dies for the same three reasons:
- Photos do not travel. A column of pasted links is unusable on your phone in a store aisle, which is exactly where you need the swatch.
- Typing is friction. Adding a bottle should take ten seconds. A sheet makes you type every field by hand, so you fall behind and stop.
- It cannot warn you. A sheet will never say “you already own this.” It holds what you typed and nothing more.
For most people this hits somewhere between fifty and a couple hundred bottles, when the collection is too big to hold in your head and the sheet is too slow to keep up. We wrote about that exact moment in the 50-bottle tipping point.
When to graduate to an app
You outgrow the sheet when the friction costs more than it saves. A good app keeps everything the sheet had (brand, shade, color, finish, status, notes) and fixes the three problems above: you add a bottle from a photo instead of typing, the swatch lives with the entry and travels to your phone, and it flags exact duplicates before you buy. If you would rather skip the sheet from the start, see how to organize without a spreadsheet.
Further reading: the collectors of r/RedditLaqueristas trade spreadsheet setups constantly; it is where most of these columns come from.