Using Excel to Keep Track of Markets – by Mike Michelsen

Using Excel to Keep Track of Markets – by Mike Michelsen

I have been a writer for more than 40 years. As with just about every other writer, I have experienced my share of setbacks. The most frustrating of these are imposed by others. A prime example of this is one that I am sure is still being felt by writers across the country, the loss of Writer’s Market and with it,

As almost any writer knows by now, the 2020 edition of Writer’s Market was the last as far as F & W Books was concerned. This was due to a bankruptcy sale to Penguin Random House.

Frankly, I don’t use Writer’s Market very much anymore since most of my business is with long-established clients. Despite this, I still must keep an accurate record of all phases of a manuscript’s journey – from concept to sale. Making matters worse is that this must be done with all the projects I produce.

Several years ago, Writer’s Market introduced, a platform that allowed writers to keep track of nearly any data they might want to keep. This method was so good, in fact, that when I was audited by the IRS several years ago, this printed record was deemed adequate proof that I operated a bonafide business.

Day of Reckoning
When it came time to renew my subscription, I quickly learned that I was out of luck for the foreseeable future. Not only was all my past data gone, but any hope of having a reliable place to record future business was gone with it. I was suddenly up the proverbial creek without my trusty paddle.

In all fairness, I was not totally without a tool that could be improvised. Other firms produce platforms I could have used to maintain my records, but they were not without limitations. Some were tailored specifically for use with books, others for fiction works, and still others for assorted types of projects. Worst of all, these platforms all required the purchase of a subscription.

Looking for a Solution
I have never been a big fan of Excel. I think it is cumbersome and hard to use for many users, except accountants, and others who regularly use spreadsheets. When I was confronted with my recordkeeping dilemma, however, I couldn’t think of a better solution, which I present here with the hope that it will benefit other equally perplexed writers.

I started this little endeavor with a brainstorming session to determine what headings I needed for a complete record. This was easy since I know the routine by heart. The only real challenge came when trying to improve on the headings with additional data that would be helpful to my uses.

These are the headings I came up with:

Project Name

Project Type: Book, article, or another format

Publisher or Client

Date Project Initiated/Assigned

Rate Agreed Upon

Method of Payment

Source of Project: Assignment, or initiated by client, or query to publisher

Date Project Started

Date Project Completed

Date Project Submitted to Publisher or Client

Date Accepted or Rejected

Date Rewrite Requested: If applicable, date rewrite was requested by publisher or client

Date Rewrite Accepted or rejected. Date of final disposition

Invoice Date

Invoice Amount

Payment Date

Payment Amount

Admittedly, this is a lot of data that some writers might not need. These headings are the categories that are needed by me, my tax man, and my wife. This record serves as a repository of all my projects. To keep it from becoming too unwieldy, I begin a new log at the beginning of each year.

Micro View

Some writers might consider my methodology too cumbersome and hard to use. To this, I might consider pleading guilty, but with an explanation. This is because in addition to this record, I also keep a record with each project file. This file allows me to keep more detailed track of submissions for individual projects.

These headings are:

Submission Number: Total number of manuscript submissions

Publisher or Client: Name of publisher or client

Date Project Initiated: Date project started

Rate Agreed Upon: Rate or method of payment

Date Project Submitted. Date sent to publisher or client

Date Accepted or Rejected: Project disposition

Date Rewrite Requested: Date rewrite was requested by publisher or client

Date Rewrite Requested or Rejected: Date of final disposition

Payment Amount: Amount paid

Date Received: Date fee is received by the writer

If there is a benefit to using Excel, it’s being able to tally the number of projects as well as the number of receipts received all at the touch of a button. Excel also allows the user to expand the size of a column to whatever is needed to accommodate the amount of copy needed. A writer can also use Excel’s color-coding feature to highlight projects that are nearing in deadline, or that demand other attention.

It cannot be overemphasized that this format is customizable to the needs of the writer. Some will probably need additional columns to incorporate more data. At the same time, others might need less. What matters most is the ability the tool gives a writer to make their data complete and easily accessible for their needs.


Mike Michelson has been a writer for more than 40 years, and have published in numerous publications, including small local newspapers as well as national magazines such as Business Week, US News and World Report, and many more.

We’re always looking for more articles, and we’ll pay $60 for them! Check our guidelines here:

Fall 2020 24 Hour Short Story Contest


90+ DAYS OF PROMOTING YOUR BOOK ONLINE: Your Book's Daily Marketing Plan by Angela Hoy and Richard Hoy

Promoting your book online should be considered at least a part-time job. Highly successful authors spend more time promoting a book than they do writing it - a lot more.

We know what you're thinking. You're an author, not a marketer. Not to worry! We have more than a decade of successful online book selling experience under our belts and we're going to teach you how to promote your book effectively online...and almost all of our techniques are FREE!

Online book promotion is not only simple but, if you have a step-by-step, day-to-day marketing plan (this book!), it can also be a very artistic endeavor, which makes it fun for creative folks like you!

Yes, online book promoting can be EASY and FUN! Let us show you how, from Day 1 through Day 90...and beyond!


The Fearless Freelancer: How to Thrive in a Recession

Want to Recession-Proof Your Freelance Business?

Freelancing in a recession doesn’t have to be scary. The Fearless Freelancer gives you a proven, step-by-step process for getting steady, high-paying clients—from a freelancer who’s thrived during two recessions.

Whether this is your first recession or you’ve been through this before, discover how to:

  • Boost your confidence so you can stay calm and focus
  • Stand out in a sea of freelancers so clients choose you
  • Make freelance marketing as easy as tying your shoes
  • Find high-paying clients that still need freelancers now
  • Create marketing that will attract those clients
  • Succeed in a recession even if you’re a new freelancer

Free Bonus Content
Also get dozens of checklists, templates, and other tools to help you recession-proof your freelance business, including:

  • Simple Strategic Plan for Surviving the Recession
  • The Ultimate LinkedIn Profile Checklist for Freelancers
  • Awesome Freelance Website Template



So, You Wanna Be a Ghostwriter - How To Make Money Writing Without a Byline

Many freelance writers find it difficult to break into the publishing world. What they don't know, however, is that there's a faster and easier way to see their words in print. It's called ghostwriting, and it's an extremely lucrative, fun, and challenging career.

But how do you get started as a ghostwriter? How do you find new clients who will pay you to write their material? How do you charge? And what kind of contracts do you need to succeed? All these questions and more are answered in So, You Wanna Be a Ghostwriter...How to Make Money Writing Without a Byline.

Read more here:



7.625 STRATEGIES IN EVERY BEST-SELLER - Revised and Expanded Edition

At this moment, thousands of would-be authors are slaving away on their keyboards, dreaming of literary success. But their efforts won’t count for much. Of all those manuscripts, trade book editors will sign up only a slim fraction.

And of those titles--ones that that editors paid thousands of dollars to contract, print and publicize--an unhealthy percentage never sell enough copies to earn back their advances. Two years later, most will be out of print!

Acquisition Editor Tam Mossman shares seven essentials every book needs to stay in print, and sell!

Read more here: