Media PR Database

What Is a Media List? Definition, Example and Free Template

What a media list is, the nine columns every media list needs, a real example with masked emails, a copy-paste media list template, how to build a media list in one hour, how many outlets to include and how to keep it clean.

What is a media list: a spreadsheet of the outlets and journalists you plan to pitch, with the columns Outlet, Website, Outlet type, Coverage, Region, City, Journalist, Role and Email, and example rows for CalMatters, KCRA 3 and CapRadio in Sacramento

Short answer: a media list is a spreadsheet of the specific outlets and journalists you plan to pitch for one story or campaign. Each row is one contact at one outlet, and the columns tell you who they are, what they cover, where they are and how to reach them: Outlet, Website, Outlet type, Coverage, Region, City, Journalist, Role and Email. A good media list is short, matched to the story, and checked before you hit send.

This guide explains what goes into a media list, shows a real example built from public outlet data, gives you a free media list template you can paste into Google Sheets or Excel, and walks through how to build a media list in about an hour. It comes from Media PR Database, a directory of 9,596 news outlets in 195 countries with 16,692 newsroom and journalist emails, so building media lists is what we do every day.

What is a media list?

A media list (also called a press list or PR list) is a working document that answers one question: who should hear about this story? It lists the newspapers, news sites, TV and radio stations, magazines, trade publications and, sometimes, podcasts and newsletters that are likely to care, together with the right person or inbox at each one.

Three things make it a media list rather than just a list of email addresses:

  • It is built for a story. A restaurant opening in Sacramento and a fintech funding round need completely different lists, even if both come from the same company.
  • It has context. Outlet type, coverage area and the journalist's role tell you why each contact is on the list, so you can tailor the pitch.
  • It is maintained. Journalists change jobs, newsrooms change inboxes and outlets close. A media list gets updated after every send.

PR agencies, in-house communications teams, founders and small business owners all use media lists. The format is the same whether you pitch five local outlets or 150 national ones.

What columns does a media list have?

You can track dozens of fields, but nine columns cover almost every pitch. These are the core columns of the Media PR Database CSV export, and they work just as well in a list you build by hand.

The 9 columns of a media list: Outlet, Website, Outlet type, Coverage, Region, City, Journalist, Role and Email, with what each one is for
The nine core columns of a media list. Graphic by Media PR Database.
ColumnWhat goes in itWhy it matters
OutletThe publication or station name, e.g. CalMattersLets you sort, group and avoid pitching the same outlet twice
WebsiteThe outlet's home pageYou read recent stories here before you pitch
Outlet typeNewspaper / online news, TV, Radio, Magazine, tradeDecides the angle: TV wants visuals, trade titles want industry detail
CoverageLocal, Regional, Statewide, National, InternationalStops you sending a neighbourhood story to a national desk
RegionState, province or regionLets you filter for regional and statewide stories
CityWhere the newsroom is basedThe key filter for any local angle
JournalistA named reporter, editor or producer, if you have onePersonal pitches beat generic ones
RoleBeat or job title, e.g. business reporter, news deskConfirms the person actually covers your topic
EmailA named work address or the newsroom addressHow the pitch reaches them

Optional columns worth adding

Once the nine core columns are in place, add tracking columns on the right so the list doubles as a log:

  • Tier (A, B or C), so you know who gets a personal note first.
  • Last story: a link to something they wrote recently on your topic.
  • Date pitched and Follow-up date.
  • Status: sent, replied, interested, covered, declined, bounced.
  • Notes: preferences such as "no attachments" or "pitch before 10 a.m."

Our full export also includes data such as continent, country, city size, a Domain Rank score and estimated monthly organic traffic, which help when you want to sort a long list by reach.

Media list example (real outlets, masked emails)

Here is a real media list example for a story about a new business opening in Sacramento, California. We ran the free media list builder for Sacramento on October 30, 2026, and it returned six outlets. Emails are masked here the same way they are in the free tool; the Journalist and Role cells are left empty because the free preview shows only newsroom-level data, and filling them in is your job in step 4 below.

