← All articles
BLOG

Moving your license list out of a spreadsheet

· Updated · 3 min read

Plenty of businesses track licenses in a spreadsheet, and for a while it works. The trouble is that a spreadsheet only helps when someone opens it — and it can’t tell anyone that a renewal is coming.

Moving to a tracking system is mostly a matter of tidying the list you already have. Here’s a checklist.

When a spreadsheet stops being enough

  • More than one person edits it, and nobody is sure which copy is current.
  • Someone has to remember to open it, and remembering is the job you wanted done for you.
  • The documents live somewhere else, so checking a date means a second search.
  • A dropped filter or a mistyped date is easy to miss, and nothing warns you.
  • You’d struggle to show someone else what’s coming due this quarter.

Tidy the sheet first

  • One row per license, permit or certificate — not one row per person with several dates in it.
  • One column per fact: holder, type, number, issuer, expiration date.
  • Real dates in the date column, in one format, rather than notes like “spring” or “check”.
  • The same spelling of each holder’s name on every row.
  • Leave a date blank if you’re not sure of it. A blank is easier to fix than a wrong date that looks right.

Look for the problems that hide in old sheets

  • Duplicates: the same license entered twice, often with different spacing or dashes in the number.
  • Old rows: licenses for people who have left, or for work you no longer do. Decide whether to keep them before you move them.
  • Hidden rows and filters: unhide everything first, so nothing gets left behind by accident.
  • Notes in the wrong place: move anything useful out of date cells and into its own column.
  • Dates that are really text: sort the date column, and anything out of order is worth a look.

Check the dates you’re unsure of against the documents

The expiration date printed on the license is the one that counts. For any row you’re not certain about, find the document and check it — or let the tracking system read it for you. If you can’t find the document at all, ask the holder for a copy, or look the license up with the authority that issued it.

Move it in stages

You don’t have to move everything in one go. Start with a small part of the list, such as your own licenses or one crew, and see how it works. Then bring in the rest. Keep the old spreadsheet as a read-only copy for a while, and name one place as the current record from then on, so nobody goes on updating the old one out of habit.

Bringing it into ContractorLicenseAlert

ContractorLicenseAlert imports Excel or CSV files of up to 2,000 rows at a time, within Pro’s 1,000-license limit. Columns are matched for you, you can correct any match and fix bad rows in place, and nothing is saved until you confirm. For the dates you’re unsure of, upload the documents themselves — PDFs, scans or phone photos, up to twenty at a time.

A PDF with real text is read exactly. Photos and scans are read with OCR, and anything the rules can’t settle goes to AI, whose answer is checked against the text. Either way, each document is shown beside a filled-in form: you confirm the date before it becomes a license, and a date that isn’t clear is left blank rather than guessed.

How spreadsheet import works

How dates are read from documents

Then let the reminders do the remembering

Once the list is in, set how far ahead each renewal needs to start, and check who hears about each license. Then the reminders take over, and the spreadsheet can retire.

How to choose a renewal lead time

More on renewals

How to keep track of contractor license expiration datesExpiration dates hide in PDFs, wallets and inboxes. A simple system for recording every license, permit and certificate — and hearing about each renewal in time.Renewal lead time: why reminders should start earlyThe expiration date is when it’s too late. Here’s how to work out when a renewal needs to begin — and why that’s the date your reminders should count down to.What gets read automatically from a license document, and where you still checkOCR and AI can read an expiration date off a license, permit or certificate — but not every document, and never without you confirming it. What the extraction does, and doesn’t do.A certificate of insurance with more than one policy: how it becomes separate licensesA single COI often lists general liability, workers’ comp and an umbrella policy together. Here is how each one is read out and saved as its own tracked record.When an expiration date can’t be read, and why that’s better than a guessSome bonds and permits simply don’t carry a fixed end date. Why the extraction leaves the field blank instead of inventing one, and what to do with it next.Tracking surety bonds alongside licenses, not in a separate spreadsheetA bond is easy to forget because it rarely comes up day to day. Keeping it in the same system as your licenses, with the same reminder discipline, is what keeps it from lapsing quietly.General liability vs workers’ comp: two different renewal clocksThey’re often asked for together, but a general liability policy and a workers’ comp policy don’t run on the same schedule. Tracking them separately is what keeps one from lapsing next to the other.What happens if a subcontractor’s certificate of insurance lapses mid-jobA sub’s coverage is only as current as the certificate you’re holding. How to collect, track and renew subcontractor COIs without chasing it over email every time.Owners, staff and watchers: who should see which licenseNot everyone on a renewal needs the same access. How ContractorLicenseAlert’s roles split billing and settings from the day-to-day work of getting a license renewed.Tracking licenses for people who don’t need a loginA subcontractor or seasonal hire doesn’t need an account to be reminded about their own license. The people directory, and how reminders reach someone outside your workspace.What happens to a license’s reminders when someone leaves the companyRemoving a team member shouldn’t mean their licenses go quiet too. What actually happens to access and reminders the moment someone is taken off a workspace.Email digest or one at a time: choosing how renewal reminders arriveSix people on a license doesn’t have to mean six separate emails every time. The choice between individual reminders and one daily digest, and when to use each.Why an overdue license gets a different subject lineOnce a renewal deadline passes, the reminder itself changes, not just the schedule. What the overdue follow-ups look like and why the subject line calls it out.Setting up a renewal calendar your whole team can checkA shared calendar view beats everyone keeping their own list. How the dashboard’s status buckets and two calendar views work.How often different license types actually renew: 12, 24 and 36 months comparedNot every license runs on the same clock. How the product’s default notice windows and terms differ across contractor licenses, permits, insurance, bonds and certifications.Continuing education hours: tracking certifications that expire on training, not just timeA certification can lapse even before its date arrives, if the hours behind it haven’t been completed. How to track CE requirements alongside the expiration date.Collecting renewal documents from a vendor without giving them a loginYou don’t need to create an account for every subcontractor or vendor just to get a current document from them. How an upload link works, end to end.Four reports every contractor compliance review actually needsCompliance, expiring, reminder delivery and activity — the four report types cover what most reviews ask for, and all four export to Excel or PDF.What an audit log should show when a license gets deletedDeleting a license should leave a trace, not a gap. What the activity log records, and why deleting one asks for a fresh login code first.Checking whether a license is actually active: state lookup tools by tradeA tracked expiration date tells you what your own records say, not what the licensing board’s records say. Where to actually check, trade by trade.

Put your next renewal on the radar.

Try everything free for 7 days. No card needed.

Start free trial Continue to workspace See pricing

Then $39 a month, or $390 a year. Cancel whenever.