Posted in

5 Free Price List Templates in Excel

5 Free Price List Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 10, 2026

A price list is a simple document that shows what you sell and how much each item or service costs. Customers use it to choose and compare, and your team uses it to quote consistent prices. On this page you can download five free price list templates in Excel: a product price list with a sale price column, a service price list with tax-inclusive prices, and a wholesale price list with quantity tiers and an order calculator, plus a seasonal promotional price list and a competitor price comparison list.

Every file is a real, editable .xlsx spreadsheet. Enter your products or services and base prices in the yellow cells, set a discount, tax or tier rate, and the formulas calculate the other prices for you.

Markup, Margin & Discount Calculator

Price before discount:   Discount amount:   Sale price:  
Profit per unit:   Margin on sale price:   Price incl. tax:  
Markup needed for 40% margin:

Runs in your browser; nothing is sent or saved. Markup is on cost; margin is on the selling price.

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

What Is a Price List?

A price list, sometimes called a price sheet or rate card, is a list of products or services with their prices. It may also include product codes, units, sizes, stock status, service durations and terms such as the date the prices are valid from. Shops, wholesalers, salons, cafes, freelancers, tradespeople and manufacturers all use price lists.

A clear price list helps you:

  • Answer pricing questions quickly without checking each item.
  • Keep prices consistent across staff, channels and customers.
  • Show discounts and offers in a transparent way.
  • Support sales conversations with retailers and trade buyers.
  • Update prices easily when costs change.

Download Free Price List Templates

The files work in Microsoft Excel, Google Sheets and LibreOffice Calc. Example items show how the formulas work.

1. Product Price List

Product price list template in Excel with SKU, list price, stock and sale price

A standard price list for physical products. Each row has a SKU, product name, unit, list price and a stock drop-down (Yes or No). Set a discount percentage at the top and the sale price column updates for every product, rounded to the cent. It shows the date the prices are valid from and whether they exclude tax. Use it for retail, online shops and catalogues.

2. Service Price List

Service price list template in Excel with duration, price and tax

For salons, spas, repair shops, consultants and other service businesses. Each row has the service name, duration in minutes and price. Enter your tax rate once at the top and the sheet calculates the tax and the tax-inclusive price for every service. Add your business name, phone and booking link at the top to turn it into a printable menu or a PDF for your website.

3. Wholesale Price List

Wholesale price list template in Excel with quantity price tiers and order calculator

Trade buyers usually pay less per unit when they order more. This template has a base price for each product and three quantity tiers: 1–9 units, 10–49 units and 50+ units. You set the discount for each tier at the top and the tier prices update automatically. Below the list there is an order calculator: type a SKU and a quantity, and it looks up the right tier price and shows the order total.

4. Seasonal Promotional Price List

Seasonal promotional price list template in Excel with regular price, promo price, saving and end date

For sales, holiday promotions and launch offers. List each item with its regular price, promotional price and the date the offer ends; the sheet shows the saving. Any promo date that has passed is highlighted in red so you remember to switch back to the regular price. The header holds the season name, start date and number of items on offer. Print it for staff at the counter, or paste it into an email to regular customers. The sample covers a winter holiday promotion.

5. Competitor Price Comparison

Competitor price comparison template in Excel with our price, two competitors, lowest price and difference

Check your prices against the market before you change them. For each item, enter your price and two competitors' prices; the sheet finds the lowest competitor price and shows how far above or below it you are as a percentage. Your price turns green when it is at or below the lowest and amber when it is higher, and the header counts the items where you beat both. Being the cheapest is not always the goal, but you should know where you stand. Record the date you checked, because competitor prices move.

What to Include on a Price List

  • Business name, logo and contact details.
  • Date or "valid from" so customers know the list is current.
  • Product or service names in plain words customers understand.
  • Codes or SKUs for ordering, especially for wholesale.
  • Units: each, pack, box, hour or session.
  • Prices, and whether they include or exclude tax.
  • Discounts and tiers if you offer them.
  • Stock or availability where it changes often.
  • Terms: minimum orders, delivery charges, payment terms and how long prices are guaranteed.

