FREE2026 Live Chat Software Comparison|Independent, data-backed — no sales callGet the PDF →

Spotsaas logo
Free Excel template · Live Chat

Canned Response Library

A ready-to-load library of live-chat canned responses (macros) organized by conversation stage, with placeholders, suggested shortcuts, and a usage tracker that scores each macro on volume and CSAT so you can see which ones are pulling their weight. Paste these into your help desk, personalize the placeholders, and use the tracker to prune or rewrite the macros that underperform.

  • Instructions
  • Macro Library
  • Usage Tracker
★★★★★Trusted by 3,000+ buyers· built from 113 live chat software tools· independent
Excel template · FreeCanned Response Library

Where should we send it? Free · arrives in seconds · no spam.

We email it to you — one-click unsubscribe anytime.

  1. 1Tell us where to send it

    Your name and work email — nothing more.

  2. 2Check your inbox

    Your spreadsheet arrives in seconds, not days.

  3. 3Use it with your team

    Editable and ready to share — make it your own.

A peek inside

See exactly what you're getting

Free Excel template
Spotsaas · 2026
Canned Response Library
Instructions
Macro Library
Usage Tracker
Get the spreadsheet

What it is

The Canned Response Library is a spreadsheet you can load straight into your help desk: a starter set of live-chat macros — also called snippets or saved replies — organized by the stage of the conversation they belong to. Greetings and openings, holding and investigating lines, resolving and explaining responses, and closing and follow-up messages each get their own section, with a suggested shortcut (like /greet or /onit), the macro text itself, and a 'when to use' note that tells agents which moment each reply is for. Every macro carries {{placeholder}} tokens — {{name}}, {{agent}}, {{order}} — that you remap to your platform's merge syntax.

Beyond the library itself, the workbook includes a Usage Tracker sheet that turns the macro collection into a managed asset rather than a junk drawer. You enter each macro's monthly use count and its average CSAT, and the sheet computes each macro's share of total usage and a recommendation: high-volume macros sitting below your team's CSAT benchmark are flagged as the top rewrite candidates, while strong, well-used macros are left alone. A volume-weighted CSAT figure shows how the whole library performs in proportion to how often each reply is actually sent, so a rarely-used perfect macro can't mask a heavily-used weak one.

It is a starting library, not a finished policy. The Instructions sheet sets the golden rules — keep each macro to 1-3 short lines, lead with the answer then the reason, match a warm-but-concise brand tone, and treat every macro as something an agent personalizes before sending rather than fires verbatim. The benchmark guidance is deliberately conservative: mature chat teams keep a focused set of 30-60 high-quality macros rather than hundreds of stale ones, and review the library on a regular cadence.

What it's used for

A canned-response library exists to make agents fast without making them sound like robots. In a medium where visitors expect replies in seconds and a single agent may be juggling three or four conversations at once, well-written macros are the difference between consistent, on-brand answers and improvised, uneven ones. Teams use this library to:

  • Seed a help desk with a structured, stage-organized set of macros — greetings, holding lines, resolutions, and closings — instead of writing them ad hoc as situations arise.
  • Assign keyboard shortcuts (/greet, /onit, /reset, /close) so agents insert the right reply in a keystroke and keep response times low across concurrent chats.
  • Standardize tone so a billing answer and a support answer both read as warm and concise, no matter which agent typed them.
  • Reduce dead air during investigations with ready holding lines that give a reason and a rough timeframe, since unexplained silence is the fastest way to lose a chat.
  • Track macro performance in the Usage Tracker, scoring each on volume and CSAT to surface which replies are pulling their weight and which are dragging satisfaction down.
  • Prune and rewrite underperformers — high-volume, below-benchmark macros — using the recommendation column instead of guessing which lines need work.
  • Keep the library lean at 30-60 strong macros, reviewed on a cadence, rather than letting it bloat into hundreds of stale, conflicting replies.

Who uses it

The macro library is shared infrastructure that several roles create, maintain, and consume. Each interacts with a different part of the workbook:

Live-chat agentsThey use the shortcuts every shift to answer fast, and they're expected to personalize at least one detail in each macro before sending so it never arrives verbatim.
Support / CX managersThey own the library's health, run the Usage Tracker, and decide which low-CSAT, high-volume macros get rewritten and which stay.
QA and quality leadsThey watch for macros that correlate with lower satisfaction in QA scoring and feed those findings back into the rewrite queue.
Help-desk / chat adminsThey map the {{placeholder}} tokens to the platform's merge syntax and configure the shortcuts inside Intercom, LiveChat, Olark, or Tidio.
Onboarding and enablementThey walk new agents through the library during ramp so newcomers learn the approved language and tone from day one.

Context & good to know

