Free reseller inventory spreadsheet template

A free reseller inventory spreadsheet (CSV for Excel and Google Sheets) with the 18 columns that matter: SKU, bin, cost, where listed, sold price and profit.

TemplateUpdated November 14, 2026

A spreadsheet is the right first inventory system. It costs nothing, and building one teaches you what you actually need to know about each item. This template has the columns that answer the three questions a reseller asks every day: where is it, where is it listed, and did it make money.

The columns, and why each is there

ColumnWhat goes in it
SKUYour own code for the unit, the same one on its label
Item name, BrandEnough to recognize it and to start a listing title
UPC or ASINThe product identifier, when it has one
ConditionOne of a fixed list: New, Like New, Used - Good, Used - Fair, For Parts
BinWhere it is stored
LotThe pallet or load it came from
Date inWhen you received it, to spot stale stock
CostWhat the unit cost you, or the load cost divided by units
List priceThe current asking price
Listed onEvery marketplace it is live on
StatusIn stock, Listed, Sold, or Removed
Sold on, Sold date, Sold priceWhere and when it sold, and for how much
Fees, Shipping costWhat the sale cost you
ProfitSold price minus fees, shipping and cost

For the SKU column, see a SKU system for resellers.

How to set it up

  1. Open the file in Excel or Google Sheets and delete the three example rows.
  2. Freeze the top row and turn on filters, so you can show only Listed or only one lot.
  3. In the Profit column use a formula: sold price minus fees, shipping cost and cost.
  4. Make Status and Condition dropdowns, so nobody types a variation.
  5. Give every unit a code before it goes on a shelf. The SKU generator makes a run of them.

Print each code with the free inventory label maker, so the sheet and the shelf match.

Selling on Whatnot? Its upload file has its own columns. See the Whatnot bulk upload CSV template.

Three habits that keep it true

  • Add the row at intake, not when you list. Unrecorded stock is stock you forget you own.
  • Update Listed on every time you post or end a listing. It is the column that prevents a double sale.
  • Mark it Sold the moment it sells, then end its other listings. See how to avoid overselling.

When a spreadsheet stops being enough

  • More than one person adds rows, and they overwrite each other.
  • You list on three or more marketplaces and Listed on is often wrong.
  • An item sold while nobody was watching, and sold again somewhere else.
  • Typing the row takes longer than photographing the item.

At that point the spreadsheet is doing a job it cannot do: reacting to a sale. Resale Champ keeps the same record, filled in by a barcode scan on the phone, and takes an item's other listings down when it sells. It also exports everything back to a spreadsheet with photos whenever you want it. See what to look for in inventory software.

Hiring help? See reseller software for teams. Listing on more marketplaces? See crosslisting apps compared.

Common questions

Is the reseller inventory spreadsheet free?

Yes. It is a plain CSV file with no sign-up. It opens in Excel, Google Sheets and Numbers.

What columns should a reseller inventory spreadsheet have?

At least a SKU, item name, condition, storage bin, cost, list price, where it is listed, status, and the sold price, fees and shipping cost needed to work out profit.

Can I use it for Whatnot, eBay and Poshmark together?

Yes. The Listed on column records every marketplace an item is live on, and Sold on records where it sold, so one row covers the item everywhere.

How do I calculate profit per item?

Profit is the sold price minus marketplace fees, your shipping cost and what the item cost you. For a pallet, divide the load cost by the number of sellable units to get a cost per item.

Clear the warehouse.
Start listing today.

30 days free, no credit card, no contract.