The short version
Most reference programs start in a spreadsheet, and many should. A spreadsheet costs nothing, everyone knows how to use it, and it forces you to decide what you want to track. The question is not whether a platform is better in general. It is whether your program has outgrown what one file and one owner can handle.
When a spreadsheet is enough
Stay with a spreadsheet if most of these are true:
- Your library is small enough that one person knows every reference personally.
- One person owns the file, and every request goes through them.
- Requests are occasional, so that person can check the log before each ask.
- Your advocates are relaxed about how they are contacted and what is shared.
- Prospects never need to see reference content on their own. A rep sends it.
If that is you, do not buy software yet. Download the free customer reference library template, record consent with the consent form template, and spend your effort on recruiting good advocates.
What breaks as the program grows
The usage log falls behind
A spreadsheet only knows what someone types into it. Once requests happen in email, chat and hallway conversations, the log stops matching reality. The same few advocates get asked again and again because nobody can see the total. The advocate burnout calculator shows how quickly that concentrates.
Advocates have no say
A row in your file cannot tell you that the person changed jobs, wants fewer calls this quarter or no longer wants their title shown. The advocate cannot see the row at all. Any limit you record is one you guessed or asked about once.
Privacy is all or nothing
Anyone with access to the file sees every name, phone number and internal note. You cannot show one reference to one prospect, hide a photo, or require approval for some advocates and not others. Sharing a copy means losing track of where customer personal data went.
Search depends on memory
Filters work while your tags are consistent. As more people edit, "Healthcare", "Health care" and "Hospitals" become three values, and reps go back to asking the owner who to call. A written reference taxonomy delays this but does not prevent it.
The owner becomes the bottleneck
Every request waits for one person to read it, pick a reference, check the log, ask the advocate and schedule the call. When that person is on vacation, the program stops.
Comparison table
| Aspect | lyynx | Spreadsheet |
|---|---|---|
| Cost and setup | A platform to adopt. Currently available through the lyynx pilot. | Free, ready today |
| Structure | Reference companies and the contacts at each, with tags, assets and video | Whatever columns you define |
| Usage tracking | Engagements recorded as requests happen, with a utilization report | Manual log, as accurate as the last person to update it |
| Advocate limits | The advocate sets a limit per rolling 30 days. At capacity, requests route to your team. | A note in a cell |
| Privacy | Three privacy levels per reference and per-contact display controls | File-level sharing |
| Advocate access | Advocates log in, own their profile and can revoke consent | None |
| Finding a match | Filters plus AI matching from a plain-language description | Filter, sort and ask the owner |
| Prospect access | Invited prospects browse a branded portal and request contact | A rep emails details |
| Flexibility | A fixed model, extended through tags and an API | Total. Add a column whenever you like. |
Signs it is time to move
- More than one person adds or edits references.
- An advocate has complained about being asked too often, or has quietly stopped replying.
- You cannot say, without digging, how many times each reference was used last quarter.
- A customer's legal team has asked where their employee's details are stored and who can see them.
- Reps skip the file and message the same three customers directly.
One or two of these is a nudge to tidy the spreadsheet. Three or more means the file is costing you more than it saves. The reference program assessment will show where the gaps are, and the ROI calculator lets you put your own numbers on the time involved.
Choose a spreadsheet if
- You are starting a program and still working out what to track.
- One owner handles a small, stable library.
- Budget is the constraint and volume is low.
Choose lyynx if
- Several people request references and you need one accurate record of use.
- You want advocates to control their own limits, privacy and profile.
- You want prospects to browse approved references without a rep in the middle.
- You are comfortable joining a pilot. lyynx is pre-launch and has no published customer results yet.
Moving without starting over
The work you put into a good spreadsheet carries over. lyynx imports a reference library from CSV using the columns in the customer reference library template, so a clean file becomes your starting library. Before you import, confirm consent is current for every row. For a full walkthrough of setting a program up, see the customer reference program guide.
What to ask before buying any platform
- Which of the problems above do you actually have today?
- Who will own the platform, and do they have time to keep it current?
- Can you import your existing file, and export everything later?
- What can advocates see and change for themselves?
- What documents (DPA, subprocessor list, security overview) can you review before signing?