How a Talent Agency Moves from Spreadsheets and Airtable to a CRM

First: is a CRM actually what you need?

The answer changes the whole migration. Two different problems hide behind "we need a CRM", and most agencies have one of them, not both.

If your list is mostly on the left, buy a real CRM with pipelines, and keep your creator information where it is now. If it is mostly on the right, you need a place where each creator has one record and everything brand-facing is generated from it. Some agencies end up with both, and that is a reasonable outcome. The mistake is buying one and expecting it to do the other job.

Step 1: Audit the columns you actually use

Do not migrate your whole sheet. Migrate the part of it that is still alive. Open it and test every column with one question: have I read this in the last month to make a decision? Most agency rosters split roughly three ways.

The private column needs a special warning. It causes the most common accident in this whole migration: a manager forwards a roster that still contains an internal note. Decide now which facts are yours and which are the brand's. Keep the first group somewhere that never shows on a public page.

Step 2: Decide that one creator is one record

This is the decision that makes the migration worth doing, and it is a decision, not a feature. From now on, exactly one place holds what a creator charges. One place holds their audience numbers, and one holds their terms. Every pitch, kit, PDF and roster reads from those places instead of keeping its own copy.

It sounds obvious written down, but it is not what most sheets do. A typical agency roster has a rate in the index, another in the media kit PDF, and another in a proposal sent three weeks ago. Nobody can tell which one is current. The math is worked through in spreadsheets vs talent management software. The number of places a fact can be wrong is roughly creators multiplied by brand-facing outputs. It gets hard to manage well before a roster feels large.

Airtable users often have half of this already. One row per creator is the right shape. But if the media kit is still a PDF in Drive and the roster is still a deck, every copy still exists. A structured database with hand-built outputs fixes the index and none of the duplication.

Step 3: Map your columns onto the record

Now take the "alive" columns and place each one. Most agency sheets map cleanly, because the same working set shows up again and again.

Two rows are the point of the exercise. The brand-contact columns do not move, and the media-kit-link column disappears. If many columns are left with no destination, that tells you something. Either they were dead, or they are sales-side, or the tool is the wrong shape for your agency.

Step 4: Clean as you copy, especially the numbers

A migration is the one moment you will have a reason to look at every value. Use it. Three cleanups help right away.

1. 01Give every number a source and a date. "48,200" is not a fact; "48,200 followers, from Instagram, September 3" is. If you cannot remember where a figure came from, treat it as self-reported with an unknown date. Write that down rather than presenting it as current. A brand that catches one stale number discounts every number on the page.
2. 02Resolve the duplicates. Most sheets have a creator whose rate appears in two columns with different values. Pick one by asking what you would actually charge today, not by taking the higher of the two.
3. 03Normalize your niches. "beauty", "Beauty", "beauty/skincare" and "skin" are four tags for one thing. Filtering a roster by tags like these is what makes an agency slow to answer a brief. Agree on a short list of niche names and use only those.

None of this needs software. Even if you never migrate, doing these three things in your current sheet makes your roster more trustworthy.

Step 5: Move the most-pitched creators first

Here is the honest part about importing: in KitVerify there is none. There is no CSV upload, no Airtable connector and no bulk load. You add creators one at a time and type in their rates, terms and past work. There is one exception, described in the next section, and it covers Instagram handles rather than your columns.

That limit decides the order of work, and the order turns out to be right anyway. Pick the three or four creators brands ask about most. Build their records end to end: profile, channels, audience, rates, terms, past work. Then use those records for the very next real brand request. A migration that has already answered one live request is a migration that finishes. Now picture a weekend spent loading twenty-five creators, none of them pitched from the new system yet. That migration is the one most likely to be dropped halfway, leaving two half-systems to maintain. Creators you rarely put forward can sit in the sheet for months at no cost. Move them when a brief makes you need them, which is also when you have a reason to check their numbers.

The one shortcut that exists: paste the handles

There is a faster way to get the first records in, and it is worth knowing before you start typing. The roster generator takes two to five Instagram handles pasted in a box. It builds a live roster page from them, with follower counts synced from Instagram, engagement rates computed from those numbers, and recent posts. It needs no account.

If you then claim that roster, every creator on it becomes a record in your workspace. The roster itself becomes yours to edit, on the same link you may already have sent a brand. So the fastest route in is: paste five handles, claim, repeat for the next five, then fill in rates, terms and past work by hand. It is Instagram only. TikTok has no public lookup, so a TikTok creator has to connect their own account for numbers to sync. It also will not carry a single one of your spreadsheet columns. What it saves you is typing profiles and audience numbers, which is most of the tedious part.

Step 6: Have creators connect their accounts

The columns that cost an agency the most upkeep are the audience numbers. They change constantly and appear in every output. This is the one part of the migration that removes work for good, rather than moving it somewhere else.

Send each creator a connect link. They sign in to Instagram or TikTok themselves and grant read-only access. The metrics those official APIs expose then refresh onto their record, with a source label and a last-synced time. You never hold a password. Anything the APIs do not expose stays typed in and stays labeled as self-reported, with the date it was entered. That label is the point: a brand can see which figures came from the platform and which came from the creator. The details, including how often it refreshes, are on how syncing works.

Two practical notes. Not every creator will connect, and a roster with some synced and some typed numbers is fine as long as the labels are honest. And connection is per platform: a creator with Instagram connected and YouTube typed in shows exactly that.

Step 7: Retire the sheet, and what to keep

Do not delete it. Stop opening it. You know the migration is done when your habits change: a brand asks who fits a brief, and you go to the workspace without thinking about it. Keep two things afterward. First, your brand-side columns, which had no destination in the mapping above and still need a home. Second, a plain export of the roster as it stood on migration day, filed somewhere out of the way.

What changes, and what does not

An agency that reads the right-hand column and decides the move is not worth it has made a reasonable decision. The left column is the whole return, and it is only large if you have a lot of duplication today.

Where KitVerify fits

KitVerify is the destination described in step 2. Each creator gets one record holding profile, channels, audience, niche, status, rates and packages, terms, and past work. From that record, a public media kit publishes at a shareable link and a PDF exports. Any campaign roster the creator appears on reads the same figures rather than copying them. Optional read-only Instagram and TikTok connections keep the audience numbers current. Every figure carries a synced, computed or self-reported label with a date. It does not import your spreadsheet, replace a sales pipeline, or handle contracts and invoicing. For a wider comparison of tool categories, talent manager tools maps them side by side.

kitverify.com/p/manager/talents