OutletWebsiteOutlet typeCoverageRegionCityJournalistRoleEmail
CalMatterscalmatters.orgNewspaper / online newsStatewideCaliforniaSacramento•••••@c•••••••••.org
KCRA 3kcra.comTVRegionalCaliforniaSacramento•••••@k•••.com
FOX40fox40.comTVRegionalCaliforniaSacramento•••••@f••••.com
ABC10abc10.comTVRegionalCaliforniaSacramento•••••@a••••.com
CapRadiocapradio.orgRadioRegionalCaliforniaSacramento•••••@c•••••••.org
Inside Sacramentoinsidesacramento.comMagazineLocalCaliforniaSacramento•••••@i•••••••••••••••.com

How to read this example

  • Mix of formats. One online news outlet, three TV stations, one radio station and one local magazine. A store opening with something to film suits the TV stations; a story with a policy or economic angle suits CalMatters, which covers the whole state.
  • Coverage tells you the angle. Inside Sacramento is local, so it wants the neighbourhood detail. The TV stations are regional, so they need a reason viewers outside the city would care.
  • Six is a realistic local list. A city-level search rarely returns hundreds of outlets. For Sacramento you would then widen to the rest of California, which has 239 outlets in our database, and keep only those that match the story. Browse them on the California media list page.

Free media list template (copy and paste)

Copy the block below, paste it into cell A1 of a new Google Sheet or Excel workbook, and it splits into columns automatically (the values are separated by tabs). The first row is the header; the second is a sample row you can overwrite.

Outlet	Website	Outlet type	Coverage	Region	City	Journalist	Role	Email	Tier	Last story	Date pitched	Follow-up date	Status	Notes
Example Daily News	example.com	Newspaper / online news	Local	Example State	Example City	Jane Doe	Business reporter	newsroom@example.com	A	link to a recent story	2026-11-03	2026-11-06	Sent	Prefers short pitches

Or, if you prefer to see it as a table:

OutletWebsiteOutlet typeCoverageRegionCityJournalistRoleEmailTierStatus
Example Daily Newsexample.comNewspaper / online newsLocalExample StateExample CityJane DoeBusiness reporternewsroom@example.comASent

The sample row uses a made-up outlet and address on purpose. Replace it with real contacts.

Template tips

  • Freeze the header row and turn on filters, so you can sort by Coverage or Tier in one click.
  • Use a drop-down for Status (data validation in Sheets or Excel) so the values stay consistent.
  • Keep one row per contact. If an outlet has two reporters on your beat, give each a row and repeat the outlet details.
  • Make a copy per campaign. Keep a master list, then duplicate and trim it for each story.

How to build a media list in one hour

You do not need a week or an expensive subscription to build a solid media list. Here is the process we use, with rough timings.

Build a media list in one hour: 0 to 5 minutes define the story and place, 5 to 15 pull outlets by country, state, city and type, 15 to 30 cut off-topic outlets, 30 to 45 add a journalist and role, 45 to 55 verify emails, 55 to 60 tier the list
A one-hour plan for building a media list. Graphic by Media PR Database.

Step 1: Write the story in one line (5 minutes)

Before you collect a single contact, write down what the story is, who it matters to and where. "Family bakery opens second location in Sacramento and hires 12 people" tells you instantly that you need local and regional outlets in Northern California, with food, business and community reporters. If you cannot write the one-liner, the list will be unfocused too.

Step 2: Pull outlets by place and type (10 minutes)

Open the free media list builder, choose the country, then the state or region and city, and filter by outlet type and coverage. It shows how many outlets match and previews them with their websites, and you can copy the preview straight into Google Sheets. For a purely local story, the Local News Finder groups the same data into newspapers, TV and radio for one city. For a country-wide view, start from a country page such as the UK media list or the Australia media list.

Step 3: Cut anything off-topic (15 minutes)

