Intellectual Property Register Template for Excel

What is an intellectual property register?

An intellectual property register is a single record of every IP asset an organization owns — patents, trademarks, copyrights, domains, licenses, and trade secrets — with its registration details, key dates, and the chain of assignments that proves title.

A trademark’s Section 8 window closes with no one having calendared it. Diligence counsel asks for the full portfolio, including reel and frame recording data for every assignment, and the answer sits scattered across old counsel emails. This intellectual property register template for Excel keeps that record in one place before either moment arrives.

This is a record of title, not an automated system. It carries raw dates — maintenance windows, Section 8 due dates, renewals — with no formulas and no built-in alerts.

What’s inside the Excel workbook

This intellectual property register template ships as one Excel workbook, 11 sheets deep. A Start Here tab leads, followed by 10 data sheets covering registered rights, assignment chains, licenses, domains, and trade secrets. Together they hold 155 fields behind 21 pre-built dropdown lists, and the workbook opens in Google Sheets as well as Excel.

Registered rights and maintenance

Patents, Trademarks, and Copyrights form the registered-rights core of this patent tracking template for Excel. Patents — 18 fields — carries a maintenance window open date, close date, and last-paid date for every patent, alongside type, jurisdiction, and priority claims.

Trademarks — 15 fields — carries the Section 8 due date and next renewal date for every mark. A lapsed filing here turns into a lost mark, and the use-in-commerce date is what a Section 8 filing depends on. Copyrights — 13 fields — records work type, registration number, and publication date, including Software and Sound Recording as first-class types.

Assignment chains and title

Patent Assignments, Trademark Assignments, and Copyright Assignments are the signature depth of this template’s assignment chain tracking. Each gives one row to one conveyance rather than a single “assigned” checkbox.

Patent Assignments — 18 fields — records reel and frame numbers, conveyance text, consideration and consideration type, and recording status for every transfer. Trademark Assignments — 18 fields — adds whether the deal included goodwill and which classes it assigned. Copyright Assignments — 19 fields — carries rights transferred, territory, and term.

A flat single-table tracker has no row for any of this; it can only note that an asset changed hands, not prove how.

Licenses, domains, and trade secrets

IP Licenses — 20 fields — is this workbook’s ip license tracking spreadsheet. It records exclusivity (Exclusive, Non-Exclusive, Sole), royalty rate, royalty basis (Net Sales, Gross Revenue, Per Unit, Flat Fee), minimum, period, and sublicensing rights. Licensed Assets — 8 fields — is the junction sheet tying each license to the specific patents, trademarks, or copyrights it covers.

Domain Names — 13 fields — tracks every domain in the portfolio, holding registrar, auto-renew status, privacy protection, nameservers, and any associated trademark.

Trade Secret Registry — 13 fields — holds every documented trade secret by category. Options include Formula, Process, Method, Customer List, Source Code, Business Plan, and Design. Each row also carries business value, access restricted to, protective measures, NDA required, and disclosure risk (High, Medium, Low).

How to build an IP register

To build an intellectual property register in Excel:

1. Add a row per asset on its type sheet. Every patent, trademark, copyright, domain, license, and trade secret gets its own row on the sheet that matches its type.
2. Record registration or serial numbers, jurisdiction, and key dates. These fields are what turn a list of assets into a searchable register.
3. Log every conveyance on the matching Assignments sheet. Reel and frame numbers, consideration, and recording status go on a new row — never overwrite a prior conveyance.
4. Put licenses on IP Licenses, tied to specific assets through Licensed Assets. The junction sheet keeps one license from needing its own copy of every asset’s details.
5. Document trade secrets with their access restrictions. Business value and protective measures belong on the same row as the restriction itself.
6. Sort Patents by next maintenance date. That single sort surfaces the closest patent deadline first.
7. Sort Trademarks by Section 8 due date. The same sort on this sheet surfaces the closest mark deadline first.

One row per asset

Each row on a type sheet should represent exactly one asset. Each conveyance should get its own row on the matching Assignments sheet. Flattening a chain of title into a notes cell loses exactly what this register exists to hold.

Maintenance and renewal dates

Sort or filter Patents by maintenance window close date. Or use Trademarks, a standalone trademark tracking spreadsheet template, filtered by Section 8 due date. The nearest deadline in either sheet rises to the top — most of what it takes to track patent and trademark renewals in Excel.

A patent’s maintenance window and a mark’s Section 8 date run on different clocks, so a shared sort keeps both visible at once. Add your own conditional-formatting rule to either date column for a visual cue between sorts. In Excel: Home > Conditional Formatting > Highlight Cells Rules > A Date Occurring.

