When sending out your work for possible publication it can sometimes be difficult to keep track of what has been sent where. To help with this, we’ve put together a simple Excel spreadsheet which you can download and use to track submissions. Excel is more flexible than you might think – a few features of our spreadsheet are listed below. It is, of course, intended only as a starting point. Feel free to adapt the spreadsheet to suit your own needs.
The file above comes preloaded with some example entries. Just delete them when you’re ready to start using it. Rows are colour-coded according to the entry in the “Response” column – so rejected submission are highlighted in red, withdrawn submissions in grey and accepted ones in green. You might also notice that if the date by which you are expecting a reply to your submission has passed, the entry in that column will turn red, allowing you to instantly see if you should send a query.
It’s best to enter submissions in the order you send them. If you wish to take a look at the record for a particular story or market all you have to do is navigate to the “Data” tab, and then click “Filter”. You’ll then be able to use a drop-down menu from each column to select which records you wish to see.
This spreadsheet was made using Microsoft Excel 2007, and should be compatible with this and all more recent versions of the program. Let us know if you find it useful – or if you have suggestions about how it could be improved – by leaving a comment below.