Free tool

Contact lens inventory spreadsheet

A contact lens inventory needs one row per box: the eye it is kept with, the power and other parameters printed on it, the sealed packs left, the expiration date, and the lot number. Enter your boxes below and the sheet checks each one against your prescription, counts the days of wear each eye has left, gives you a date to reorder by, and saves the whole sheet as a CSV file for Excel, Google Sheets or Numbers.

Nothing you type leaves your browser. Last reviewed 2026-11-14. Prescription rules come from 16 CFR Part 315, the FTC Contact Lens Rule, and the label fields from FDA's device labeling rules and manufacturer package inserts.

1. Your prescription

Copy the values from your contact lens prescription, not a glasses prescription. Each box is compared with the eye you enter it under, then with the other eye. Not sure what a field means? The prescription decoder translates each one.

Right eye (OD)
Left eye (OS)

2. Boxes on hand

One entry per carton, or per group of loose packs that share a lot and a date. Count the sealed packs, one lens each, and type what the box says rather than what you expect it to say. Product, BC and DIA can stay blank if you only want the power checked.

Box 1
Box 2

3. How you wear and reorder

Arrival time is your own estimate for the seller you use. Include prescription verification, shipping, and a margin for a backorder. Fourteen days is a starting figure, not a measurement of any seller.

Enter a pack count for at least one box to see each eye's supply, the reorder date, and the check on every box. To fill it in by hand instead, download the blank sheet above: it has the same columns and opens in any spreadsheet app.

The sheet tracks the boxes. Keep the open supply split by eye.

A Sturdysight organizer is a paired set of hard-shell cases, one labeled L and one labeled R, for the sealed daily-disposable blister packs you are working through. Packs stand upright and stay separated by eye, so a right eye pack does not end up in the left eye's pile and the count is a glance. It is waterproof and fits all brands of daily-disposable blister packs. It holds sealed packs only, never a bare lens or solution, and it is not a soaking case.

Shop Medium on Amazon

Not sure which size? Use the case size finder.

What goes in each column, and where it is printed

Almost everything the sheet asks for is printed on the carton or the foil. The exceptions are which eye the box is for and where you keep it. CooperVision's fitting guide for clariti 1 day lists what that lens's blister label carries: the base curve, the diameter, the power, the cylinder and axis on toric lenses, the add on multifocals, the manufacturing lot number, and the expiration date. Cartons repeat the parameters and carry a lot of their own, which can be a different number from the one on the foil.

Contact lens inventory columns, where each value is printed, and why it matters
ColumnWhere to find itWhy the sheet asks
Kept withNothing on the carton or the foil says right or left. The eye is whichever pile you keep the box in.Each box is compared with that eye's prescription first. A box that matches the other eye moves to the other eye's count and is flagged.
ProductFront of the carton: the brand and the lens name.FDA's advice is to check that you receive the exact brand and lens name you were prescribed. A seller may not swap in another brand, apart from an identical private label lens made by the same company.
PWRCarton and foil, in diopters. Some labels say SPH or D. Minus powers correct nearsightedness and plus powers correct farsightedness.The value most likely to differ between your two eyes, and between one exam and the next.
BC and DIACarton and foil, in millimeters.A quick product check. clariti 1 day, for example, is made in one base curve, 8.6, and one diameter, 14.1.
CYL, AXIS and ADDToric lenses print a cylinder and an axis. Multifocals print an add, as a power or as a word such as LOW, MED or HIGH.Two toric boxes can share a power and differ only in axis. Turn the fields on and the sheet compares them.
Sealed packs leftCount the blisters. Each one holds one lens.One sealed pack is one day of wear for one eye. The run out and reorder dates are built on this count.
Expiration dateCarton and each foil, year first: 2028-03 or 2028-03-31.Packs past the date drop out of the count, and packs within 90 days of it are flagged to open first. A year and month is read as the first day of that month.
Carton lotCarton, usually near the expiration date, after the word LOT or the batch code symbol.Some FDA recall records list carton lots only. Once the carton is recycled, the sheet is your record of it.
Blister lotEach foil, near the expiration date.It can be a different number from the carton lot. A record that lists blister lots lets you check a loose pack directly.
Kept inWherever the box lives.A recount goes faster when the travel bag and the hall closet are on the list.