In live chat, tone is the whole product. There is no smile, no warmth in a voice, and no body language — the words carry one hundred percent of the experience. That makes macros a double-edged tool: a well-crafted, personalized macro delivers a warm answer in a fraction of the time, while a stiff or generic one read verbatim makes the whole interaction feel like talking to a vending machine. The library's insistence on 1-3 short lines, answer-first structure, and a personalization touch is what keeps the speed of macros from costing you the warmth.

The Usage Tracker exists because macro libraries decay. Teams add replies for one-off situations, copy near-duplicates, and never delete anything, until agents are scrolling past dozens of stale snippets to find the right one. By scoring each macro on volume and CSAT and computing a volume-weighted library CSAT, the tracker reframes the library as a performance-managed asset: the macros that actually get sent and the satisfaction they produce are what matter, not the raw count of entries.

This library pairs naturally with a greeting and tone guide. The tone guide sets the rules for how agents open, sustain, and close conversations; the macro library is where those rules become ready-to-paste language. The two together let a chat team scale headcount without scaling inconsistency — new agents inherit both the philosophy and the exact words, and QA can trace a low-CSAT pattern back to a specific macro and rewrite it.

Implementation specifics vary by platform but the concept is universal. Intercom calls them saved replies and supports rich snippets, LiveChat and Olark use canned responses with slash shortcuts, and Tidio offers saved responses on lighter plans. Whatever the tool, the workflow is the same: import the text, map the placeholders, assign shortcuts, and then let the Usage Tracker tell you which replies to keep sharpening over time.

✓ Independent · vendors can't pay to rank

Built on verified data, not vendor spin

Every Spotsaas resource draws on the Spotsaas Score — a blend of verified review ratings, review volume, and feature depth across 113 live chat software tools. Refreshed regularly; data as of June 2026.

FAQ

Questions, answered

What is a canned response in live chat?

A canned response — also called a macro, snippet, or saved reply — is a pre-written message an agent inserts into a chat to answer a common question quickly and consistently. Agents trigger them by a shortcut (like /greet) and then personalize a detail before sending, so the reply is fast but still feels human.

How many canned responses should a chat team have?

Mature teams keep a focused library of 30-60 high-quality macros rather than hundreds of stale ones. A smaller, well-maintained set is easier for agents to search and keeps quality high; if you find macros that are rarely used or underperform on CSAT, prune or rewrite them rather than letting the library bloat.

How do I keep macros from sounding robotic?

Three habits: keep each macro to 1-3 short lines that lead with the answer, require agents to personalize at least one detail before sending so it never arrives verbatim, and track CSAT by macro so any reply reading as cold gets flagged and rewritten. A macro is a starting point an agent edits, not a fire-and-forget script.

What are placeholders and how do I set them up?

Placeholders are tokens like {{name}}, {{agent}}, or {{order}} that your help desk fills in automatically from the conversation or customer record. When you import the library, replace each placeholder with your platform's merge syntax (Intercom, LiveChat, Olark, and Tidio each have their own), so the right name and details populate every time.

How does the Usage Tracker decide which macros to rewrite?

You enter each macro's monthly use count and average CSAT, and the sheet computes its usage share and a recommendation. High-volume macros sitting below your team's CSAT benchmark are flagged as top rewrite candidates, because they touch the most conversations while dragging satisfaction down. Strong, well-used macros are left alone.

What's a volume-weighted macro CSAT and why does it matter?

It's the library's average CSAT weighted by how often each macro is actually sent, so heavily-used replies count more than rarely-used ones. It matters because a single perfect macro that's almost never used can't paper over a weak macro that goes out hundreds of times a month — the weighted figure shows the experience your visitors actually receive.

Can I use these macros in any live chat software?

Yes. The library is platform-neutral text with placeholder tokens and suggested shortcuts. Whether you run Intercom, LiveChat, Olark, Tidio, or another tool, you import the text, remap the placeholders to the platform's merge syntax, and assign the shortcuts in your macro settings.

How often should the macro library be reviewed?

Review it on a regular cadence — many teams do it monthly or quarterly using the Usage Tracker. The goal is to catch macros whose CSAT has slipped, retire ones no longer used, and add replies for new product or policy situations, keeping the library lean and high-performing.

Should holding and investigating lines be canned too?

Yes, and they're some of the most valuable. A ready holding line that gives a reason and a rough timeframe ('let me check that properly, about two minutes') prevents dead air during an investigation, which is one of the fastest ways to lose a chat. The library includes a dedicated holding and investigating section for exactly this.

Do canned responses lower or raise CSAT?

It depends entirely on how they're written and used. Personalized, concise, answer-first macros raise CSAT by making agents faster and more consistent. Stiff macros fired verbatim lower it. That's why the workbook ties every macro to a CSAT score in the Usage Tracker — so you keep the ones that help and rewrite the ones that hurt.

Grow your pipeline with buyers who are already looking for you

254,000+ buyers use Spotsaas every month to evaluate and shortlist software. Get in front of them — for free, or with a managed growth plan built around your category.