Bulk UTM Builder from Spreadsheet

How to use the bulk UTM builder

This bulk UTM builder turns a planning sheet into finished campaign links in one go. It writes the UTM tags described in Google's custom campaign URL guide, cleans every value the same way, and tells you which GA4 channel each link will count toward — before a single link goes live.

1. Start from your sheet. One row per link: the landing page plus the tag values. Try the sample first to see a sheet with typical mistakes.
2. Check the columns. Names like “Campaign Source”, “source” or “utm_source” are matched automatically. Add a name column so you can find each link later.
3. Set defaults for gaps. If every link in the sheet is for one campaign, type it once as the default instead of filling a whole column.
4. Read the problems. Rows marked “Fix first” would track badly; “Check” rows were built but changed something you should know about.
5. Download. Take the full results, or the short file with just names and tagged links for pasting into your ad platform or email tool.

What to do next with your tagged links

1. Paste each link where it will be clicked: the email button, the social post, the QR code, the partner's banner. For ads, the platform's own URL parameter field is often easier — see the builders for Meta, LinkedIn or TikTok.
2. Keep the sheet as your record. Save the results file next to your campaign plan so anyone can see which link went where.
3. Share one set of rules. If several people tag links, agree on sources and mediums in the UTM Naming Convention Builder and load that file here every time.
4. Check GA4 after launch. In Reports › Acquisition › Traffic acquisition, switch the table to Session source / medium and look for your new values.

Common mistakes in UTM spreadsheets

Spreadsheet formulas that leave spaces or capitals

A UTM builder Excel formula that joins cells with & copies whatever is typed: “Fall Sale” becomes a value with a space, “Facebook” stays capitalized. The builder lowercases and swaps spaces for you, so the sheet can stay readable.

A second question mark

Pages that already have ?ref=nav need the tags joined with &. Sheet formulas often add another ?, which breaks the tags. Existing parameters are kept here and the tags are added correctly.

Tags after the # sign

For a link to /careers/#open-roles, the tags must come before the #. The builder moves the anchor to the end.

Mediums GA4 doesn't recognize

Values such as print or qr match none of GA4's default channel rules, so those visits show as Unassigned. Each flagged row suggests a medium that works.

Two spellings of one value

paid_social on most rows and paid-social on one gives two lines in every report. The builder points out the odd one and the spelling most rows use.

Click IDs copied from a live ad

URLs copied from your browser after clicking an ad carry gclid or fbclid. Those belong to one click; the builder strips them, along with email recipient IDs such as mc_eid.