UTM Builder Spreadsheet Templates for Managing Your URLs

A spreadsheet is the natural next step once a one-link-at-a-time builder is not enough. We tested the four formula patterns most UTM templates use – three of them break real links. Here is what to use instead, plus a free template.

When to use a UTM spreadsheet

A spreadsheet earns its place when you need memory. A simple builder forgets each link the moment you copy it; a sheet keeps every link in one place with the date, owner and destination next to it. That history answers “what did we call last year’s Black Friday campaign?” and makes consistency possible for a team of two to five people.

The sweet spot is roughly five to twenty links a month. Below that, maintaining a sheet is not worth the effort. Above it the sheet starts to strain: rows are copied with stale values, someone types over a formula, dropdowns are bypassed and the single source of truth splits into one copy per campaign manager.

Which template should you use?

Look at the formula before you look at the colours. A good template has three things: dropdowns for source and medium so people pick instead of type, a formula that treats the landing-page URL as something to parse rather than append to, and a locked output column. The tell-tale sign of a weak template is a formula beginning =A2&"?utm_source=" – it adds a second question mark to any page that already has one and buries your tags after any #fragment.

Evaluating UTM spreadsheet formulas

We entered the inputs from our four standard tests into a sheet, calculated each formula pattern in LibreOffice Calc using functions that also exist in Excel and Google Sheets, and scored every output with the same comparison our online tester uses.

Spreadsheet formula patterns compared across four tests
Formula pattern	Query params	Hash fragment	Combination	Space	Score
Plain concatenation `=A2&"?utm_source="&B2&"&utm_medium="&C2&…`	Fail	Fail	Fail	Fail	0/4
Checks for an existing “?” `=A2&IF(ISNUMBER(FIND("?",A2)),"&","?")&"utm_source="&B2&…`	Pass*	Fail	Fail	Fail	1/4
“?” check + TRIM / LOWER `=TRIM(A2)&IF(ISNUMBER(FIND("?",A2)),"&","?")&"utm_source="&LOWER(TRIM(B2))&…`	Pass*	Fail	Fail	Pass*	2/4
Fragment-aware (our template) `splits off the #fragment, chooses ?, & or nothing, trims, lowercases and encodes`	Pass*	Pass*	Pass*	Pass*	4/4

Pass* means the URL is equivalent to the expected output – only the cosmetic “/” after a bare domain is missing, which browsers add automatically. Test date: October 2026.

Why so many spreadsheets fail

Spreadsheets are excellent at arithmetic and poor at understanding structure. To a spreadsheet a URL is just text; it has no idea that the part after “?” is a list of parameters or that “#” marks a fragment that must stay last. JavaScript, by contrast, has a built-in URL parser: hand it https://example.com?coupon=1#top, ask it to add utm_source, and it puts the parameter in the right place and keeps #top at the end without being told.

Reproducing that with cell formulas means finding the positions of “?” and “#” yourself, slicing the text, deciding between “?”, “&” or nothing, trimming, encoding and reassembling – and every template author has to rediscover those cases. The failures are silent: the formula produces something that looks like a URL, and the problem only surfaces weeks later as a campaign missing from the report.

Free UTM spreadsheet template

Our template uses the fragment-aware formula from the table, adds dropdowns for source and medium fed from an editable Picklists tab (mediums outside the list are rejected), and comes with three example rows. It works in Excel 2013 and later, Excel for the web, Google Sheets (File → Import) and LibreOffice.

Download the template (.xlsx)

Show the formula (row 2)

=LEFT(TRIM(A2),IFERROR(FIND("#",TRIM(A2)),LEN(TRIM(A2))+1)-1)
&IF(RIGHT(LEFT(TRIM(A2),IFERROR(FIND("#",TRIM(A2)),LEN(TRIM(A2))+1)-1),1)="?","",
  IF(ISNUMBER(FIND("?",LEFT(TRIM(A2),IFERROR(FIND("#",TRIM(A2)),LEN(TRIM(A2))+1)-1))),"&","?"))
&"utm_source="&ENCODEURL(LOWER(SUBSTITUTE(TRIM(B2)," ","_")))
&"&utm_medium="&ENCODEURL(LOWER(SUBSTITUTE(TRIM(C2)," ","_")))
&"&utm_campaign="&ENCODEURL(LOWER(SUBSTITUTE(TRIM(D2)," ","_")))
&IF(TRIM(E2)="","","&utm_content="&ENCODEURL(LOWER(SUBSTITUTE(TRIM(E2)," ","_"))))
&IF(TRIM(F2)="","","&utm_term="&ENCODEURL(LOWER(SUBSTITUTE(TRIM(F2)," ","_"))))
&IFERROR(MID(TRIM(A2),FIND("#",TRIM(A2)),2000),"")

Known limits: it does not replace UTM parameters already present in the landing-page URL, and does not add the “/” after a bare domain (harmless).

Recommendation

For up to twenty links a month and a small team, use a template with a fragment-aware formula, dropdowns for source and medium, and one named owner. If you build links in batches, the bulk UTM builder does the same job without formulas – paste your sheet, generate, and download the CSV with the predicted GA4 channel for every row. Once several teams or agencies build links for the same site, move the rules into a tool that enforces them at the moment a link is created.