One of the tasks of a writer is to keep track of where, and when, you have submitted articles. You need to know where so you don’t resend to a publication that has previously rejected it. You need to know when, so you can follow up when you don’t hear back.
There are numerous ways to keep track of them. What I use is a spreadsheet system described by C. Hope Clark in her article Keep 13 In Play. This system made sense to me, so I created a spreadsheet based on her suggestions. I like the spreadsheet and find it helps me keep track of things. The biggest drawback for me is there are 3 sheets to complete for each submission – one by date, one by title and one by publication – but I believe having access to the information in multiple ways helps me be more organized.
Click the link to start the download – Submissions Spreadsheet Blank.
It downloads in .xls format and you can edit it to suit your needs. You can move, rename and add columns, as well as change the size of the rows and columns. I’d love for you to give it a try and see if it works for you.
If you find it doesn’t work for you, google “free submission tracker” and see what else is available.
Good luck and keep writing!