New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Use-case templates›Lead tracker template

Google Sheets · Verified tutorial

Lead tracker template in Google Sheets

Build the Lead tracker template by replacing A1:D4 with exactly the table below. Preserve the row and column order. Lead Source Score Status L-101 Referral 92 Qualified L-102 Search 74 Contacted L-103 Event 61 New.

Verified by PhilisJuly 15, 2026About 120 seconds

Quick answer

Build the Lead tracker template by replacing A1:D4 with exactly the table below. Preserve the row and column order. Lead Source Score Status L-101 Referral 92 Qualified L-102 Search 74 Contacted L-103 Event 61 New.

Step-by-step

1

Select the targetBuild the Lead tracker template by replacing A1:D4 with exactly the table below.

2

Complete the next actionPreserve the row and column order.

3

Apply the changeLead Source Score Status L-101 Referral 92 Qualified L-102 Search 74 Contacted L-103 Event 61 New.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

A1:D4 contains the complete Lead tracker template.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A1:D4 and repeat the final action. A1:D4 contains the complete Lead tracker template.

Example spreadsheet data

This is the clean fixture used for the verified run.

Lead

Source

Score

Status

Video transcript

Open the prepared Lead tracker spreadsheet.
Select the target. Build the Lead tracker template by replacing A1:D4 with exactly the table below.
Complete the next action. Preserve the row and column order.
Apply the change. Lead Source Score Status L-101 Referral 92 Qualified L-102 Search 74 Contacted L-103 Event 61 New.
A1:D4 contains the complete Lead tracker template.