Names Organizer
Windows 10 & 11 Buy license · $49.95
Portfolio

Domain Tracking Spreadsheet: The Columns to Include and Where It Falls Short

Build a domain tracking spreadsheet with the columns that matter: registrar, expiry, auto-renew, DNS and costs. Plus where spreadsheets fall short.

Updated 5 minute read The Names Organizer team

A useful domain tracking spreadsheet has one row per domain and columns for the registrar and account, expiry date, days remaining, auto-renew status, lock status, nameservers, renewal price and purpose. Add a formula that counts down the days and conditional formatting that turns rows red as expiry approaches. It is a solid start for a small portfolio, but every date in it goes out of date at the next renewal, so plan for that from day one.

Below is a column layout that works, the Excel formulas to make it useful, and an honest look at when a spreadsheet stops being enough.

The columns to include

Start with the essentials and add the optional columns only if you will actually maintain them. An empty column is worse than none, because it looks like data.

ColumnExampleEssential?
Domainexample.comYes
RegistrarThe registrar's nameYes
Account / loginWhich account at that registrar holds itYes
Expiry date2027-03-14Yes
Days leftFormulaYes
Auto-renewOn / OffYes
PurposeMain site, redirect, email only, parked, for sale, defensiveYes
Owner or clientWhich business or client it belongs toIf you manage for others
Lock statusLocked / UnlockedRecommended
NameserversWhich DNS providerRecommended
Renewal pricePer yearRecommended
SSL expiryDate the certificate expiresIf the domain hosts a site
Purchase price, offers, sale priceFor investorsInvestors
NotesAnything elseOptional

Do not store passwords in the spreadsheet. Record which account holds each domain and keep the credentials in a password manager.

Formulas that make it useful in Excel

Days until expiry

If the expiry date is in column D, put this in the "Days left" column and fill it down:

=D2-TODAY()

Format the cell as a number, not a date. Negative numbers mean the domain has already expired.

Highlight domains that need attention

  1. Select the "Days left" column.
  2. Go to Home → Conditional Formatting → Highlight Cells Rules → Less Than.
  3. Enter 30 and choose a red fill.
  4. Add a second rule for less than 90 with a yellow fill.

To make auto-renew problems stand out too, add a rule that highlights "Off" in the auto-renew column.

Keep values consistent

Use Data → Data Validation → List for columns such as auto-renew, lock status and purpose, so entries are always "On" or "Off" rather than a mix of "yes", "Y" and "on". Consistent values make filtering reliable.

Monthly renewal totals

Add a helper column with =TEXT(D2,"yyyy-mm") to get the renewal month, then use SUMIFS or a PivotTable to total the renewal price per month. That gives you a simple renewal budget. Our guide to building a domain renewal budget goes further.

Filling it in for the first time

  1. Export the domain list from each registrar as CSV, if they offer it, and paste the exports into one sheet.
  2. Line the columns up, because every registrar names them differently.
  3. Remove duplicates with Data → Remove Duplicates on the domain column.
  4. Look up any missing expiry dates with RDAP or WHOIS.
  5. Fill in the purpose and owner columns by hand. Only you know these.

Our guide to exporting your domain list from a registrar covers the first step in more detail.

Keeping the spreadsheet current

A spreadsheet is only as good as its last update. If you stick with one, give it a fixed routine:

  1. After every renewal, look up the domain and type in the new expiry date the same day. Do not assume it moved exactly one year; multi-year renewals and transfers change it by more.
  2. Once a month, sort by "Days left" and review everything under 90 days. Check that auto-renew is on and the card is valid for each.
  3. Once a quarter, look up every domain's nameservers and status and compare them with the sheet. Any difference you cannot explain needs investigating.
  4. Whenever you buy, sell or drop a domain, add or archive the row immediately. Move dropped domains to a separate tab rather than deleting them, so you keep the history.
  5. Keep one master copy in a single shared location, and record who last updated it in a cell at the top.

If that routine feels like a lot of upkeep for what it delivers, that is the strongest sign it is time to automate.

Where spreadsheets fall short

Spreadsheets are flexible and familiar, and for five or ten domains at one registrar they may be all you need. As the list grows, the same problems keep appearing:

  • Dates go stale. Every renewal moves an expiry date forward a year, and the spreadsheet does not know. Unless someone updates it, your "days left" column starts counting down to dates that have already been extended, and real problems hide among false alarms.
  • It only alerts you when you open it. Conditional formatting cannot email you at 2 a.m. on the day a domain expires.
  • Status changes are invisible. A domain that is unlocked, put on hold or moved to new nameservers looks exactly the same in a spreadsheet.
  • Manual lookups do not scale. Checking forty domains by hand every month is the task that quietly stops happening.
  • Copies multiply. Once a spreadsheet is emailed around, there are several versions and none of them are current.

When to move to a domain manager

Consider switching when any of these become true: you have more than about ten domains, they are at more than one registrar, you manage domains for clients, or you have already had one near miss. At that point the time spent updating dates by hand is better spent elsewhere.

The good news is that your spreadsheet is not wasted. Names Organizer, a domain manager for Windows, imports CSV and Excel files directly. You map your columns once, the mapping is remembered for next time, and duplicates are detected automatically. It then looks up each domain through WHOIS and RDAP and fills in the registrar, dates, nameservers and status, keeping them current every time you refresh.

The columns you care about carry across too. Names Organizer has custom fields for anything specific to your business, tags and color labels for purpose and status, clients and portfolios for grouping, and purchase, renewal and sale prices for investors. It warns you before domains and SSL certificates expire, and when you need a spreadsheet again you can export any view to Excel or CSV with the columns you choose. See how to manage multiple domain names for the full routine.

Frequently asked questions

What should I track for each domain?

At minimum: domain, registrar and account, expiry date, auto-renew status, nameservers, renewal price and who the domain belongs to. Investors should add purchase price, offers and sale price.

How do I keep expiry dates in a spreadsheet up to date?

You have to look each domain up again after every renewal, which is why spreadsheets drift. Tools that refresh WHOIS or RDAP data automatically remove that chore.

Can I import my domain spreadsheet into domain software?

Usually yes. Save it as CSV or Excel and map the columns on import. Most tools only need the domain names and can look up the rest.

Get three guides like this every month, plus software update notices.Subscribe →