Open each outlet's website and skim the last few weeks of stories. If they never cover your subject, delete the row. This is the step most people skip, and it is the one that matters most: in Muck Rack's State of Journalism 2026 survey, 43% of journalists said it was rare to get pitches relevant to their beats, and the thing journalists valued most in a pitch was clear relevance to their beat (70%) (University of Minnesota summary of the report).

Step 4: Add the right person (15 minutes)

For each outlet that survives, find the reporter or editor who covers your topic. Look at bylines on related stories, the outlet's staff or contact page, and the author's profile. Note their name and role. If no one obviously fits, use the newsroom or news desk address instead: an editor there will forward a good story, and a general desk address is better than a named contact who covers something else.

Step 5: Verify emails and remove duplicates (10 minutes)

Run the email column through an email verification service, remove addresses that come back invalid, and de-duplicate the sheet (in Google Sheets: Data, then Data cleanup, then Remove duplicates). Sending to dead addresses hurts your sender reputation and can push your next pitch into spam.

Step 6: Tier the list (5 minutes)

Mark each row A, B or C. A contacts are perfect fits who get a fully personal email. B contacts get a lightly personalised version. C contacts are "maybe" outlets you contact only if the story lands well with the first two tiers. Then write the pitch: our media pitch email template and the media pitch generator help you keep it short.

How many outlets should a media list include?

There is no official number, but there is a clear principle: relevance beats size. A list of 30 outlets that all cover your topic will get more replies than 3,000 that mostly do not. These are the ranges we suggest as a starting point:

How many outlets on a media list: local story 10 to 30, state or regional story 30 to 80, national launch 50 to 150, trade or niche story 20 to 50. Relevance beats size: 43% of journalists say relevant pitches are rare (Muck Rack, State of Journalism 2026)
Suggested media list sizes are our own rule of thumb, not survey data. Graphic by Media PR Database.
Type of storySuggested sizeWhere to start
Local (one city or town)10 to 30 outletsCity search in the Local News Finder
State or regional30 to 80 outletsA state page such as California
National launch50 to 150 outletsNational coverage filter in the media list builder
Trade or niche20 to 50 outletsTrade titles plus a few general business desks

If your list is far bigger than these ranges, it usually means the story is not defined tightly enough (go back to step 1) or you have not cut off-topic outlets (step 3). If it is much smaller, widen the geography one level: city to state, state to country.

How to keep a media list clean

A media list starts going stale the day you build it. A few habits keep it useful.

Handle bounces straight away

  • Hard bounces (address does not exist): delete the email, mark the row "bounced", and look for the person's new outlet or the newsroom's current address.
  • Soft bounces (full inbox, temporary error): keep the row, try once more later, and remove it if it bounces again.
  • Auto-replies saying someone has left: update the row the same day. These replies often name the replacement.

Re-check before every campaign

Before you reuse a list, re-verify the emails and spot-check the A tier: is each person still at the outlet and still on the same beat? It takes ten minutes and saves embarrassing "she left in March" replies.

Respect opt-outs

If a journalist asks not to be contacted, remove them from every copy of the list and keep a separate "do not contact" sheet so they are not added back later. Laws such as CAN-SPAM in the US and the GDPR in Europe expect you to honour these requests.

GDPR: EU and EEA outlets

Under the GDPR, information about an identified person, including a named work email such as firstname.lastname@outlet.eu, is personal data. That is why, for outlets in the EU and EEA, Media PR Database lists only general role addresses (for example a newsroom or editorial desk inbox), one per outlet, and no personal addresses. If you add named EU contacts to your own list, keep only what you need, pitch only relevant stories, and remove people who ask. This is general information, not legal advice.

Keep notes after every send

Who replied, who covered the story, who said "not for us but try me on X". That history is what turns a media list into a list of relationships.

Media list vs media database

People often use the two terms interchangeably, but they are different things:

