Posted in

5 Free Coupon Templates in Word and Excel

5 Free Coupon Templates in Word and Excel – free download preview

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

A coupon is a voucher that gives a customer a discount, a free item or a special offer. Printed coupons and coupon codes are among the simplest ways for small businesses to bring in new customers, reward regulars and clear stock. On this page you can download five free coupon templates: a sheet of printable discount coupons in Word, a sheet of promo coupons in Word, and a coupon code and expiry tracker in Excel to manage all your offers in one place, plus a seasonal sale coupon sheet and a coupon expiry tracker.

The two coupon sheets are editable .docx documents with six coupons per page, ready to print and cut out. The tracker is an editable .xlsx spreadsheet that shows which codes are active, which are about to expire, how many times each has been used and how much discount you have given.

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 (.docx / .xlsx). Works in Excel and Google Sheets / Word and Google Docs. No sign-up needed.

What Is a Coupon?

A coupon is a printed or digital voucher that customers present, or enter as a code, to get a deal. Common types include:

  • Percentage off: for example, a 10% discount on your next purchase.
  • Dollar off: for example, $5 off orders of $30 or more.
  • Buy one, get one (BOGO): buy one item and get a second free or at a discount.
  • Free item or free delivery with a purchase.
  • Loyalty and birthday rewards for regular customers.
  • Referral coupons that reward both the customer and a friend.

Every coupon should have clear terms: what the offer is, when it expires, and any limits on how it can be used.

Download Free Coupon Templates

The Word templates open in Microsoft Word, Google Docs and LibreOffice Writer. The tracker opens in Excel, Google Sheets and LibreOffice Calc.

1. Printable Discount Coupons

Printable discount coupon template in Word with six cut-out coupons, codes and expiry dates

A page of six discount coupons in a cut-out grid: 10% discount, $5 off orders of $30 or more, 20% discount on one full-price item, free delivery on orders over $50, 15% discount for new customers and buy 2 get 1. Each coupon has space for your business name, a large offer headline, a short description, a coupon code, an expiry date and small-print terms: one coupon per customer, not valid with other offers, no cash value, plus your address or website. Change the offers, codes and dates to your own, then print on card and cut along the lines.

2. Promo Coupons

Promo coupon template in Word with BOGO, loyalty, birthday and referral coupons

A page of six promotional coupons for loyalty and special offers: buy one get one free, a free gift with purchases over $40, a happy birthday free dessert, a loyalty reward of $10 off after 10 visits, a refer-a-friend offer where you both get a 15% discount, and a free trial class or session. Each coupon has the same layout and terms as the discount sheet, so you can mix and match. These suit cafés, salons, gyms, studios and shops that want to reward regular customers.

3. Coupon Code and Expiry Tracker

Coupon code tracker template in Excel with expiry status, redemptions and discount given

A tracker for up to 40 coupon codes. For each code, enter the offer, the type (%, $ or Free item from the dropdown), the value, the start and expiry dates, the number of times it has been used and an optional limit. The tracker shows a status for every code, Scheduled, Active, Expires soon (within seven days), Expired or Used up, with colours so you can spot them at once. It also works out the discount given for each code: for dollar and free-item codes, the number of uses times the value; for percentage codes, the percentage times the sales the code was used on, which you enter in the last column. At the top, a summary shows today's date, how many codes are active, how many expire in the next seven days, total redemptions and the total discount given.

4. Seasonal Sale Coupon Sheet

Seasonal sale coupon sheet template in Word with cut-apart offers, dates, codes and short terms

Four or more cut-apart coupons on one page for a dated seasonal offer, each with the offer, a code if you use one, the valid dates, the shop, and a one-line term (one per customer, not with other offers). Put exclusions and the end date on every coupon before you print a batch. The markup and discount calculator at the top of this page can help you see what a percentage offer actually costs. Log issued codes on the expiry tracker so the till and the paper agree.

5. Coupon Expiry Tracker

Coupon expiry tracker template in Excel with codes, issued and expiry dates, status and overdue highlighting

