For today’s task, we’re going to set up a submission spreadsheet. This is much simpler than it sounds, and it will make submitting your work in 2014 so easy to track. If you want to cheat, just get a subscription to WritersMarket.com, which includes a submission tracker.
Here’s how to create your own spreadsheet:
- Open a spreadsheet program. Excel works fine. Using the Google spreadsheet is fine. Whatever you’re most comfortable using.
- Label first column Submission. In this column, you’ll keep track of the query idea, completed story, poem, etc.
- Label second column Market. In this column, you’ll keep track of which markets you’ve submitted your work.
- Label third column Sub Date. In this column, you’ll keep track of the date you submitted.
- Label fourth column Accepted. In this column, you’ll either mark Yes or No. Hopefully, it’ll have more acceptances than rejections.
- Label fifth column Notes. In this column, keep track of any extra information. For instance, when to follow up–or if the piece is accepted, what the terms are, when the piece is due, payment, etc.
Keep it simple at first. As you find more success and submit more, you may find that more columns will help you sort information easier. But the organization outlined above is just right for your first submission spreadsheet.
Land a book deal in 2014!
Learn how to land a book deal with this live webinar, taught by Jane Friedman.
Robert Lee Brewer is Senior Content Editor of the Writer’s Digest Writing Community and author of Solving the World’s Problems. He edits books, writes an article for Writer’s Digest magazine, manages multiple blogs, creates a freely weekly newsletter on publishing and so much more. He’s married to the poet Tammy Foster Brewer, who helps him keep track of their five little poets. Follow him on Twitter @robertleebrewer.
Here are a few recent challenge posts: