Organizing This Mess
I’ve found two methods for keeping track of submissions. Which you choose depends on how your brain works. Some writers are “pansters,” some are “plotters.” Some people are night owls, some are morning people – it’s like that. You’ll know which method is right for you the minute you read the description, I promise.
Does the thought of using Excel make your eyes glaze over? Is your favorite method of organization a shoebox, or a closet with a door you have to lean on to close? No worries. There’s a tool for you that’s so easy and non-threatening that, although I mentioned it in Part 2 of this series, I’m going to include it here.
Any right brainers that know another good tracking method, please post in the comments – we’d love to know!
Writers Market.com – It has a huge, up-to-date database on agents. It costs $40/yr, but it’s worth every penny. I used it for my first submission experience, and it was wonderful. It’s everything you need in one place, plus things others don’t have. You search by genre, and you can narrow your search.
One of the best things about it is that it has a “Query Tracker.” You select the agent you’re submitting to, note the date, and when you should hear back. After that date, you’ll get a reminder, so you can follow up.
Simple, organized, unintimidating.
For those of you who have your home library sorted by Author and Title, and could lay your hands on anything you own in the dark, read on.
My daytime title is corporate CFO. Sounds impressive, but it’s just a fancy name for “numbers geek.” As you can guess, I love Excel. It’s in my genes, I can’t help it.
So I created an Excel spreadsheet to track my submissions.
Excel For Authors –
Two key tools in one spreadsheet: WHO you want to submit to and TRACKING submissions.
When I research an agent, I give them a tier and a rank to help determine who I will submit to in what order.
Then I pull all pertinent information from their website into the Excel spreadsheet:
I’ll share a copy of my sheet as an example – but please do not assume the information is correct – I’ve “dummied” a lot of it to protect the innocent!
Sheets in my file:
When you’ve exhausted all submitting avenues, heard back from every possible agent, and are still not successful in snagging representation for your book, DO NOT delete this file! It has valuable information for submitting your next novel (and there WILL be a next novel, right?). On the next round you will need to know:
You’ll still need to do your research! Do not assume that nothing has changed since your last submission: look up submission guidelines, email addresses, etc. Agents come and go, and change agencies frequently. Also, new agents may have gotten in the business since your last submittal, and you won’t want to miss them.
Remember that agents typically only request from 10% of the queries they receive. You are working to be in that 10%! I hope you’ve found this series of blogs helpful – please post any info/suggestions I haven’t covered “comments section.”
In the spirit of free information on the internet, I’d be happy to forward you my Excel Spreadsheet template to help you get organized. Simply send me an email at:
I wish you all a happy and successful hunt – go bag your trophy agent!
Copyright © 2022 Writers In The Storm - All Rights Reserved