A list of every live paper or online offer: the offer and code, the channel, issued and expiry dates, and a status (open, expired, paused). The header counts open codes, and open rows that are past their expiry highlight when you open the file. Mark Expired and close the code in the till or website when the date passes. Use it beside the coupon sheets so a printed date and the till do not disagree. Pause a code here if you need to stop it early.

How to Create a Coupon

  1. Choose your goal: new customers, repeat visits, bigger orders or clearing stock.
  2. Pick the offer type that fits the goal, such as a dollar-off coupon for bigger orders.
  3. Set the value so the offer is attractive but still profitable.
  4. Write clear terms: expiry date, minimum spend, one per customer and any exclusions.
  5. Add a unique code so you can track where each coupon was used.
  6. Design and print the coupons, or share the code online.
  7. Track results in the coupon tracker and compare offers.

Tips for Coupons That Work

  • Keep the offer simple so customers understand it at a glance.
  • Always add an expiry date to encourage customers to use the coupon soon.
  • Use different codes for different places, such as flyers, email and social media, so you know which works best.
  • Set a limit on the number of uses for big discounts.
  • Check your margins before offering a large discount.
  • Train your staff so they know how to accept each coupon.
  • Follow the rules on promotions where you work, and make sure the terms are fair and clear.

Working Out If a Coupon Is Worth It

A coupon costs you the discount you give away, plus printing or advertising. It pays off if it brings in sales you wouldn't otherwise have made, or customers who come back again. To check, use the tracker to see how many times each code was used and the discount given, and compare that with the sales the coupon brought in. A coupon that brings in many new customers may be worth it even if each sale earns less, while a discount mostly used by customers who would have paid full price may not be.

Who Can Use These Templates?

  • Shops and boutiques running sales and promotions.
  • Cafés and restaurants offering deals and loyalty rewards.
  • Salons, gyms and studios offering free trials and referral rewards.
  • Online stores managing discount codes.
  • Schools, clubs and charities creating coupons for fundraising books.

Writing Coupon Terms

The small print on a coupon prevents misunderstandings at the till. Keep it short, but cover the essentials:

  • Expiry date: the last day the coupon can be used.
  • Minimum spend, if there is one, such as "on orders of $30 or more".
  • Limits: one coupon per customer, per visit or per order.
  • Exclusions: items or services the coupon doesn't apply to, such as sale items or gift cards.
  • Combining offers: whether the coupon can be used with other discounts.
  • No cash value: the coupon can't be exchanged for money.
  • Where it can be used: in store, online or both, and at which locations.

Write the terms in plain language, and make sure your staff apply them the same way every time.

Planning a Coupon Campaign

Coupons work best as part of a plan. Decide how many coupons you will hand out, where and when, and how long the offer will run. A short offer, such as one weekend, creates a reason to visit soon; a longer offer suits loyalty rewards. Add each code to the tracker before the campaign starts, with the start and expiry dates, and set a limit if you want to cap the cost. During the campaign, update the number of uses every few days. When it ends, compare the results of each code to decide which offers to repeat.

Editing the Templates

In the Word coupons, click any text to change the business name, offer, description, code, expiry date and terms. You can change the colours of the headlines and add your logo to each coupon. In the tracker, type only in the yellow cells; the status and discount columns update automatically.

Digital Coupons and Codes

The same codes work online. Add them to your online store or booking system, then share them by email, text or social media. Use a different code for each channel so the tracker shows which one brings the most customers.

Related Templates

You can also check these useful templates like the punch card templates for loyalty programs, and the gift certificate templates.

You may also like the price list templates and the raffle ticket templates.

Frequently Asked Questions

What should a coupon include?

Your business name, the offer, a code, an expiry date and clear terms, such as one per customer and no cash value.

What is the difference between a coupon and a gift certificate?

A gift certificate has a value that someone has paid for. A coupon is a discount or offer the business gives away.

How do I print the coupons?

Print the Word file on card or thick paper and cut along the table lines. There are six coupons per page.

How does the tracker know a coupon is expiring?

It compares each expiry date with today's date and shows Expires soon when seven days or fewer are left.

Can I edit the coupons in Google Docs?

Yes. Upload the .docx file to Google Drive and open it with Google Docs.

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.