Free subscription tracker template
A ready-made spreadsheet for every subscription you pay for: name, price, billing cycle, category, status and next renewal date. Works in Google Sheets, Excel, Numbers and LibreOffice, and imports into the free MapSub tracker if you'd rather have totals and reminders done for you.
No sign-up. The file is 1 KB with 4 example rows to overwrite.
What's in the template
| Name | Price | Billing | Category | Status | Next renewal | Usage | Yearly plan price | Cancelled on | Notes |
|---|---|---|---|---|---|---|---|---|---|
| Video streaming (example) | 17.99 | monthly | Streaming & entertainment | active | 2026-12-05 | often | Replace these example rows with your own | ||
| Music (example) | 11.99 | monthly | Music & audio | active | 2026-12-12 | often | 119.99 | Has a cheaper yearly plan | |
| Cloud storage (example) | 99.99 | annual | Cloud & storage | active | 2027-03-01 | sometimes | |||
| Photo app (example) | 9.99 | monthly | Software & productivity | trial | 2026-11-20 | sometimes | Trial ends on the renewal date |
- Billing: weekly, monthly, quarterly, semiannual, annual.
- Status: active, trial, paused, cancelled. Set trials' "Next renewal" to the day the trial turns paid.
- Category: Streaming & entertainment, Music & audio, Software & productivity, AI tools, Cloud & storage, News & reading, Fitness & health, Gaming, Shopping & memberships, Utilities & phone, Other.
- Dates: 2026-12-05 works everywhere; 12/5/2026 is read as December 5.
How to use it in Google Sheets
- Download the CSV, then in Google Sheets choose File › Import › Upload and pick the file.
- Replace the example rows with your own. Bank and card statements from the last two months catch most subscriptions; our guide to finding forgotten subscriptions covers the rest.
- Add the formulas below in columns K to M and fill them down.
How to use it in Excel
- Open the CSV in Excel, then File › Save As › Excel Workbook (.xlsx) so your formulas are kept.
- Add the formulas below. Format the "Next renewal" column as a date.
Formulas to add
Put these in row 2 and copy them down. They turn every price into a monthly and yearly cost the same way the subscription cost calculator does (weekly plans use 52.18 charges a year).
| Column | Formula |
|---|---|
| Monthly cost (column K) | =B2*SWITCH(C2,"weekly",365.25/7/12,"monthly",1,"quarterly",1/3,"semiannual",1/6,"annual",1/12,1) |
| Yearly cost (column L) | =K2*12 |
| Days until renewal (column M) | =IF(F2="","",F2-TODAY()) |
| Total per month (anywhere) | =SUMIFS(K:K,E:E,"<>cancelled",E:E,"<>paused") |
Spreadsheet or tracker?
A spreadsheet is flexible and yours to change. The MapSub tracker does the upkeep: it rolls renewal dates forward on its own, lists the next 30 days of charges, spots overlapping services and rarely used plans, and exports reminders to your calendar. It keeps your list in your browser only, like a spreadsheet on your own computer. You can start in one and move to the other at any time: the tracker exports the same CSV and imports this template.
Questions and answers
Is the subscription tracker template free?
Yes. Download the CSV, open it in Google Sheets, Excel, Numbers or LibreOffice, and use it however you like. No email address or sign-up.
Why a CSV and not an .xlsx file?
CSV opens in every spreadsheet app and imports straight into the MapSub tracker. Add the formulas below once and save in your app's own format if you want to keep them.
Why does SWITCH not work in my spreadsheet?
SWITCH needs Excel 2019 or later, Microsoft 365, or Google Sheets. In older Excel, use nested IFs: =IF(C2="monthly",B2,IF(C2="annual",B2/12,IF(C2="quarterly",B2/3,IF(C2="weekly",B2*365.25/7/12,B2/6)))).
Can I move from the spreadsheet to the MapSub tracker later?
Yes. Export or save the sheet as CSV and choose Import backup or CSV in the tracker. It reads these exact columns, and also any sheet with at least Name and Price columns.