Jewelry Inventory Spreadsheet: Free Options and Setup

How-to basics · Updated November 21, 2026

Yes—a jewelry inventory spreadsheet can be created for free in Excel for the web or Google Sheets, or from a blank workbook in a desktop spreadsheet program you already have. A simple sheet can track each piece, its cost, quantity, location, and reorder status; the best setup depends on whether you manage a few personal items or stock for a jewelry business.

Free jewelry inventory spreadsheet options

A free spreadsheet does not necessarily mean that every version of spreadsheet software is free. Excel for the web is available through a Microsoft account in a browser, while Google Sheets can be used in a browser with a Google account. Both let you enter rows and columns and use basic formulas. Desktop Microsoft Excel may require a Microsoft 365 subscription or a separately licensed copy, so check your access before choosing it.

You can start with a blank workbook and create your own inventory, or look for a template in the spreadsheet program’s template gallery. Template availability and included features can change, so inspect any template before relying on it. A free template is a starting point, not a guarantee that it fits jewelry-specific needs or includes reliable valuation and sales records.

For a small collection, a single sheet may be enough. A shop with many pieces, multiple storage locations, repairs, or frequent sales may need separate tabs for stock, sales, suppliers, and changes. Start with the fewest fields that let you find and reconcile items; adding columns that nobody maintains can make a free sheet less useful than a simpler one.

What a jewelry inventory should record

Give every item a distinct stock-keeping identifier, or SKU, and record one item or one clearly defined batch per row. A practical set of columns includes:

  • SKU: A unique code such as ER-001. Do not reuse a code for a different design or item.
  • Description and category: For example, “silver hoop earrings” and “earrings.” Include distinguishing details such as size, style, or collection.
  • Materials and attributes: Record metal, gemstone, color, dimensions, or other details you need to identify the piece. Describe claims carefully and use documentation where material or gemstone details matter.
  • Quantity and location: Track how many are available and where they are stored, such as a display case, stockroom, or numbered box.
  • Cost and selling price: Keep purchase or production cost separate from the current listed price. A price is not the same thing as the item’s cost or its eventual sale proceeds.
  • Supplier, date, and status: These can help trace a purchase and distinguish available stock from items on hold, at repair, or discontinued.
  • Photo or document reference: A filename or link can point to a product image, receipt, or certificate. Keep the files themselves in an organized, backed-up location.

For one-of-a-kind pieces, use one row per piece so the description and history stay attached to that specific item. For identical, interchangeable items, one row with a quantity may be more manageable. Decide which approach you use and apply it consistently; mixing individual-piece rows with batch quantities can make stock counts confusing.

How to organize the workbook

In Excel for Microsoft 365 on Windows, enter column labels in the first row, select the range, and choose Insert > Table. Confirm that the table has headers. Tables make it easier to filter and sort by category, location, or status while keeping each row’s fields together. In Excel for the web, the table feature is also available, though the ribbon layout may differ slightly. In Google Sheets, select the range and use Data > Create a filter to filter the header row.

Keep the main inventory tab as the current-stock list rather than a scratchpad of every event. If you need a history, add a separate log with a date, SKU, change type, quantity change, and note. For example, log a sale as a decrease of one, a return as an increase of one, and a transfer as a change of location. A change log is useful only if entries are made promptly and the current quantity is reconciled against it.

Use consistent labels. If the same location appears as “Back room,” “Backroom,” and “Stock room,” filters may treat these as different values. A controlled list of categories or locations can reduce these variations. In desktop Excel, select the cells and use Data > Data Validation to set permitted entries; the exact dialog can vary by Excel version. Avoid using color alone to communicate an item’s status, since colors may be missed when printing or by readers who cannot distinguish them.

Useful calculations and stock alerts

Formulas can calculate extended values and highlight low stock, but they are only as dependable as the source data. For the examples below, assume row 1 contains headers; column F is cost per unit, column G is selling price per unit, column H is quantity on hand, and column I is the reorder point. Put the first item on row 2.

With cost per unit in F2 and quantity in H2, enter this in J2 to calculate the recorded cost total for that row: =F2*H2. If F2 is $18 and H2 is 3, the result is $54. Label column J “Cost total” so it is not mistaken for retail value.

With selling price per unit in G2 and quantity in H2, enter this in K2 to calculate the potential listed-price total: =G2*H2. If G2 is $45 and H2 is 3, the result is $135. This is a hypothetical total at the listed price, not a promise of sales or profit; it does not account for discounts, fees, or other costs.

