When Lisa first asked me to guest post, I jumped at the chance. Then, I was like "uh-oh". I've never done a guest post before and had NO idea what to write about. Then my friend Martina reminded me that I should write what I know. So what do I know? Spreadsheets. I am the spreadsheet queen. I use them for anything and everything. So, today I'm going to share with you a couple of ways that I use spreadsheets.
|Photo by CraigMoulding on Flickr|
2. Agent Tracking For any aspiring author, a spreadsheet of agent contact info would be an excellent tool for querying. Example column headings could include: Agent, Agency, Genres Accepted, Submission Guidelines, Average Response Time, Date Queried, Response. Or anything else that is relevant to your agent search. You can download the Agent Tracker I created for myself. Here are some great links where you can find info on agents and what they're looking for: QueryTracker Agent Query Connect Literary Rambles On my spreadsheet, I also included a "Wishlist" column. There's an interesting Tumblr that pulls Tweets posted by agents with their Manuscript Wish Lists. And of course, you can always check out our Agent Roundup posts on Adventures in YA Publishing for some insight into what agents are looking for: July Agent Roundup May Agent Roundup February Agent Roundup
I hope that you can use these ideas to make your writing life simpler and more organized. I'll be posting more spreadsheet ideas on Adventures in YA Publishing in the next few months, so be sure to keep an eye out! If you have any questions, please ask in the comments, and I will definitely answer to the best of my ability. Or if you have a use for spreadsheets that I didn't mention, please tell us about it. I'm always looking for new ways to use them!
Adventures in YA Publishing. She writes YA fantasy of the contemporary and traditional varieties. Instead of unpublished, she prefers to call herself pre-published. While she enjoys drafting, her heart is truly in rewriting and editing. In the past, she may or may not have been called a "Grammar Nazi." She loves spreadsheets, ladybugs, fairies, blue roses, cats, musical theater, and pretty much all things geek. She lives in Oklahoma with a husband, two kids, two cats, a dog, and a mother. You can find Jan on Twitter at @janlewis77.