A writing project tracker gives every idea, draft, deadline, and revision a clear place to live. With a simple spreadsheet or database, you can see what needs attention today without losing sight of the larger project.
Decide what your tracker needs to manage
Before opening a spreadsheet or creating a Notion database, define the type of writing you want to track. A novelist may need chapters, scenes, character notes, and revision passes. A freelance writer may need clients, briefs, invoices, approvals, and publication dates. A blogger may care most about keywords, research, outlines, drafts, and promotion.
Start by listing the projects you currently have in progress. Include unfinished pieces, even if they are only rough ideas. Then write down the questions you regularly need to answer:
- What should I work on today?
- Which projects are waiting for research, feedback, or approval?
- What is the next concrete action for each project?
- How close am I to a word-count or deadline goal?
- Which projects have been abandoned or paused?
- What needs revision before it can be submitted or published?
Your answers determine the columns in the tracker. Avoid adding fields merely because they sound useful. Every column should help you make a decision, remember context, or measure progress.
Choose a tracking tool
A spreadsheet is usually the best starting point because it is fast, flexible, searchable, and easy to export. Google Sheets works well if you want access across devices or occasional collaboration. Excel is a strong option for advanced formulas, filtering, and offline work.
A database tool such as Notion, Airtable, or Coda is useful when each project needs its own page containing notes, research, links, checklists, or chapter records. You can create multiple views, such as a table for planning, a board for workflow, and a calendar for deadlines.
A paper notebook can work for a small number of projects, especially if you prefer handwriting. However, paper becomes harder to search and update when your project list grows. You can also combine tools: use a spreadsheet for the master overview and a separate writing application for the actual drafts.
Choose the simplest tool that supports your current workload. A complicated system that you avoid is less useful than a basic tracker you update consistently.
Build the core tracker
Create one row for each writing project. A project might be a short story, blog post, book, newsletter issue, client assignment, or academic paper. Add these core columns:
| Column | What to record | Example |
|---|---|---|
| Project | A recognizable working title | The Small Garden Guide |
| Type | The kind of writing | Blog post |
| Status | The current workflow stage | Drafting |
| Priority | How urgently it needs attention | High |
| Next action | The next physical or mental step | Draft the introduction |
| Target date | The date you want to finish or submit | 2026-10-05 |
| Current words | Your latest word count | 1,250 |
| Target words | Your intended length | 2,000 |
| Location | Where the draft is stored | Google Docs link |
| Notes | Short context or blockers | Waiting for source citation |
Keep the Status and Next action columns separate. “Drafting” describes the stage, while “write the second section” tells you what to do. Without a next action, a tracker can show that a project is active without helping you begin.
Use consistent status labels. For example:
- Idea
- Planning
- Researching
- Outlining
- Drafting
- Revising
- Awaiting feedback
- Final editing
- Submitted
- Published
- Paused
- Archived
Do not create a separate status for every tiny activity. If you have too many labels, filtering becomes confusing and projects can appear different even when they need the same kind of work.
Add useful writing metrics
Word count is useful, but it should not become the only measure of progress. Add metrics that match the project.
For a word-based project, include Current words, Target words, and Percent complete. In a spreadsheet, the percentage formula can be written as:
=IFERROR(CurrentWords/TargetWords,0)
Format the result as a percentage. If the current word count is in cell G2 and the target is in H2, use:
=IFERROR(G2/H2,0)
Limit the displayed result to 100% if you do not want an overlong draft to show more than complete. A formula such as =MIN(IFERROR(G2/H2,0),1) does this.
For a novel, you might track chapters completed, scenes drafted, or revision passes. For a client article, useful metrics may include brief approved, draft delivered, feedback received, and invoice sent. For a newsletter, track research complete, links checked, draft proofread, and scheduled.
Remember that word count can be misleading. Cutting 500 unnecessary words may represent meaningful progress even though the number decreases. Pair quantitative metrics with a clear status and next action.
Create a realistic workflow
A tracker becomes useful when it reflects how writing actually moves from idea to finished work. Design a workflow with clear entry and exit points.
For example:
- Capture the idea with a working title and one-sentence description.
- Decide whether the project is worth developing now.
- Gather enough research to understand the subject and scope.
- Create an outline or rough structure.
- Write a complete first draft without trying to perfect every sentence.
- Revise for structure, clarity, accuracy, and audience needs.
- Proofread and complete formatting or source checks.
- Submit, schedule, publish, or archive the finished piece.
You can record these stages in a Status column and use a separate checklist for detailed tasks. For a long project, create a second sheet or database for chapters, sections, or scenes. Keep the main tracker focused on the project-level overview so it does not become an unwieldy task list.
Add a “Blocked by” field if your work often depends on other people or resources. Examples include client approval, an interview response, a missing source, or access to an image. A blocked project should not look identical to one you simply have not started.
Add deadlines without creating false urgency
Use separate dates for different commitments. A Target date might be your personal completion goal, while a Submission date is an external deadline. A Publication date may come later.
If every project is marked urgent, priorities stop being meaningful. Use a small priority scale such as High, Medium, and Low. Define each level in advance:
- High: a deadline or important commitment is approaching.
- Medium: progress matters this week but can move if necessary.
- Low: useful work with no immediate consequence.
Plan backward from the final date. If an article must be submitted on Friday, schedule research, outlining, drafting, revision, and proofreading as separate milestones. Leave room for unexpected delays and feedback.
A date should lead to a decision. If a project misses its target date, update the date, change the priority, or mark the project paused. Do not leave outdated deadlines in place because they make the tracker less trustworthy.
Create views that support daily work
A master table is useful for planning, but you probably do not want to scan every project each morning. Create filtered views or saved filters.
A “Today or next” view can show active projects whose Next action is ready. A “Deadlines” view can sort unfinished work by Target date. A “Waiting” view can display projects with statuses such as Awaiting feedback or Blocked. An “Archive” view can hide published, rejected, or permanently paused projects from daily work without deleting their history.
If you use Notion or Airtable, a board view grouped by Status makes workflow bottlenecks visible. A calendar view can show deadlines and publication dates. In a spreadsheet, filters, conditional formatting, and frozen header rows provide much of the same functionality.
Use color sparingly. For example, red can indicate an overdue deadline, yellow can indicate a blocker, and green can indicate completed work. Coloring every status creates visual noise and makes urgent items harder to identify.
Set up a weekly review
A tracker only works if its information stays current. Schedule a short weekly review, preferably on the same day each week.
During the review:
- Add new ideas captured elsewhere.
- Remove duplicate projects.
- Update statuses and word counts.
- Check whether deadlines are still realistic.
- Choose the next action for every active project.
- Identify blocked work and send any needed follow-up messages.
- Archive completed or abandoned projects.
- Select a small number of priorities for the coming week.
Do not turn the review into an opportunity to reorganize the entire system every time. The purpose is to make accurate decisions about your writing, not to decorate the tracker.
For daily use, open the tracker before you begin writing. Select one project and one next action. After the session, record a brief update while the result is fresh. A note such as “outlined sections three and four” is more useful than simply changing the status from Planning to Drafting.
Troubleshoot common tracker problems
If the tracker feels overwhelming, reduce the number of active projects. Keep all ideas in an Inbox or Someday list, but limit your active view to work you genuinely expect to touch soon.
If you repeatedly forget to update it, make updating part of an existing routine. Add it to the end of a writing session, weekly planning block, or submission checklist. Reduce the fields required for each update to status, next action, and one useful measure.
If projects remain stuck in Drafting, divide the next action into a smaller step. “Write the article” is vague; “draft three possible opening paragraphs” is actionable. If you are stuck because of uncertainty, change the action to research, outline, or list questions that need answers.
If deadlines are constantly missed, compare planned effort with actual writing time. You may be underestimating research, revision, administrative work, or interruptions. Set smaller milestones and use a personal buffer before the external deadline.
If the tracker duplicates your task manager, decide which tool owns which information. The writing tracker can own project stage, word count, draft links, and editorial context. A task manager can own reminders and recurring actions. Link the systems only where that saves effort.
If formulas show errors, check that word-count fields contain numbers rather than text, target values are not blank, and dates use a consistent format. For a simple tracker, manual updates may be safer than complicated formulas you do not understand.
Understand the limitations
A tracker cannot decide whether an idea is good, make difficult writing easier, or replace focused time at the keyboard. It also cannot measure every kind of creative progress. Brainstorming, reading, reflection, and cutting weak material may not produce an obvious numerical change.
Avoid treating the system as a surveillance device. If tracking makes you anxious, remove streaks, hourly targets, or competitive comparisons. Use the tracker to reduce mental clutter and support choices, not to assign moral value to your productivity.
Protect sensitive information. If your tracker contains unpublished manuscripts, client details, payment information, or personal notes, review sharing permissions and avoid placing confidential text in a publicly accessible document. Keep full drafts in the writing system best suited to version history and backup.
Start with the core columns, use the tracker for two weeks, and then adjust it based on real friction. The best writing project tracker is not the one with the most features; it is the one that reliably tells you what each project is, where it stands, and what you can do next.