Free UTM Tracking Spreadsheet Template
A ready-to-use Excel template with auto-generated UTM links, dropdown menus, naming rules, and copy-paste examples for 18 platforms.
Updated April 2026 · Excel + Google Sheets compatible
No signup. No email. Just click and download.
Download UTM Template (.xlsx)Works in Excel, Google Sheets, LibreOffice, and Numbers
What's Inside the Template
This isn't just a blank spreadsheet with column headers. It's a complete UTM tracking system with four tabs designed to keep your team organized from day one.
Tab 1: UTM Link Builder
The main tracker. Type your URL, source, medium, and campaign — the full UTM link is generated automatically using a formula. Includes dropdown menus for source (13 common platforms) and medium (13 standard values) so you never have to guess. Room for 50 links out of the box.
Tab 2: Naming Rules
A cheat sheet of the 8 most important UTM naming conventions. Each rule shows a wrong example and a right example so anyone on your team can follow the standard. Also includes a table of 9 standard medium values with their GA4 channel mapping.
Tab 3: Platform Examples
Ready-to-use UTM examples for 18 platforms: Google Ads (Search, Display, PMax), Facebook, Instagram, TikTok (paid + organic), LinkedIn (paid + organic), email tools (Mailchimp, HubSpot, Keap), YouTube, Reddit, Telegram, Dribbble, QR codes, and affiliate/partner links.
Tab 4: Quick Reference
A one-page reference card explaining what each UTM parameter does in plain English. Print it or keep it open while building campaigns. Includes links to deeper guides for each topic.
Why Track UTMs in a Spreadsheet?
Online UTM builders (including our own) are great for creating one link at a time. But when you're managing 20+ campaigns across multiple platforms, you need a central place to track everything.
A spreadsheet gives you three things an online tool can't:
A single source of truth
Every UTM link your team has ever created, in one file. No more searching through Slack, email, or ad platforms to find the right link. When your boss asks "what UTM did we use for the spring campaign?", you have the answer in seconds.
Naming consistency
Dropdown menus force everyone to use the same source and medium values. No more "Facebook" vs "facebook" vs "fb" splitting your GA4 data into three separate rows. The template enforces your naming rules automatically.
Team sharing
Upload the file to Google Drive and your whole team can access it. Everyone creates links from the same template, follows the same rules, and can see what campaigns are running. Works in Google Sheets, Excel, and LibreOffice.
How to Use the Template
Download and open
Download the .xlsx file and open it in Excel, Google Sheets, or LibreOffice. If using Google Sheets, go to File → Import → Upload and select the file.
Delete the example rows
The first five rows have sample data to show you how it works. Delete them and start filling in your own campaigns. The UTM formula in column G will generate your full link automatically.
Use the dropdowns for source and medium
Click on any cell in column B (Source) or C (Medium) and you'll see a dropdown arrow. Pick from the pre-filled list or type your own custom value. The dropdowns keep your team consistent.
Copy the generated link from column G
The full UTM link appears automatically. Copy it and paste it into your ad platform, email tool, or social media post. The formula handles the ? and & characters for you — no manual string building needed.
Check the Naming Rules tab if you're unsure
Not sure what medium to use for TikTok ads? Check the Naming Rules tab for the standard values and GA4 channel mappings. Need an example? The Platform Examples tab has ready-to-copy UTMs for 18 platforms.
Tips for Getting the Most Out of This Template
Add it to Google Drive for team access
Upload to Google Drive and open with Google Sheets. Share the link with your team. Everyone creates UTM links from the same file, which prevents the "I used my own naming convention" problem.
Add custom dropdowns for your specific platforms
The template includes 13 common source values, but you can customize the dropdown list. In Excel: Data → Data Validation → edit the list. In Google Sheets: Data → Data Validation → edit criteria.
Add a "Status" column for campaign tracking
Insert a column after Notes with values like "active", "paused", "ended". This turns the spreadsheet into a lightweight campaign management tool on top of UTM tracking.
Version it by quarter
Create a new copy each quarter (Q1_2026, Q2_2026) so your spreadsheet doesn't grow forever. Archive old ones for reference. This keeps the file fast and focused on what's currently running.
Frequently Asked Questions
Does this work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, dropdowns, and formatting all carry over. Some minor styling differences may appear but everything functions the same.
Can I add more than 50 rows?
Yes. Just copy the formula from column G in any existing row and paste it into new rows. The dropdown validation extends to row 56 by default — you can extend it by editing the data validation range.
Can I customize the dropdown values?
Yes. In Excel: select the cells with dropdowns → Data → Data Validation → edit the Source list. In Google Sheets: select cells → Data → Data Validation → edit the Criteria. Add or remove values as needed for your team.
Do I need to install anything?
No. The template is a standard .xlsx file that opens in any spreadsheet app — Microsoft Excel, Google Sheets, LibreOffice Calc, or Apple Numbers. No macros, no plugins, no add-ons.
Is there a Google Sheets version?
The .xlsx file works directly in Google Sheets — just upload and open. We chose .xlsx as the download format because it's universally compatible with all spreadsheet apps. No separate Google Sheets version is needed.
How is this different from an online UTM builder?
Online UTM builders create one link at a time. This spreadsheet is a tracker — it stores all your UTM links in one place, enforces naming rules with dropdowns, and gives your team a shared reference. Use both: the online builder for quick one-off links, the spreadsheet for campaign management.