# Moving an IPR cell from spreadsheets to an IPMS: a six-week plan

URL: https://zernyxhub.com/blog/spreadsheet-to-ipms
Author: Dr. Deepak Chitkara, Founder, Zernyx Innovations
Published: 2026-11-04
Category: Technology transfer

> A six-week plan to move a university IPR cell from spreadsheets to a patent management system: data checks, Indian deadlines, roles and a parallel run.

**Short answer:** An IPR cell can move from spreadsheets to an IP management system in about six weeks: list every case, check key dates against IP India records, set deadline rules, pilot one department, then import the rest and run both in parallel. The dates to rebuild include the 12-month complete specification, 31-month Form 18 and six-month FER reply windows.

Most university IPR cells start on a spreadsheet, and for the first twenty cases that is fine. Then the portfolio grows, a second person joins, a renewal is paid late, and someone suggests software. The decision to buy is the easy part. The move is where offices lose data, confidence and occasionally a deadline.

This is a practical six-week plan for that move. It assumes you have already chosen a system; if you have not, [IP management software for universities](https://zernyxhub.com/blog/ip-management-software-university) covers what to look for.

## Before you start: one owner, one freeze date

Two decisions come first.

Name one owner for the migration. In a small cell this is usually the IPR officer, with an hour a week from the faculty coordinator. Shared ownership produces a half-finished import.

Pick a freeze date. From that date, new cases go into the new system only. Without a freeze, the spreadsheet keeps changing while you copy it.

## The six-week plan

The plan below suits a cell with up to a few hundred cases. A larger portfolio needs the same steps over a longer period, with the date checks in week 2 split across several people.

**Six weeks from spreadsheet to IPMS**
- Week 1, Inventory and owners: Every case, every document
- Week 2, Check dates with IP India: Priority, filing, FER, grant
- Week 3, Deadline rules and roles: Who gets which reminder
- Week 4, Pilot one department: Import, check, fix
- Weeks 5 to 6, Full import, parallel run: Then retire the sheet

## Week 1: inventory

List every case in one table: Indian applications, PCT applications, foreign filings, granted patents, designs, copyrights and agreements with obligations (licences, MTAs, funder conditions). For each, note where the documents live: email, shared drive, the attorney's office. Close cases (abandoned, lapsed) get a status, not deletion; you will need their history.

## Week 2: check every key date against official records

This is the week that matters. For each live Indian case, check the application number, filing date, priority date, publication, examination request, first examination report date and grant date against IP India's public records. For PCT cases, check the priority date and international filing date.

Mark each case "verified" with the date and initials. Do not import anything unverified. Pay particular attention to priority dates for applications that started as provisionals, where the provisional's date and the complete specification's date are easily confused.

## Week 3: deadline rules and roles

Write down the deadline rules the system must apply, then check it applies them. The core Indian ones:

| Deadline | Time limit | Source |
|---|---|---|
| Complete specification after a provisional | 12 months from filing the provisional | Patents Act s.9(1) |
| Request for examination (Form 18) | 31 months from priority or filing, whichever is earlier | Rule 24B(1); applications filed before 15 March 2024 keep the earlier period |
| Reply to first examination report | 6 months from issue, extendable by 3 months on Form 4 | Rule 24B(5) and (6) |
| Renewal fee | At the end of the second year from the date of the patent, then yearly; up to 6 months' extension on Form 4 | Rule 80(1) and (1A) |
| Statement of working (Form 27) | Within 6 months after each block of three financial years | Section 146; [IP India Form 27 FAQs](https://ipindia.gov.in/frontend/pdf/patents/1001_1_final_faqs_form-27_26thaugust2024.pdf) |
| PCT national phase in India | 31 months from priority | [Rule 20(4)(i)](https://ipindia.gov.in/acts/patent-rules-2003/rule-20) |

Sources for the rules: [rule 24B](https://ipindia.gov.in/acts/patent-rules-2003/rule-24b) and [rule 80](https://ipindia.gov.in/acts/patent-rules-2003/rule-80) on IP India's site. Rules change; recheck them each year, and note that the 2024 amendments changed several periods for new applications only.

Then assign roles. Each deadline type gets an owner and a backup. The faculty inventor is told, but never the only person reminded.

## Week 4: pilot one department

Import one department's cases, ideally one with a mix of provisionals, pending applications and granted patents. Compare the system's calculated deadlines with your verified spreadsheet case by case. Every mismatch is either a data error or a rule error; find out which and fix the cause, not just the case.

## Weeks 5 and 6: full import and parallel run

Import the rest in batches. Run the spreadsheet (now read-only) and the system side by side for at least the remaining two weeks, and for one to two months if your portfolio is large. When the system's reminders have matched the sheet for a full cycle, archive the spreadsheet and tell everyone it is retired.

## A worked example: one cell's migration

**Illustration with invented figures.** A state university's IPR cell has 126 records: 58 pending Indian applications, 31 granted patents, 9 PCT applications, 16 lapsed or abandoned cases and 12 agreements with obligations.

| Week | Work done | Finding |
|---|---|---|
| 1 | 126 records listed, documents located | 7 cases had documents only in a former officer's email |
| 2 | 98 live patent cases checked against IP India records | 9 priority dates and 4 grant dates were wrong in the sheet |
| 3 | Six deadline rules set, owners named | Form 27 had never been tracked for licensed patents |
| 4 | 22 cases from one department imported | 2 rule settings fixed after comparison |
| 5 to 6 | Remaining cases imported; parallel run | No mismatches in the last 10 days |

The two findings that justify the whole exercise are the 13 wrong dates and the untracked Form 27 duty. Either could have cost a patent or a penalty. Neither had anything to do with software; they came from checking.

## Documents, not just dates

A docket that holds dates but not documents only solves half the problem. During weeks 5 and 6, attach to each case the documents someone will need in a hurry: the filed specification, the examination report and reply, the grant certificate, the assignment from inventors, and any licence or funder agreement that touches the patent. Name files the same way for every case, for example application number, document type and date. When an examination reply is due in three weeks and the attorney asks for the original disclosure, this is the step that saves a day of searching through a former officer's email.

## What changes for people

A system is a change in how people work, and that is where many rollouts stall. Three habits help:

1. Every new disclosure and filing goes into the system on the day it happens, by the person who handled it.
2. The weekly IPR cell meeting opens with the system's list of deadlines due in the next 60 days.
3. Reports to the IP committee come from the system, not from a fresh spreadsheet built for the meeting.

If the third habit does not take, the old spreadsheet tends to come back, because the committee keeps asking for it. Ask for system reports from the first meeting after the move.

## Common mistakes

- Importing before checking dates against IP India records.
- Tracking patents but not agreements, so licence and funder obligations stay in email.
- One person receiving every reminder, with no backup.
- Leaving the spreadsheet editable during the parallel run.
- Treating the migration as an IT project. It is a records project that happens to use software.

[Zernyx IPMS](https://ipms.zernyxhub.com/) is an IP lifecycle management platform for universities and research institutions, to manage patents, filings and IP portfolios end to end. If you are planning a move, test it with your pilot department first. For the deadline you are most likely to miss during the move, see [FER deadline tracking](https://zernyxhub.com/blog/fer-deadline-tracking), and for renewal decisions, [patent renewal in India](https://zernyxhub.com/blog/patent-renewal-india).

## Common questions

### How long does it take to move patent records from spreadsheets to an IPMS?

For a university with up to a few hundred cases, about six weeks is realistic if one person owns the project and IP India records are checked for every live case. The checking, not the software, takes most of the time.

### Which Indian patent deadlines must a new system track?

At least: the complete specification within 12 months of a provisional (section 9(1)), Form 18 within 31 months of priority (rule 24B(1)), the reply to the first examination report within six months, extendable by three on Form 4 (rule 24B(5) and (6)), annual renewal fees from the end of the second year (rule 80), Form 27 every three financial years and PCT national phase within 31 months (rule 20(4)(i)).

### Should we keep the spreadsheet after moving?

Keep it read-only for one or two months while both run in parallel, then archive it. Running two live records for longer is how deadlines get missed, because nobody is sure which one is right.

### What is the biggest risk in an IPMS migration?

Importing wrong dates. A priority date typed wrongly in a spreadsheet becomes a wrong Form 18 or renewal deadline in the new system. Verify key dates against IP India's records before import, not after.

---

Published by Zernyx Hub. More: https://zernyxhub.com/llms.txt
