When doing freelance writing work or when submitting your written work to various publications it becomes very easy to lose track of what was sent where and to whom. Here is an easy way to keep track of all those queries by using Microsoft Excel or a similar spreadsheet.
Open your spreadsheet and give it a title. I title mine Queries.
I use five separate folders titled Contests, Freelance, Magazine, Online, and Other. Create different folders for different kinds of queries. Creating separate folders simply makes tracking your queries that much easier.
Decide what important information you need to keep track of in your Query spreadsheet. I track the following details of a query: Name of publication, Contact information, Type of query (email, phone, or snail mail), date query was sent and Other. The Other column is for any other pertinent information.
Track answers you receive to your queries by highlighting in different colors. For example, you can use yellow for queries that have been sent but have not been answered and green for queries that have been answered and given the green light. You get the idea.
Add a column for notes. This column becomes very useful when talking to an editor on the phone or through email because you can refer back to the dates and times you have spoken with the editor before.
Keep copies of your query spreadsheet so that you can double-check to see if you have submitted to a certain venue before and what their answer was. Update your spreadsheet on at least a weekly basis. Don’t forget to back up your work frequently!
Want to keep track of your writing queries online? Check out Query Tracker online. It’s online and very user friendly!