Antique Inventory Spreadsheet Example and Setup

How-to basics · Updated November 21, 2026

An antique inventory spreadsheet can track each item’s identity, provenance, condition, location, cost, asking price, and sale details in one row. In Excel for Microsoft 365, start with the example below, then turn the range into a table so you can sort and filter the collection as it grows.

Antique inventory spreadsheet example

Use one row per item and clear, consistent column headings. This sample shows how an item moves from acquisition to sale; the prices are illustrative, not valuations.

ID Category Description Maker or attribution Period Acquired Source Cost Asking price Condition Location Status Sold date Sold price Fees Packing/shipping Net proceeds Gain/loss Photo or records
A-001 Lighting Brass table lamp Unconfirmed 20th century 2025-02-14 Estate sale $45 $150 Good; patina, tested Shop shelf 2 Sold 2025-04-03 $120 $12 $8 $100 $55 Photos/A-001
A-002 Furniture Oak side table Unknown Early 20th century? 2025-03-02 Dealer $80 $240 Fair; surface wear Warehouse A, 4 In stock Photos/A-002
A-003 Pottery Stoneware jug Possibly local maker Unknown 2025-03-05 Collection purchase $30 $95 Good; small rim chip Display case 1 On hold Photos/A-003

The table makes distinctions that matter in real inventory work: “Unconfirmed” is not the same as a confident maker attribution, and an item “On hold” is not necessarily sold. Keep uncertain information visibly uncertain rather than turning a guess into a fact. The sample’s net proceeds and gain/loss figures can be calculated with formulas described below.

What to record for each antique

A useful record answers four practical questions: What is the object? Where is it? What is known about it? What has happened financially? A compact set of core fields is usually better than a crowded sheet full of columns no one maintains. Add detail when it helps identify, care for, price, or sell an item.

  • Identity: unique ID, category, object type, materials, dimensions, and a concise description.
  • Attribution and history: maker, period, origin, provenance, and the source of each claim. Use labels such as “attributed to,” “possibly,” or “unknown” where appropriate.
  • Operations: acquisition date, seller or source, purchase cost, condition, current location, and status.
  • Sales and records: asking price, sale date and price, selling fees, packing or shipping costs, photo links, receipts, and notes.

For furniture, dimensions and material may be essential; for a small piece of jewelry, weight, metal marks, and stone details may matter more. Customize the sheet by category, but retain common fields such as ID, cost, condition, location, and status so the whole collection remains searchable.

How to set up the sheet in Excel

  1. Open a blank workbook and type one heading per column in row 1. Use short, unambiguous labels, such as “Purchase cost” rather than “Value.”
  2. Enter one object per row. Assign each a unique ID, for example A-001, A-002, and A-003. Do not reuse an ID after an item is sold; the old record is useful history.
  3. Select the headings and records, then choose Insert > Table. Confirm that the table has headers. Excel tables provide filter buttons and carry formatting and formulas into newly added rows.
  4. Set number formats deliberately: dates for acquisition and sale dates, currency for costs and sale amounts, and plain text for IDs. Avoid typing currency symbols into text values; numeric cells can still display a currency format.
  5. Use filters on the header row to find, for example, all items in a particular room or all records with status “In stock.” Keep a separate backup of the workbook and linked image files.

To keep the headings visible while scrolling, choose View > Freeze Panes > Freeze Top Row in Excel for Microsoft 365 on Windows. On Mac, the View tab also includes Freeze Panes options, though the ribbon layout can differ. If the workbook is shared or moved between computers, store linked photos in a shared, stable folder; a link to a file on one person’s desktop may not work for another user.

Useful formulas for sales and stock

Formulas are most useful when they calculate a clearly defined figure. In the example layout, columns H through R contain cost and sale information. Enter the formulas in row 2 and fill them down the relevant rows. If you use an Excel table, a formula entered in a calculated column will generally populate the other rows automatically.

With status in L, sold price in N, selling fees in O, and packing or shipping cost in P, put this formula in Q2 for net proceeds. For the brass lamp, it returns $100: $120 minus $12 minus $8.

=IF(L2="Sold",N2-O2-P2,0)

With net proceeds in Q and purchase cost in H, put this formula in R2 for the simple sale margin after those listed costs. For the lamp, it returns $55: $100 minus $45.

=IF(L2="Sold",Q2-H2,"")

This margin is not necessarily accounting profit. It leaves out any costs you have not entered, such as restoration, storage, insurance, travel, or other overhead. Rename the column to “Margin after listed costs” if that wording makes the scope clearer, and do not treat an asking price as money received.

With statuses in L2:L4 and purchase costs in H2:H4, this formula totals the purchase cost of items marked exactly “In stock.” It returns $80 for the sample because the oak table is the only row with that status.

=SUMIF(L2:L4,"In stock",H2:H4)

Adjust the ranges when adding records, or convert the data into a table and use table-aware formulas if you are comfortable with structured references. Check that status spelling is consistent: “In stock,” “In Stock,” and “Stock” can cause mismatches in reporting even where a function treats letter case alike.

