Importing Media Contacts

Read time 5 min Level Beginner Prerequisites A spreadsheet of existing media contacts (from a previous tool, a purchased list, or manual research)
In a nutshell: Bring an existing journalist list into the CRM via paste-from-spreadsheet on Media CRM > ADMIN > Bulk Import. No file upload, no template download, no column-mapping step -- the bulk import table takes pasted cells directly. Up to 500 rows per batch. Outlets and contacts are paste-imported separately or together; the Outlet and Contact Dedup wizards run on demand afterwards if duplicates accumulate.

Where bulk import lives

Open Media CRM > ADMIN tab > Bulk Import and click Open Bulk Import Table. The flow is:

  1. Set the boxes at the top: Country, State and Time Zone, then Outlet Type and Size, and Tier if you know it. They apply to every new outlet in the batch. Outlets you already hold keep their own.
  2. In the source spreadsheet, select the cells to import.
  3. Click the first box of a column and paste. Columns fill to the right from the box you clicked, so copy them in the order below or paste one column at a time.
  4. Check the rows on screen, then click Save All Outlets.

No CSV file, no upload, no column-mapping wizard. Copy from spreadsheet, paste into the table.

The column order

The Bulk Import table expects columns in this order:

  1. Outlet Name (the only column every row needs)
  2. Contact Name
  3. Contact Email (needed for any contact details on the row)
  4. Contact Phone
  5. Position
  6. Interests (needed when the row has an email)
  7. Coverage Area
  8. Format
  9. Reach (one whole number, such as 3000)

Up to 500 rows per batch. For larger lists, split the source spreadsheet into batches of 500. To add outlets with no contacts, fill in only Outlet Name and Reach and leave the contact columns empty.

How the import resolves

The import logic is designed to avoid duplicate outlets:

  • Same outlet name in multiple rows -- adds those journalists to one outlet record, not several. A new outlet takes the first reach typed for it.
  • Outlet you already hold -- journalists are added to it, and its type, size, tier and reach stay as they are. The result line names any outlet whose typed reach was not applied. To change a held reach, use Add audience on the outlet.
  • New outlet with no reach -- takes a nominal 5,000, marked as nominal in its Audience history, so reports have a figure to use. Add the real figure when you have it.
  • No tier chosen -- the new outlets have no tier until someone sets one, and they score as Tier 3 until then. Buzzscribed does not choose a tier for you.
  • Same outlet name in different countries -- creates separate outlet records (one outlet per country, even if the name matches).
  • Journalist already in the CRM -- reused and mapped to the new outlet rather than duplicated. A journalist who writes for two publications keeps one contact record linked to both.
  • Country and state values -- normalised at import. "United Kingdom" and "UK" resolve to the same value; the system stores the canonical form.

Validation

The import validates each row before saving:

  • A row with any details has an Outlet Name.
  • Contact Name, Phone, Position or Interests on a row need a Contact Email, and a row with an email needs Interests.
  • Email addresses in valid format.
  • Reach is one whole number, such as 3000.
  • A batch that adds a new outlet has an Outlet Type and a Size chosen at the top.

Rows with errors turn red and show ERROR; hover over it to see the problem. Nothing is saved until every row is clear, so fix the rows on screen and click Save All Outlets again.

Country Packs as a faster alternative

If the goal is to seed the CRM with a country's journalist pool rather than import an existing list, Country Packs (Media Outlets > ADMIN > Country Packs) activate a curated pool in one click -- journalists become searchable in the CRM, feed Smart Match and power pitch recommendations. The Finding Journalists article (Course 4) covers Country Packs in detail.

The two approaches complement each other: import the agency's existing relationship-rich list via Bulk Import; activate Country Packs for the markets where the CRM is thin.

Handling duplicates after import

Near-duplicates accumulate over time ("Acme Tribune" vs "The Acme Tribune", or the same journalist entered twice in source data). The Outlet Dedup and Contact Dedup sub-tabs in the ADMIN section run a wizard that clusters likely duplicates by similarity, shows a confidence score, and lets the user merge or dismiss each cluster. The wizard runs on click; the platform never silently merges contacts.

Frequently asked

Can a CSV file be uploaded?
Bulk Import takes pasted cells directly from a spreadsheet -- no file upload step. Open the source spreadsheet, select the cells, paste into the table.
What if a contact already exists in the CRM?
The contact is reused. If the imported row points to a new outlet, the existing contact gets linked to the new outlet without creating a duplicate.
What if the import has errors?
Rows with errors turn red and nothing is saved until they are fixed. Fix them on screen and save again.
What about email enrichment?
Buzzscribed enriches contact data (fills in and verifies email addresses) through a background pipeline once contacts are in the CRM. The Finding Journalists article covers enrichment.
Key takeaways
  • Bulk Import is paste-from-spreadsheet, not file upload. Media CRM > ADMIN > Bulk Import.
  • Up to 500 rows per batch; split larger lists.
  • Set the boxes (Country, State, Time Zone, Outlet Type, Size, and Tier if you know it) once at the top of the batch. They apply to new outlets only.
  • Existing contacts are reused, not duplicated; outlets resolve by name and country.
  • Run Outlet Dedup and Contact Dedup after import if duplicates accumulate.

What to read next

  • Adding Your First Client & Brand -- the first Client record, which then sets up the first Engagement.