How to Manage an Influencer Roster Without a Mess of Spreadsheets

What an influencer roster actually is

The word "roster" does two jobs, and much of the spreadsheet pain comes from making one document do both.

• The internal roster is your index: every creator you represent, with enough detail to answer "who fits this brief?" without opening anything else. It wants to be dense, scannable and complete.
• The brand-facing roster is a curated view: the two to eight creators relevant to one brand or one campaign, presented so a brand can forward it internally. It wants to be clean, current and selective.

A spreadsheet is a good internal roster and a poor brand-facing one. When managers try to make the sheet presentable, or make the deck complete, both jobs get worse. This guide covers the internal roster; there is a separate guide on creating a creator roster you can send to brands.

The data model of a useful roster

Before choosing a tool, decide what you track per creator. Managers tend to over-track profile trivia and under-track the fields that actually drive decisions. The table below is the working set that shows up consistently in conversations with managers, with the two properties that determine where each field should live: why it matters, and how often it changes.

The last column is the important one. "Audience" changes constantly and appears in every media kit, every roster and every proposal, which is why it is the field most often wrong in a pitch. "Rates" change often and are negotiated per deal, which is why a separate rate sheet drifts from the kit within weeks. A roster system is judged by how it handles the fields that change, not the fields that don't.

A sample roster structure

If you are staying in a spreadsheet for now, this is a structure that holds up. One row per creator, one sheet for the index, and the fields that change often kept deliberately thin: a current number, a source, and a date, rather than a history.

Three habits make this structure last. Every number gets a source and a date, so a stale figure is visible instead of silently wrong. Rates live on the creator row, not on a separate sheet. And the "Kit" column is a link to the one current media kit, never a copy of its contents.

Three ways managers run a roster today

The spreadsheet workflow

A Google Sheet as the index, a Drive folder of PDF media kits, rates either in the sheet or in a second sheet, and updates arriving by message. It is the default because it costs nothing and needs no setup.

The Drive / Notion workflow

A step up: a Notion or Airtable database with one page per creator, related tables for brands and deals, and the media kit either embedded or linked. It gives you structure and relations without code, and managers who enjoy building systems get a lot out of it.

Purpose-built roster software

A workspace whose primary record is the creator and whose outputs (media kits, rate views, rosters) are generated from that record. The structure is decided for you, which is a limitation if your workflow is unusual and a relief if it isn't.

The fair comparison is longer than this and depends on your shape. It is laid out in spreadsheets vs talent management software.

Signs the spreadsheet workflow is breaking

• You update a rate and then have to remember which other documents it appears in.
• A brand asks for three creators and it takes an afternoon to assemble the material.
• The audience numbers in a media kit are months old and you know it.
• You have two versions of the roster: one you can look at and one you can send.
• Creator updates arrive over WhatsApp and get applied to some documents but not others.
• Two people edit the sheet and nobody is sure which column is current.
• You have started avoiding brand requests that need fresh material because of the work involved.

Any one of these is normal. Three or more at once means the cost of copies is compounding, and it is worth changing the system rather than working harder inside it.

How to migrate progressively, not all at once

The big-bang migration ("this weekend I move everything") is the one most likely to be abandoned halfway, leaving two half-systems. A progressive migration fixes the most expensive duplication first and keeps the spreadsheet as an index for as long as it is useful.

1. 01Add a source and a date to every number in the sheet. No tool needed. This alone makes stale figures visible and changes how you read your own roster.
2. 02Move rates onto the creator row. Delete the separate rate sheet. If rates need to be per platform or per package, add columns rather than tabs.
3. 03Pick the three creators brands ask about most and build their records properly first. In whatever tool you have chosen, complete one creator end to end: profile, connected accounts, rates, terms, media kit. Use it for the next request that involves them.
4. 04Replace the PDF media kits with live links for those creators. The moment a kit is a link to a record instead of a file, the update problem for that creator is solved.
5. 05Move the rest of the roster one creator at a time, prioritized by how often they are pitched. Creators you rarely put forward can stay in the sheet for months without cost.
6. 06Build your next brand-facing roster from the records, not from the sheet. This is the test: if the shortlist can be assembled from the records in minutes, the migration is working.
7. 07Retire the sheet when it stops being the place you look first. It usually happens on its own.

Common mistakes

• Tracking everything. A roster with forty columns per creator is maintained by nobody. Track what drives a decision.
• Keeping rates away from the creator. A separate rate sheet is the single most common source of a wrong number in a pitch.
• Numbers without dates. A follower count with no date is a guess dressed as a fact.
• One document for two jobs. The internal index and the brand-facing roster want different things; let them be different artifacts.
• Migrating in one weekend. Half-migrations leave you maintaining two systems. Move the most-pitched creators first.
• Handling creators' logins. If a tool needs a creator's password to pull numbers, that is a risk you carry for them. Prefer read-only connections the creator grants themselves.

Recommended approach

Decide the creator record first, using the table above, and make it the one place each fact lives. Keep your internal index dense and your brand-facing outputs curated, and generate the second from the first rather than maintaining both. Stay in a spreadsheet while there is one copy of each fact; move to a purpose-built workspace when the copies start multiplying, and move progressively, most-pitched creators first.

Where KitVerify fits

KitVerify is built around the creator record described in this guide. Each creator you manage has one profile with a public media kit, rates and packages, terms (a reusable global set with per-creator terms), and optional read-only Instagram and TikTok sync where every number carries a synced, computed or self-reported label. Brand-facing campaign rosters are assembled from those records and shared as a link or PDF, with rates resolved live from each creator. It does not import spreadsheets; creators are added one at a time, which suits the progressive migration above. The creator roster management page shows the roster itself.

kitverify.com/rosters/aurelle-fall-shortlist