Lot formats differ by maker. In FDA's recall records, CooperVision carton lots are long strings of digits, Alcon lots are one letter and seven digits, and Johnson & Johnson lots are seven characters starting with J. The contact lens recall guide shows where each one is printed and how to check a lot against FDA's records.

The barcode on the carton is not the lot number

The barcode on a contact lens carton is its unique device identifier, or UDI. FDA's UDI rule has required one on the labels and packages of class II devices since September 24, 2016, and soft contact lenses meant for daily wear are class II devices under 21 CFR 886.5925. The UDI appears twice on the label, once as plain text and once in machine-readable form such as a barcode, and it has two parts. The device identifier stands for the maker and the specific product. When a label also prints a lot number and an expiration date, as contact lens labels do, a production identifier carries both (21 CFR 801.40).

The rule excepts single-use devices of one model that ship together in one package, and stay in it until they are used, from carrying their own UDI, while the package that holds them must carry one (21 CFR 801.30(a)(3)). For daily disposables, that package is the carton. Once packs leave it, what you can read off each one is the plain text on the foil. That is why the sheet keeps both lots and the date as text rather than relying on a scan of a carton you may already have recycled. If you want to confirm which product a carton's device identifier belongs to, AccessGUDID, the National Library of Medicine's public search of FDA's device identifier database, looks it up.

What the prescription check catches

Cartons are sold per eye, and nothing on them says which eye. The printed parameters, usually the power, are what tell one eye's box from the other, which makes the check worth running every time a delivery is unpacked.

A box in the wrong eye's pile

Take a wearer prescribed clariti 1 day at -3.25 in the right eye and -2.75 in the left. A box marked -2.75 sitting with the right eye boxes is not right eye supply. It is left eye supply in the wrong place, and worn in the right eye it would give half a diopter less correction than prescribed. The sheet moves it to the left eye's count and says why, so the right eye's run out date reflects what that eye can actually use.

A box that matches neither eye

A box marked -2.50 against that same prescription matches neither eye. It may be left over from an earlier prescription, or it may simply be the wrong lens. The sheet lists it and leaves it out of both counts. FDA's advice when a lens does not match is to check with your eye care professional, and not to accept a substitution your eye care professional has not approved.

The same power in a different product

Matching numbers do not make two lenses interchangeable. Under 16 CFR 315.5(f) a seller may not alter a prescription, and when verifying one, that includes putting a manufacturer or brand other than the prescribed one in front of the prescriber. The exception is a private label lens that is identical to the prescribed one and made by the same company under another label. Enter the product on the prescription and on the box, and the sheet compares the names while ignoring capitals, spacing and word order.

A toric box with the wrong axis

Toric lenses add a cylinder and an axis, and two boxes can share a power and differ only in axis. CooperVision lists clariti 1 day toric in axes from 10 to 180 degrees in 10 degree steps, so the axis is a real variable rather than a formality. Turn on the toric and multifocal fields and the sheet compares CYL, AXIS and ADD as well.

How the run out and reorder dates are worked out

The arithmetic is short enough to check by hand, and it runs separately for each eye. CDC describes a true daily disposable schedule as a brand new pair of lenses each day, which is why one sealed pack counts as one day of wear for one eye.

  1. Count the packs that qualify: sealed, not past the printed date, and matching that eye's prescription. Packs that match the other eye move to the other eye. Packs with no power entered are counted and marked as unchecked.
  2. Multiply by 7, divide by the days you wear lenses each week, and round down. That is the days of wear left.
  3. Count that many days forward from today. That is the run out date.
  4. Subtract the days an order takes to arrive and the spare days you want in hand when it does. That is the reorder date, and the earlier of the two eyes is the one that goes on your calendar.

Say the right eye has 73 qualifying packs and you wear lenses five days a week. 73 times 7 is 511, and 511 divided by 5 is 102.2, so 102 days. Checked on November 14, 2026, the supply runs out on February 24, 2027. With 14 days for an order to arrive and 7 spare days, the reorder date is February 3, 2027. Wear lenses every day instead and the same 73 packs run out on January 26, 2027, with a reorder date of January 5.

Arrival time is the number worth thinking about. A seller that does not hold your prescription has to verify it, and under 16 CFR 315.5(c) an order can be filled if the prescriber does not respond within eight business hours of a complete verification request. Shipping comes on top of that, and so does any backorder on your power. The sheet starts at 14 days. Replace it with what your last order actually took.

