Forty Agents, One Spreadsheet: My Rejection Data, Annotated

There's a strange silence around querying in the UK writing world. Everyone does it, nobody talks numbers. You hear folklore — 'it took her six months', 'he got an offer from the third submission' — but almost never the data. So when I finished my novel and sent it out to forty literary agents, I did what any self-respecting spreadsheet gremlin would do: I tracked everything.

Submissions went out between January and September. Forty agents, found primarily through the Writers' & Artists' Yearbook, QueryTracker, and the acknowledgements pages of books similar to mine (an underrated research method — writers thank their agents, and those agents are demonstrably interested in that kind of book).

The Raw Numbers

Let's start with the headline figures:

• 40 queries sent
• 31 responses received
• 9 no-response closures (the dreaded 'if you haven't heard in eight weeks…')
• 2 full manuscript requests
• 1 partial request
• 0 offers of representation
• Average response time: 54 days
• Fastest rejection: 4 hours (a Sunday evening, no less — respect)
• Longest wait: 187 days, ending in a form rejection

A 5% full request rate. For context, industry chatter puts the average at somewhere between 1% and 5%, so I was — and I'm choosing to frame it this way — statistically unremarkable in every direction.

Form Letters vs. Personalised Rejections

Of the 31 responses, 24 were form rejections. Identical wording, presumably copy-pasted, occasionally addressed to a different author's name (I'm not bitter, but 'Dear Hannah' did sting).

Seven showed signs of human involvement. Two mentioned something specific — one noted my 'assured dialogue', the other said the opening chapters 'promised more than they delivered', which is devastating and, having reread them, correct. One agent personally wished me luck and said they'd 'keep an eye out', which I have chosen to believe means they're monitoring my career from a distance rather than a polite brush-off.

Here's the pattern worth noting: the personalised rejections came disproportionately from agents at smaller agencies who read queries themselves. The big agencies, with assistants triaging the inbox, produced form letters at nearly 100%. Neither approach is wrong. But if you're hungry for feedback, smaller agencies are where it lives.

What Actually Correlated With Requests

Sample size of three, so treat this as anecdote dressed in a lab coat. But the three agents who requested material all had one thing in common: my query letter led with the story, not with my bio or my comp titles. The rejections clustered around versions where I'd front-loaded my credentials (at the time: 'writer based in Leeds' — thrilling stuff).

Also: the one request that made the whole exercise worthwhile came from a query I almost didn't send. I'd decided the agency was 'out of my league', whatever that means. It sat in my drafts for a fortnight. The lesson, which every writer knows and none of us believe: the gate is only closed if you don't knock.

Is the Slush Pile Worth the Postage?

Metaphorical postage, these days — everything was email except one agency that genuinely still wanted a stamped addressed envelope, which felt like receiving a letter from 2009.

Honest answer: yes, with conditions. The traditional route gave me a clearer sense of my own manuscript than any paid critique. Forty rejections is a brutal editing seminar. After the 'promised more than they delivered' note, I rewrote my opening. The book is better. The data says the book was the problem, not the system — my comp titles were off, my first line of the query was weak, and my synopsis was, in retrospect, a plot summary written by someone who'd forgotten plots need tension.

But I'd also say this: the numbers justify a pivot. I've since taken the novel to a developmental editor privately, and I'm eyeing the small press route, where unsolicited manuscripts are sometimes welcomed without an agent at all. The gatekeeping is real — 40 attempts produced zero conversations about money or contracts — but it's not the only door in the building.

The Spreadsheet, Shared

I've had several writer friends ask for the tracking template. It's nothing fancy: agent name, agency, date sent, date responded, response type, personalised (Y/N), notes. The 'notes' column is the important one. 'Form rejection, 54 days' tells you nothing. 'Form rejection, but they represent [book I love]' tells you where to look next.

If you're about to start querying: build the tracker before you send a single email. Not because the data will get you an agent — it won't — but because a spreadsheet turns an emotional ordeal into a project. And a project, unlike a rejection, is something you can work on.

Forty agents. Thirty-one responses. Two fulls. One rewrite that made everything better. Ask me again in a year, when the next batch goes out.