Skip to content
Product Price List cover: a sample sheet with products listed, average price and average margin and a bar chart, beside the Dashboard and Prices tabs

Product Price List

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

A product price list is for a shop, trade business or service company that needs one reliable list of what things cost and what they sell for. The Prices tab gives each product a row with its SKU, category, unit of sale, cost, price and notes. The margin for each product works itself out as a percentage on a colour scale. The Dashboard reports how many products you list, the average price and margin, and how many fall below a 45 percent margin.

Update the cost column when supplier prices change, and the margins recalculate straight away. Review the margin column before you publish a new price sheet, and fix any product that sits below your target. Use one unit of sale per row, such as each, box or hour, so customers compare like with like. Keep every SKU unique so the list works for quotes and invoices too.

Useful for

  • Publishing a price sheet for customers or sales staff
  • Checking margins before a supplier price rise
  • Comparing average prices across product categories

What's included

  • 3 tabs: Dashboard, Prices, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Prices: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Prices tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is the margin calculated?

Margin is the price minus the cost, divided by the price. A product that costs 68 and sells for 119 has a margin of about 43 percent. Markup divides the same difference by the cost instead, so check which one your business uses before you set targets.

Can I include tax in the prices?

The template keeps prices before tax. If your published prices include tax, add a column for it and check your local sales tax rules before you publish. Rates vary by place and by product type, so confirm them with your accountant.

Can I add a new category?

Yes. Extend the Category list on the Prices tab, then give the new category its own line in the Dashboard breakdown. Use exactly the same spelling so the count and average price pick it up.

  • #quote
  • #product-price-list
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More quote templates

See all 5

Also in Sales

All sales templates
Get this template

Preparing your template…