It's rejection season! Seven rejections so far this month. My friend Sonam asked me how I handle it - so many "no"s. I've written about rejection before but not about my spreadsheet. The spreadsheet is key to the whole "brush it off" process. (It's also key to staying sane and organized.)
The format doesn't matter too much. Submitted. Rejected. Accepted. That's all you need. Create the spreadsheet as soon as you start sending your work out. That way, when the replies come in, you'll have a place to tally them up and something concrete to do.
The act of filling in the boxes can be analgesic. You read the rejection. You fill in the spreadsheet. Decide if you need to revise the story. If not, because you can see at a glance which publications haven't seen the story yet, you can re-submit right away. The goal is to have as few stories in the rejected section as possible.
Recently, I began jotting down alternative publications beside each submitted story. I highly recommend this approach. It makes re-submitting even more automatic and leaves zero time for brooding.
Writers! If I can give you one piece of advice: stop feeling sorry for yourself. That is precious time when you could be writing, editing, submitting, reading or binge watching Orange is the New Black.
Eventually something will stick. A story will be accepted and then you can move it to the "published" section of the spreadsheet (keep it visible, close to the rejected list). This is important because you can see over time how stories graduate from rejected to accepted. And keeping track of which publications rejected the stories will also help you see the truth: that taste is subjective. Just because a story is rejected doesn't mean it's worthless. Sometimes, yes, the story needs work. And if a rejection comes with feedback, consider it a gift. But often a rejection from one publication is only that: a rejection from one publication.
The spreadsheet speaks the truth. Look at all those acceptances! Look at all those rejections! Being a writer means being rejected. So go send your work out, go court rejection.