How to Build a Media List That Gets Your Story Covered (Free Spreadsheet Method)

To build a media list for PR outreach, start by defining the beats your story fits, find the outlets and journalists who cover those beats, and record them in a simple spreadsheet with one row per journalist, including their beat, recent coverage, and the best verified contact route. A useful list is a research tool, not a purchased database — quality and relevance matter far more than size.

A media list is not a list of email addresses. It is a working document that helps you pitch the right person, with the right angle, at the right time. Built well, it saves you from wasted pitches, protects your reputation with journalists, and turns every campaign into a learning exercise for the next one.

Key takeaways

• Start with beats and topics, not with a giant list of names.
• Record outlets, journalists, beats, and verified contact routes in a spreadsheet.
• Prioritise journalists who have covered your topic recently.
• Refresh the list before every campaign — contacts go stale fast.
• Use a researched list when DIY research stops scaling.

What is a media list, and why does quality beat size?

A media list is a curated record of journalists, editors, podcasters, and outlets that are relevant to your story or business, together with enough context to pitch them well. The best lists are small and specific. A list of thirty journalists who genuinely cover your topic will outperform a list of three thousand names assembled from a generic directory, because every pitch from the small list has a real chance.

Size can actually hurt you. Mass pitching damages your sender reputation, annoys journalists who are pitched irrelevant stories, and teaches you nothing about what works. A focused list, by contrast, lets you personalise each pitch honestly, track which angles earned replies, and improve with every campaign.

Think of your list as an asset you maintain, not a file you download once. The journalists on it change roles, move outlets, and shift beats. A list that was accurate six months ago may now be full of dead ends, and pitching dead ends wastes the very time a good list is meant to save.

How do you start with beats, not names?

Begin by listing the beats your story fits. A beat is a topic area a journalist covers regularly, such as small business finance, consumer technology, local food, or renewable energy. Most stories fit more than one beat, but they rarely fit all of them. Choosing beats first keeps you honest about relevance and stops you pitching everyone who has ever written the word business.

Next, map beats to outlets. Which publications, programmes, and podcasts does your audience actually read, watch, or listen to? Include national and trade outlets, but do not overlook local and niche publications. For many small businesses, a trade or local journalist who reaches exactly the right readers is worth far more than a national name who will never reply.

Only after beats and outlets are clear should you look for individual journalists. That order matters: it prevents you from collecting impressive names who have no connection to your story, and it gives every name on your list a reason to be there that you can explain in one sentence.

Beat-first planning

• What topics does your story genuinely touch? List three to five beats.
• Which outlets cover those beats for your audience?
• Which journalists within those outlets have written on them recently?
• What angle would each journalist's readers find useful?

How do you find the right outlets for each beat?

Start with what you already read and trust. The outlets your customers mention, the newsletters your industry shares, and the publications your competitors appear in are usually a strong starting point. Search for your topic plus words like news, magazine, or journal, and look beyond the first page for specialist titles that serve your niche well.

Read a few recent articles from each candidate outlet before adding it. Does it cover stories like yours? Does it quote sources like you? Does it publish at a frequency and depth that fits your announcement? An outlet that only covers major listed companies is unlikely to cover a small business launch, however good the story is. Conversely, a specialist blog with a loyal audience may be exactly right.

Record why you included each outlet. A short note — for example, covers independent retail, publishes weekly case studies — helps you months later when you return to the list for a new campaign. Without those notes, a list quickly becomes a set of names with no memory attached, and you end up researching the same outlets again from scratch.

How do you find journalists and their bylines?

Once you have outlets, look for bylines. A byline is the author's name on an article, and it is the most reliable starting point for finding who covers what. Search each outlet's site for your topic, open the most relevant recent articles, and note the authors. Then read several of their pieces to confirm the beat is current, not a one-off assignment from two years ago.

Author pages, staff directories, and contributor bios often describe a journalist's current beat in their own words. Those descriptions are worth recording verbatim in your notes, because they tell you how the journalist sees their own work — which is usually a better guide to a good pitch angle than a job title alone.

Be careful with seniority. Editors and section heads are often the wrong first contact for a story pitch; the reporter who writes daily on your topic is usually the right one. Pitching the editor-in-chief of a large publication with a routine announcement rarely works, and it can look as though you did not research the outlet at all. Aim for the person who actually writes the stories you want to appear in.

What columns should your spreadsheet have?

Keep the structure simple enough that you will maintain it. A spreadsheet with too many columns becomes a chore, and a chore gets abandoned. The columns above cover what you need to pitch well and to learn from each campaign, without turning list-building into data entry for its own sake.

Add one row per journalist, not per outlet. Two journalists at the same outlet may cover different beats and deserve different angles, and collapsing them into one row loses that distinction. Similarly, keep a separate notes field for angle ideas: a sentence about what this journalist would find interesting is often more valuable than any contact detail.

Use filters and tags rather than multiple copies of the list. Tag rows by beat, outlet type, and geography so you can pull a focused sub-list for each campaign without duplicating records. When a journalist changes role, update the row once and the whole list stays correct. That discipline is what separates a working media list from a pile of names.

A spreadsheet that actually helps

• Outlet name and type (trade, local, national, podcast, newsletter).
• Journalist name and role.
• Beat and topics they cover, in your own words.
• Recent relevant articles (titles and dates).
• Best verified contact route and how you found it.
• Pitch angle notes and last contact date.
• Response and outcome, for learning.

How do you verify contact details ethically?

Use only contact routes the journalist has made public: author pages, outlet contact pages, staff directories, social bios, and newsletter sign-offs. Many journalists publish a preferred contact method, and following it shows professionalism. If no public route exists, consider pitching through the outlet's tips or newsdesk route, or simply leave that journalist off this campaign.

Do not buy lists, scrape private addresses, or guess addresses by pattern and blast them. Those methods produce high bounce rates, spam complaints, and reputational damage, and they often break privacy rules. A smaller list of verified, public contacts is both more effective and more defensible than a large list of uncertain addresses. Quality here is not just a preference; it is a practical advantage.

Record how you verified each route and when. A note like author page, checked October 2026 tells your future self — or a colleague — that the detail was real at a point in time. It also makes the next refresh much faster, because you only need to re-check routes that are old or that bounced.

How often should you refresh the list?

Refresh before every campaign, and do a fuller review every few months. Journalism is a high-turnover profession: people change outlets, beats, and roles frequently, and publications launch, merge, and close. A list that felt fresh last quarter may contain several people who no longer cover your topic at all.

A practical refresh routine is to check the top twenty contacts for your next campaign in full, verify the rest in bulk by scanning recent bylines, and remove anyone who has moved away from your beat. Add new names you discovered while reading recent coverage, and note any journalist who replied helpfully before — those relationships are worth more than any new name.

Treat bounces and out-of-office replies as data, not annoyance. A bounce means the route is dead and the row needs updating. A reply from a colleague saying the journalist has moved on is useful intelligence: update the row, thank the colleague if appropriate, and consider whether that colleague is now the right contact. Each campaign should leave the list better than it found it.

When does DIY list-building stop scaling?

Building your own list is the right choice when you run occasional campaigns, cover a narrow niche, and enjoy the research. It teaches you your media landscape deeply, and the personal knowledge you gain makes your pitches noticeably better. For a single launch or a local story, a DIY spreadsheet is often all you need.

It stops scaling when you need hundreds of relevant contacts across several beats, when you pitch frequently, or when research time starts crowding out the actual pitching, writing, and follow-up. At that point the cost is not just hours; it is missed opportunities, because a list built slowly may be partly stale by the time it is finished.

That is an honest threshold, not a failure. Many teams start DIY, learn their landscape, and then move to a researched list for larger campaigns while keeping their core relationships in-house. The DIY knowledge still pays off, because it helps you judge the quality of any list you use and brief it well. If you have reached that point, explore our media list services for a list researched around your beats and audience.

How can PressFudge support your media list?

A good media list turns pitching from guesswork into a repeatable process. Whether you build it yourself with the method above or use a researched list to save time, the principles stay the same: beats first, relevance over size, verified routes only, and a refresh before every campaign.

PressFudge can help you get that foundation right. Our media list services provide targeted, researched lists matched to your story, and our pricing page shows current options. Start with a focused list, pitch personally, and let each campaign make the next list stronger.