How to Create a Price List in Excel

  1. Download the template that suits your business and open it in Excel or Google Sheets.
  2. Replace the example products or services with your own.
  3. Enter the list or base price for each item.
  4. Set the discount, tax rate or tier discounts in the yellow cells at the top.
  5. Check the calculated prices and adjust any that need rounding to a neat number.
  6. Add your business details and the date the prices start.
  7. Sort the list by category, name or price to make it easy to read.
  8. Save a PDF to send to customers or print for your counter.

How to Set Your Prices

Pricing is a big topic, but a few principles help every small business.

  • Know your costs. Include materials, labour, packaging, shipping, fees and a share of overheads.
  • Decide your margin. Add a markup that covers costs and leaves profit.
  • Check the market. Look at competitors' prices so yours are in a sensible range.
  • Think about value. Customers pay more for convenience, quality, speed or expertise.
  • Use tiers carefully. Wholesale discounts should still leave a profit at the lowest tier.
  • Review regularly. Costs change, so review your price list at least once or twice a year.

Retail vs Wholesale Price Lists

A retail price list is for end customers who buy small quantities. It usually shows a single price per item, often including tax, and focuses on clear product names and offers.

A wholesale price list is for shops, resellers and trade buyers. It often shows prices excluding tax, uses product codes, sets minimum order quantities and offers lower prices for larger orders. Many businesses keep both lists from the same data: the base price, plus a retail markup or wholesale discount. The templates on this page can be used that way.

Tips for a Clear, Professional Price List

  • Group items into categories such as stationery, cleaning, or hair services.
  • Use the same format for all prices, with the same number of decimals.
  • Avoid clutter. Only include columns that help customers decide.
  • Mark new or popular items with a short note.
  • Show the tax status clearly to avoid surprises at checkout.
  • Date every version and keep the old versions in case of disputes.
  • Lock formulas. If others edit the list, protect the formula columns so they are not overwritten.

Updating Prices When Costs Rise

When supplier costs go up, update the base or list price column and the sale, tax-inclusive or tier prices update on their own. Give regular customers notice before price increases, and explain briefly if the change is due to higher material or shipping costs. Some businesses update all prices once a year on a fixed date, which customers find easier to plan around than frequent small changes.

Using the Wholesale Order Calculator

The order calculator on the wholesale price list saves time when a trade customer phones or emails with an order. Type the product code in the SKU cell and the quantity in the cell below. The sheet checks which tier applies, finds the matching price from the list and shows the unit price and the order total. If you mistype the code, it shows "SKU not found" instead of a wrong price. You can copy the calculator block down to quote several products, or use it as a quick check before you prepare a formal quote or invoice. Because it reads directly from the price table, any change you make to base prices or tier discounts is reflected straight away.

Price Lists for Service Businesses

Service businesses often find a price list harder to write than shops do, because jobs vary. A good approach is to list your most common services with a fixed price and a typical duration, then add a short line such as "other work quoted on request". Showing the duration helps customers understand what they are paying for and helps you schedule bookings. If you offer packages, such as a cut and colour together, list them as separate services with their own price so customers can see the saving. Keep prices rounded to simple numbers for a service menu; the tax-inclusive column in the service template lets you check what the customer will actually pay.

Printing and Sharing Your Price List

For a counter or wall display, print the list on thick paper and put it in a clear stand or frame. For customers, save it as a PDF and attach it to emails or link it from your website. Use the same file for both, so printed and online prices always match. When you update the list, change the "valid from" date and replace old printed copies straight away to avoid confusion at the till.

Related Templates

You can also check these useful templates like the price quote templates for quoting a specific job, and the purchase order templates for orders from customers or to suppliers.

You may also like the inventory count sheet templates and the sales plan templates.

Frequently Asked Questions

How do I make a price list in Excel?

Download a free template above, replace the example items with your own, enter base prices and set the discount, tax or tier rates. The formulas calculate the remaining prices.

What should a price list include?

Your business details, the date, product or service names, codes, units, prices, tax status, any discounts or tiers, and key terms such as minimum orders.

What is a wholesale price list?

A price list for trade buyers that usually shows prices excluding tax, uses product codes and gives lower unit prices for larger quantities.

How do I show prices with tax?

Use the service price list. Enter your tax rate once and the sheet calculates the tax and the tax-inclusive price for every service.

Can I share my price list as a PDF?

Yes. In Excel choose File, Save As or Export, and select PDF. In Google Sheets choose File, Download, PDF.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.