If you enter the prescription's expiration date, the sheet compares it with the reorder date. Under 16 CFR 315.6 a contact lens prescription runs at least one year from its issue date, unless state law sets a longer term or the prescriber documents a medical reason for a shorter one. FDA's advice is not to order lenses on an expired prescription, so a reorder date that lands after the expiration date means the exam comes first.

Keeping the file current

The sheet above is a snapshot of one day. The CSV file is the record you keep.

  1. Download the spreadsheet and open it in Excel, Google Sheets (File, then Import) or Numbers. One file per wearer keeps prescriptions apart, and the Wearer column lets several people's rows share one spreadsheet without losing track of whose box is whose.
  2. When you open a box, lower its sealed packs left. Delete the row once the box is empty.
  3. When an order arrives, add one row per carton, with both lots and the date, before the carton goes in the recycling.
  4. Before you reorder, load the file back with Load a saved sheet. The checks, the run out dates and the reorder date are worked out again from that day.

Two details keep the file accurate from one app to the next. Lot cells start with the word LOT, the same word the batch code symbol prints. Without it, Excel reads a 14 digit carton lot as a number, shows it in scientific notation, and drops any leading zeros. Dates are written year first, and if Excel saves them back as month, day and year, the sheet reads that format too.

The cupboard and the counter

An inventory sheet suits the cartons you will not open for months, and ACUVUE's advice for those is a cool, dry place. The packs you reach for each morning need something different: to stay separated by eye and countable at a glance. That is the job of a Sturdysight organizer, a paired set of hard-shell cases, one labeled L and one labeled R, that holds sealed daily-disposable blister packs upright. It comes in Small, Medium and Large, and the case size finder works out which suits the number of packs you keep out.

Frequently asked questions

What should a contact lens inventory spreadsheet include?

One row per box with the eye it is kept with, the product, the power and the other parameters printed on it (base curve, diameter, and cylinder, axis or add for toric and multifocal lenses), the sealed packs left, the expiration date, the carton lot and the blister lot, and where the box is kept. Put the prescription for each eye at the top so every box can be compared with it.

How do I keep track of how many contact lenses I have left?

Count sealed packs per eye rather than boxes. Each daily disposable pack is one day of wear for one eye, so an eye's packs, times 7, divided by the days you wear lenses each week, is the number of days left. Recount when you open a box and before you reorder, and leave out any pack past its printed date.

Where is the lot number on a box of contact lenses?

On the carton, usually near the expiration date and after the word LOT or the batch code symbol, and on each foil, also near the date. The carton lot and the blister lot can be different numbers, so record both while you still have the carton.

Is the barcode on a contact lens box the lot number?

No. The barcode is the unique device identifier. Its device identifier names the product, and because the label prints a lot and an expiration date, its production identifier carries those too. Recall records name affected lots, and the lot is printed in plain text on the carton and the foil, so record it as text.

Do unopened contact lenses expire?

Yes. The date is printed on the carton and on each individual pack, and ACUVUE says it is usually one to five years from the day the lenses are made. ACUVUE says wearing lenses past their expiration date exposes you to serious eye health risks, which is why the sheet leaves expired packs out of the count.

Can I wear a box from my old prescription?

A box from an older prescription is a different lens from the one you are prescribed now. FDA's advice when a lens does not match is to check with your eye care professional. The sheet lists the box and leaves it out of both eyes' counts.

Does the sheet work for two-week or monthly lenses?

It records boxes of any lens, and the prescription check works the same way. The run out date assumes one sealed pack per eye per wearing day, which is how daily disposables are used. Reusable lenses last a whole replacement interval, so the replacement calculator is the better fit for their dates.

Is anything I enter stored or sent anywhere?

No. The checks run in your browser tab, and nothing is uploaded or saved to an account. Download the CSV file to keep the sheet, and load it back when you want to update it.

Sources

Label contents and lens parameters come from the manufacturer documents below, prescription and verification rules from the current text of the FTC Contact Lens Rule, and the UDI rules from FDA and the Code of Federal Regulations. Labels, product ranges and rules change, so check the current text before relying on any of it, and treat your prescription and your eye care professional as the authority on your eyes.