1. Home
  2. Calculate
  3. Discount Table Generator

Discount Table Generator

Turn list prices and discount rates into a sale price chart.

Runs in your browser · No upload
Separate with commas or spaces. Ranges also work: 10-50/10 means start-end/step.
List price5%10%20%30%50%
109.59875
2523.7522.52017.512.5
49.947.4144.9139.9234.9324.95

How to use

  1. Enter list prices, one per line. Thousands separators and currency symbols are fine.
  2. List the discount rates separated by commas or spaces. Ranges such as 10-50/10 (start-end/step) also work.
  3. Choose how to handle the last digits with round to and nearest, down or up.
  4. When the table appears, use Copy table to paste it straight into Excel or Google Sheets, or Download CSV.

With one list price you get a vertical table of sale price and amount saved for each rate. With several prices you get a matrix: prices as rows, rates as columns.

The currency starts from your country, and if you pick another currency the amounts you entered are converted at live exchange rates.

Writing the rates

You type Rates produced
5, 10, 20 5%, 10%, 20%
10-50/10 10%, 20%, 30%, 40%, 50%
1-5 1%, 2%, 3%, 4%, 5% (step defaults to 1)
0.5-2/0.5 0.5%, 1%, 1.5%, 2%

Duplicates are used once and your order is kept. Values outside 0 to 100 are reported and skipped. The table holds up to 60 rates and 200 prices.

Worked example

List prices of $10, $25 and $49.90 with 5, 10, 20, 30 and 50 percent off, rounded to the nearest 0.01.

List price 5% 10% 20% 30% 50%
10 9.5 9 8 7 5
25 23.75 22.5 20 17.5 12.5
49.9 47.41 44.91 39.92 34.93 24.95

Sale price = list price × (100 − discount) ÷ 100.

Handling the last digits

15% off a list price of $19.90 gives $16.915 before rounding. How you tidy the number changes the result.

Setting Sale price
Nearest 0.01 $16.92
Down to 1 $16
Up to 1 $17

Rounding down favors the customer slightly and rounding up favors the seller. Pick whatever matches your pricing policy.

When you publish the prices

A banner reading “up to 50% off” may only be true for a few items. Showing a crossed-out original price that was never actually charged can mislead shoppers, and many countries regulate this, so check your local advertising rules. This tool only calculates and gives no legal advice.

Frequently asked questions

If I discount twice, do I add the rates?

No. 20% off and then 10% off is 28%, not 30%, because the second discount applies to the already reduced price. Use the Discount Calculator for stacked discounts.

Can I use decimal rates?

Yes, for example 12.5. Set the rounding unit to 0.01 to see two decimals.

How do I find the discount rate from a sale price?

Use the “sale price to discount %” mode in the Discount Calculator.

Will Excel read the numbers as numbers?

The copied table is tab separated and keeps thousands separators, which some settings read as text. For calculations use Download CSV, which contains plain numbers.

The values you enter are processed only in your browser and never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.