Media listMedia database
What it isA short, curated spreadsheet for one story or campaignA large, searchable directory of outlets and contacts
SizeUsually 10 to 150 rowsThousands of outlets
Who maintains itYouThe provider
LifespanOne campaign, then updated or archivedOngoing
RelationshipBuilt from a database plus your own researchThe source you pull lists from

In short, the database is the library and the media list is the handful of books you take home for this project. Read what a media database is for the full comparison, including what the big subscription tools cost, and our roundup of Muck Rack alternatives if you are weighing a paid tool.

Common media list mistakes

  1. One list for every story. A list built for a product launch will not suit a local hiring story.
  2. Too many outlets. Bigger lists mean less personalisation and more ignored emails.
  3. No context columns. Without outlet type, coverage and role you cannot tailor the pitch.
  4. Never checking bounces. Dead addresses damage your sender reputation over time.
  5. Mass sends with everyone in CC. According to the same Muck Rack summary, 62% of journalists prefer to be pitched in a one-to-one email, so send individually.
  6. Long pitches. 69% of journalists prefer pitches under 200 words (UMN summary of Muck Rack's State of Journalism 2026).
  7. Ignoring timing. The same summary reports that 78% of journalists prefer pitches sent before noon.

Where to get a media list

You have three realistic options:

  • Build it by hand from outlet websites, mastheads and bylines. Free, but slow for anything beyond a handful of outlets.
  • Use a free tool to find the outlets, then add contacts yourself. The media list builder and Local News Finder are free and need no signup.
  • Download a ready list with emails. Media PR Database covers 9,596 news outlets in 195 countries with 16,692 newsroom and journalist emails, including outlets in all 50 US states. Pro ($149, one-time) unlocks emails and CSV export in the same columns as the template above. Premium ($299, one-time) adds 2,997 podcasts and 123 newsletters as a bonus. There is no subscription. See pricing.

Good starting points: the California media list, the United Kingdom media list and the Australia media list.

Sources

We checked these on October 30, 2026.

The bottom line

A media list is a short, story-specific spreadsheet of outlets and journalists, with nine core columns: Outlet, Website, Outlet type, Coverage, Region, City, Journalist, Role and Email. Build it from the story outward, cut every outlet that does not cover your topic, add the right person or the newsroom desk, verify the emails, and tier the list before you pitch. Copy the template above, then run the free media list builder for your city or state to fill the first rows in minutes.

FAQ

What is a media list?

A media list is a spreadsheet of the outlets and journalists you plan to pitch for a specific story or campaign. Each row is one contact, with columns such as Outlet, Website, Outlet type, Coverage, Region, City, Journalist, Role and Email.

What should a media list template include?

At minimum the outlet name, website, outlet type, coverage (local, regional, national), region, city, journalist name, role and email. Add tracking columns for tier, last story, date pitched, follow-up date, status and notes.

How do I build a media list for free?

Write your story in one line, use a free tool such as the Media PR Database media list builder to find outlets by country, state, city and type, cut outlets that do not cover your topic, add the right reporter from bylines or use the newsroom address, verify the emails and tier the list.

How many contacts should be on a media list?

Fewer than most people think. As a rule of thumb, 10 to 30 outlets for a local story, 30 to 80 for a state or regional story, 50 to 150 for a national launch and 20 to 50 for a trade story. Relevance matters more than size.

What is the difference between a media list and a media database?

A media database is a large, searchable directory of outlets and contacts maintained by a provider. A media list is the short, curated selection you pull from it, plus your own research, for one story or campaign.

Can I put EU journalists' emails on a media list?

Named work emails of people in the EU and EEA are personal data under the GDPR, so handle them with care: keep only what you need, pitch relevant stories and remove anyone who asks. For EU and EEA outlets, Media PR Database lists only one general role address per outlet, such as the newsroom inbox.

Build your media list in minutes

Search free, then download any country or state list as CSV in one click.

Browse media lists

Start with a free search

See every outlet in your market before you pay. Unlock emails and one-click downloads when you are ready.