Descriptions, condition, and provenance

Write descriptions so someone else could distinguish an item from a similar one. “Blue vase” is weak; “Blue glazed stoneware jug, loop handle, about 24 cm high, incised mark on base” is more useful. Record measurements in a consistent unit and note whether dimensions refer to height, width, depth, or diameter.

Condition should be factual and specific rather than a vague grade alone. Note visible wear, repairs, missing parts, cracks, chips, staining, and whether an object has been tested when that is relevant. A condition note such as “Good” can be retained as a quick filter, but add the evidence: “Good; light surface wear, no visible cracks.” Photographs should show identifying marks and flaws as well as the overall object.

Provenance and maker attribution deserve particular care. Record what a seller, label, receipt, family history, or reference actually states, and distinguish that source from your own conclusion. A spreadsheet is a recordkeeping tool, not proof of age, authenticity, or ownership history. Attach or link supporting documents where appropriate, and preserve the original wording of a label or receipt in notes.

Locations, statuses, and daily workflow

Inventory information stays useful only if it matches the physical collection. Choose a location format that can be followed consistently, such as “Shop / cabinet 2 / shelf B” or “Warehouse A / rack 4.” If items move, update the location as part of the move rather than relying on memory. For valuable or frequently handled objects, consider recording a date for the last location check.

Define a small set of statuses and use them consistently. A practical list might include “In stock,” “On hold,” “Listed,” “Sold,” and “Returned.” Decide what each means: for example, “Listed” means an active listing exists, while “On hold” means a temporary reservation that has not been paid for. Do not delete sold records; mark them sold and complete the sale fields so you retain a history.

A simple routine can prevent gaps:

  • At intake, assign the ID, photograph the item, record the source and cost, and note its initial condition.
  • When pricing or listing, add the asking price, location, and listing reference or link.
  • When an item moves, changes status, or is sold, update the row promptly and enter the actual sale figures.
  • Periodically check a sample of spreadsheet records against the objects and confirm that photo and receipt links still open.

Common spreadsheet problems to avoid

The most common structural mistake is putting several objects in one row, or putting multiple unrelated facts into a single cell. Separate records are easier to filter, count, and update. If a set contains individually tracked pieces, give each piece its own row and use a shared set or collection ID to connect them. If the set is managed and sold as one unit, one row may be more practical; explain the contents in the description.

Another frequent problem is mixing different meanings of “value.” Purchase cost, asking price, insurance figure, and realized sale price are not interchangeable. Give each its own heading and record the date and basis for any estimate. Asking prices are offers, not evidence that an object will sell for that amount. Comparisons with other listings can be useful context, but an asking price is not the same as a completed sale.

Avoid merging cells in the data area, leaving blank rows between records, or using color as the only indicator of status. Those choices make sorting and filtering less reliable or less accessible. Use an explicit status field, and use color only as an additional visual cue. Before sorting, select a cell within the Excel table rather than sorting one column by itself; sorting only part of a record can separate an item’s description from its cost or location.

Choosing between a spreadsheet and other tools

A spreadsheet is a sensible choice for a modest collection, a solo dealer, or a household that needs flexible fields and simple totals. It is easy to adapt without purchasing a dedicated system, but it depends on careful entry, backups, and clear ownership of edits. Shared workbooks can also produce conflicting changes if several people maintain separate copies.

A database or inventory application may be worth considering when you need multiple users, barcode labels, integrated point-of-sale records, automated online listings, or detailed permissions. Before migrating, check whether the software can export your data and images in usable formats. A paper notebook can still be a helpful field log at an estate sale, but transfer important purchase details into the main record promptly. Whatever the tool, keep a stable item ID and a separate backup; those habits make later changes in software much easier.

Frequently Asked Questions

What columns should an antique inventory spreadsheet have?
At minimum, include a unique ID, description, category, acquisition date, source, cost, condition, location, status, and photo reference. Add maker or attribution, dimensions, asking price, and sale details when they are relevant to the object or your workflow.

How do I track antique inventory in Excel?
Put one item on each row, create clear headings, format dates and money consistently, and use Insert > Table to enable filters. Update location and status when an item moves or sells, and keep photos and supporting documents linked to stable files.

Should I include an estimated value or asking price?
You can include both, but label them separately and record the date and basis for an estimate. Neither an asking price nor an estimate guarantees a sale price. Keep actual sale price in its own field so historical results remain distinct from current expectations.

Can I use the spreadsheet to prove an antique is authentic?
No. A spreadsheet can preserve descriptions, photographs, receipts, and attribution sources, but the record itself does not establish authenticity or age. Document uncertainty accurately and seek appropriate specialist review when a consequential identification is needed.

Should sold antiques be deleted from the inventory?
Usually, keep the row and change its status to “Sold.” Add the sale date, realized price, fees, and other relevant costs. Retaining sold records preserves sales history and helps avoid accidentally reusing an item ID.

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.