The same approach makes IP Licenses double as a copyright and IP license renewal tracker: sort its period field the same way.

The workbook ships with raw dates only. It carries no formulas or built-in alerts, and nothing here fires a reminder until you set one up.

Built for IP and legal teams

IP counsel, general counsel, legal ops, and finance or tech-transfer managers at technology companies feel a fragmented IP record first. Multi-entity organizations feel it too — they’re the ones asked to produce the full portfolio and its title chain the moment diligence counsel calls.

Free trackers online typically stop at a single patents, trademarks, or copyrights table. This ip portfolio spreadsheet template runs the opposite way. It carries the full portfolio surface — domains, licenses, trade secrets — alongside the assignment chain behind every registered right.

Every asset keys to its holding entity. A group with several subsidiaries shares one register instead of a spreadsheet per entity.

When a spreadsheet stops working

This register covers a growing IP portfolio before it runs into real edges. There’s no version history, so an overwritten maintenance date erases its own past. With more than one person editing the file, nothing restricts who can see a sensitive trade secret’s row.

Nothing fires an alert when a Section 8 date or a maintenance window comes due. That gap can run for months. It usually surfaces during a diligence request or as a lapsed right nobody caught in time.

From workbook to system

This template’s column headers match Lextree’s import templates, so it loads directly into intellectual property management software — no re-keying, no remapping.

Renewals that surface themselves

From there, dates drive reminders instead of waiting for someone to open the sheet. IP counsel at technology companies use them so a Section 8 deadline chases itself instead of surfacing at the next diligence request.

Frequently asked questions

What is an intellectual property register? An intellectual property register is a single record of every IP asset an organization owns — patents, trademarks, copyrights, domains, licenses, and trade secrets — with its registration details, key dates, and the chain of assignments that proves title.

What should an IP register include? A complete register covers registered rights — patents, trademarks, copyrights — with their maintenance and renewal dates, plus the assignment chain behind each one. It also covers domain names, IP licenses with royalty terms, and a trade secret registry with access restrictions. Most free trackers only cover the first piece.

Is this IP docketing software? No. This is a record of title in Excel, not a docketing engine. It holds raw dates — maintenance windows, Section 8 due dates, renewal dates — with no automated docketing and no reminders built in.

Does this cover invention disclosures or patent filing? No. This template tracks IP an organization already owns or has already filed. It includes no invention disclosure forms and no patent-prosecution workflow — those happen with outside counsel, before an asset ever reaches this register.

How do I track patent and trademark renewals in Excel? Patents carries a maintenance window open date, close date, and last-paid date for every patent. Trademarks carries a Section 8 due date and a next renewal date for every mark. Sort either sheet by its date column to see what’s coming due first.

How does the template track an assignment chain of title? Patent Assignments, Trademark Assignments, and Copyright Assignments each give one row to one conveyance — assignor, assignee, consideration, and recording status. Reel and frame numbers apply for patents and trademarks. Nothing overwrites a prior conveyance; the full chain stays on record.

Can I track trademark Section 8 and renewal deadlines? Yes. Trademarks carries a Section 8 due date and a next renewal date on every row. The use-in-commerce date that a Section 8 filing depends on sits alongside them.

Does it track IP licenses and royalties? Yes — IP Licenses records license type, territory, and exclusivity (Exclusive, Non-Exclusive, Sole). It also carries royalty rate, royalty basis (Net Sales, Gross Revenue, Per Unit, Flat Fee), minimum, period, and sublicensing rights. Licensed Assets then ties each license to the specific patents, trademarks, or copyrights it covers.

Can I track domain names and trade secrets? Yes. Domain Names holds registrar, auto-renew status, privacy protection, and any associated trademark for every domain. Trade Secret Registry holds category, business value, access restrictions, protective measures, and disclosure risk for every documented secret.

Who is this template for? IP counsel, general counsel, legal ops, and finance or tech-transfer managers at technology companies and multi-entity organizations turn to this template. They’re the people asked to produce a full portfolio and its title chain at diligence.

Is the template free, and does it work in Google Sheets? Yes. Enter your email below and the workbook is sent to your inbox — no credit card, no sales call. It opens in Google Sheets as well as Excel, dropdowns included.

Is there a free IP register template for Excel? Yes — this one. It’s a free workbook with 11 worksheets and 155 fields, sent to your email, and it opens in Google Sheets as well as Excel.