With quantity on hand in H2 and the reorder point in I2, enter this in L2 to flag stock at or below the chosen threshold: =IF(H2<=I2,"Reorder","OK"). If H2 is 2 and I2 is 2, the result is “Reorder.” Choose the threshold based on your own replenishment needs rather than treating it as a universal rule. Copy the formulas down for the other rows, or use a table so Excel can extend a calculated column.

To total cost totals for items listed in J2 through J100, place this formula in a separate summary cell: =SUM(J2:J100). If the values in that range are $54, $80, and $0, with the remaining cells blank, the result is $134. Make sure the range covers the intended rows and does not include a separate total cell, which could cause double-counting.

A practical setup and maintenance routine

Build the sheet around a repeatable process, not just a one-time data entry session. A basic setup can follow these steps:

  1. Decide whether each row represents one unique piece or a batch of identical pieces, and define the SKU pattern.
  2. Add the fields you will actually maintain, then enter a small sample of real items and check that descriptions, prices, and quantities make sense.
  3. Turn on filters or create a table, and test searches by SKU, category, and location.
  4. Enter receipts, sales, returns, and transfers as they happen. Update the quantity and, if used, the change log together.
  5. Periodically count physical stock and compare it with the sheet. Investigate differences rather than simply overwriting quantities without a note.
  6. Save a dated backup or use the file service’s version history, and check that the backup can be accessed.

For example, a seller might assign SKU NK-014 to a silver necklace, enter an opening quantity of four, and set a reorder point of two. After a sale, the seller changes the count to three and records the transaction in the sales log. The inventory row then still describes the item, while the log preserves when and why the count changed. If one necklace is sent for repair, a status or location update can prevent it being treated as available for sale.

Common problems and safeguards

Duplicate SKUs, inconsistent descriptions, stale quantities, and formulas overwritten by hand are common sources of unreliable reports. Use a distinct identifier, filter for blanks or duplicates during review, and protect formula columns from casual edits where the program allows it. Do not assume that a spreadsheet will automatically know when an item has sold: quantities change only when someone records the transaction or connects the workbook to a system that does so.

Take care with valuation language. A “cost total” formula simply multiplies the cost entered in the sheet by the quantity entered. It does not determine the correct accounting treatment for a business. A “potential retail total” uses the entered selling price and is not the same as cash received, profit, or an appraisal. For accounting, insurance, or tax reporting, use records and methods appropriate to the situation and check with a qualified professional where needed.

Inventory files can contain commercially sensitive details, supplier information, and images of valuable pieces. Avoid storing payment-card numbers or unnecessary personal data in the workbook. Restrict sharing permissions, use a strong account password, and keep a separate backup. If you link to photos or certificates, check that the links are not publicly accessible unless you intend them to be.

When a spreadsheet is enough—and when it is not

A free spreadsheet is often a reasonable fit for a personal collection, a small maker’s catalog, or a shop that can reliably update stock by hand. It is flexible, inexpensive to start, and easy to adapt. Its limits become more noticeable when several people edit inventory at once, sales occur through multiple channels, barcode scanning is needed, or a business requires a dependable audit trail and integrated reporting.

Dedicated inventory or point-of-sale software may connect stock changes to sales, support multiple users, or manage product variants more systematically. Those capabilities may come with recurring fees, setup work, and data migration. Before switching, list the problem the spreadsheet cannot solve, check how the software handles unique pieces and variants, and confirm that you can export your records. A free sheet may remain useful as an export or backup even if it is no longer the main stock system.

Frequently Asked Questions

Can I get a jewelry inventory spreadsheet for free?
Yes. You can create one in Excel for the web or Google Sheets with an account, or use a template if one is available in the program’s gallery. Check whether the template’s formulas and columns suit your records before entering all your data.

What is the best free spreadsheet for jewelry inventory?
There is no single best choice for everyone. Excel for the web and Google Sheets both support basic tables of inventory data and formulas. Choose the one you can access, understand, and update consistently; consider sharing and backup needs if more than one person will use it.

What columns should a jewelry inventory spreadsheet have?
Start with SKU, description, category, materials or identifying attributes, quantity, location, cost, selling price, supplier, and status. Add image or document references if they help identify or verify an item. Keep the structure simple enough to maintain.

How do I track one-of-a-kind jewelry pieces?
Give each unique piece its own row and a SKU that is not reused. Record its distinctive description, quantity, location, and relevant documentation reference. A separate dated log can preserve changes such as sales, repairs, or transfers.

Can a spreadsheet calculate the value of my jewelry?
It can multiply the amounts you enter, such as cost per unit by quantity or listed price by quantity. That arithmetic does not establish an appraisal, market value, profit, or accounting value. Label calculated totals clearly and use appropriate professional guidance when those distinctions matter.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.