Referral Tracking Spreadsheet

Run a referral programme: log who referred whom, track each referral to conversion and reward referrers fairly.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Human Resources

Tables

Referrers, Referrals

Fields

22

Views

grid, kanban, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Referrers

9 fields · 3 sample rows

  • Leaderboard (Grid)
ReferrerTextTypeSingle selectEmailEmailReferral codeTextReferralsLink to another tableReferrals madeCountConvertedRollupRewards earnedRollupConversion rateFormula
Meera JoshiCustomer[email protected]MEERA10Kunal Shah, Sneha Agarwal21₹2,40050%
David ChenPartner[email protected]DCHENLaura Bianchi, Tomás Silva21₹12,00050%
Aditi KulkarniEmployee[email protected]ADITI-EMPVarun Khanna10₹00%
Field details
Referrer · Text
Type · Single select
Employee, Customer, Partner, Alumni
Email · Email
Referral code · Text
Referrals · Link to another table
Links to Referrals
Referrals made · Count
Converted · Rollup
sum of Converted (0/1) via Referrals
Rewards earned · Rollup
sum of Reward via Referrals
Conversion rate · Formula
IF({Referrals made} > 0, {Converted} / {Referrals made}, BLANK())

Referrals

13 fields · 5 sample rows

  • All referrals (Grid)
  • Pipeline (Kanban)
  • Submit a referral (Form)
  • Programme (Dashboard)
Referred personTextReferred byLink to another tableEmailEmailPhonePhoneChannelSingle selectReferred onDateStatusSingle selectDeal valueCurrencyRewardCurrencyReward statusSingle selectConverted (0/1)FormulaDays openFormulaNotesLong text
Kunal ShahMeera Joshi[email protected]WhatsApp10 Oct 2026Converted₹48,000₹2,400Paid1
Laura BianchiDavid Chen[email protected]Email25 Oct 2026Converted₹1,20,000₹12,000Pending1
Sneha AgarwalMeera Joshi[email protected]+91 98300 45454Referral link11 Nov 2026QualifiedNot due08
Tomás SilvaDavid Chen[email protected]In person4 Nov 2026LostNot due0Went with a competitor on price.
Varun KhannaAditi Kulkarni[email protected]Social media16 Nov 2026ContactedNot due03
Field details
Referred person · Text
Referred by · Link to another table
Links to Referrers
Email · Email
Phone · Phone
Channel · Single select
WhatsApp, Email, Social media, In person, Referral link
Referred on · Date
Status · Single select
Invited, Contacted, Qualified, Converted, Lost
Deal value · Currency
INR
Reward · Currency
INR
Reward status · Single select
Not due, Pending, Paid
Converted (0/1) · Formula
IF({Status} = 'Converted', 1, 0)
Days open · Formula
IF(AND({Referred on}, {Status} != 'Converted', {Status} != 'Lost'), DATETIME_DIFF(TODAY(), {Referred on}, 'days'), BLANK())
Notes · Long text

Form view “Refer a friend” asks for: Referred person, Referred by, Email, Phone, Channel, Notes.

Referral Tracking Spreadsheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates