Looking for work sucks. I hate it. You hate it. It’s all just terrible. I’ve always especially hated the how searching for new job leads creeps into more and more of your online life as a job hunt continues. I also despise serially refreshing the jobs pages of that one company I actually really want to work at, to see if they’ve finally decided to post a job I would be great at in the hours since my last refresh.

I can’t make job hunting suck less, but I’ve created an approach I use to structure research into organizations I would like to work for that makes checking for jobs with them more repeatable.

My own use of this spreadsheet has morphed into my blog posts and social media threads of tech for good-ish job openings I find during my weekly-ish use of this process.

TL;DR Summary of the system:

Keep a spreadsheet with links to the job pages of organizations you would want to work with. Make time each week to quickly look at all the collected jobs pages at the same time to scan for relevant job openings.

Why I like this system:

Reusability: We’ll be researching and creating a list of companies you might like to work with. You can use this in a current job hunt and pull it back out for future job hunts.

FOMO reduction: Once you’ve made your spreadsheet, you’ll be checking it weekly. Almost any openly posted job will be up for a week or more, so this system should keep you from missing out. And if you do see a great job that’s already closed, you can add the org to your spreadsheet to watch for the next time it’s open.

Timeboxing: We’re adding a recurring calendar block to quickly look at these sites each week. By limiting this task to a set time each week, it limits the amount of time you’re worried about this…leaving you more time to worry about everything else…

Quick filtering to minimize spiralling: You’re quickly glancing at the job sites and saving any jobs that seem intersting to look at later. It’s easy to stall out second guessing yourself when you’re looking at a job description. Focusing on quickly scanning for jobs to filter later means you’re not getting mired down with self doubt at this phase in the process.

Little treats for dopamine: I like to have an optional treat with my weekly tour through my collected links. Everything about job hunting is stressful and weird and bad. Pairing a repeated task with a little treat just feels humane.

Detailed Process:

Tools needed

  • Spreadsheet software of your choice
  • A web browser with an extension/add on that lets you open a list of links in different tabs.
  • A personal calendar
  • A text editor or note taking application
  • (Optional but highly recommended) Small, repeatable little treats: Fancier-than-usual coffee or nice sweets might work well.
    • I have some almond croissants I keep in the freezer for this!

Getting set up

  1. Get the link opener add-on of your choice added to your favorite browser.
  2. Create a new spreadsheet, you don’t have to worry too much about the structure now.
  3. Begin adding companies or organizations to the spreadsheet, adding an organization per row. The only essential fields are a column for links to each org’s careers page and a column for notes but I also like to include the name of each organization because it’s not always instantly apparent from the links to jobs pages.
  4. Create a repeating calendar event for yourself every week to block off focus time to look at all the links you’ve collected
  • (Optional but highly recommended) Make sure you have your little treats of choice stocked

I’ve created an example table of what your spreadsheet might look like below.

NameJobs Page LinkNotes
RSPBhttps://www.rspb.org.uk/careers/vacancies-listingPast roles included webdev, IT support and field hardware
Durrell Wildlife Conservation Trusthttps://durrell.occupop-careers.com/#vacanciesConservation org and aye-aye experts
Battersea Dogs and Cats Homehttps://careers.battersea.org.uk/Battersea/HomeHas had webdev, data and other tech roles. Perks involve free vetcare for pets employees have adopted from them!

Weekly spreadsheet use:

  1. (Still optional, but why would you not do something nice for yourself?) Prep your small treat just before your scheduled weekly focus time
  2. Open a blank document in your text editor or note taking application
  3. Open a new browser window
  4. Copy and paste all the jobs page links from your spreadsheet into your multiple link opening extension and open these links in new browser tabs
  5. Quickly tab through the opened jobs pages to scan for listed jobs that sound [like your dream job, like a good fit for, acceptable, tolerable] and copy and paste the URLs of job descriptions for these jobs into your text editor to look at later. Don’t think too much about individual jobs at this stage. If a job sounds at all interesting, put the URL in your notes to think about later.
  6. Make time later in your day or week to filter through your list of interesting jobs and to apply for the ones that survived the shortlisting process.

Strong suggestion: I recommend continuing to use this system even after you’ve found a job. Even if you’re in a job you love! Knowing what companies you would want to work for are hiring for is valuable even when you’re not actively looking for work. Keep the little treats as a part of the process, too. Building in the habit of looking at jobs and having a nice pastry built into your Tuesday mornings won’t hurt you and could help a lot.

Ongoing processes:

This system doesn’t replace researching roles and organizations, you’ll want to continue to make these tasks a part of your job hunt. Your list will become more valuable as you add to it over time.

  • Make a habit of adding new organizations to your spreadsheet as you discover them through your research or as you hear about them in your daily life and wandering across the web.
    • I’ve gotten into the habit of sending myself a note in a Signal message when I hear about something I want to add to my spreadsheet, creating a quick ToDo I can follow up on later without
  • Edit and customize the spreadsheet to meet your needs
    • Delete organizations that don’t hold your interest over time
    • Add notes about orgs and the roles they offer as you see them
    • Add extra fields that you find useful: social media handles, contacts you have..anything that works best for you