Magazine and Journal Submission Tracker: Spreadsheet Fields, Statuses, and Rights Checks

Overview

A magazine and journal submission tracker is more than a list of publication names. It is a working record of decisions, deadlines, correspondence, rights, and next actions. Without one, writers can lose track of whether a piece is still under consideration, forget a requested revision, submit the same exclusive manuscript twice, or miss the point at which a follow-up becomes appropriate.

You can build a tracker in a spreadsheet, database, or writing-management application. The tool matters less than the structure. A useful tracker should answer five questions quickly:

• What work did I submit, and where?
• What is the current status?
• What rights or exclusivity terms apply?
• When should I take the next action?
• What evidence supports the record?

Use one row per submission rather than one row per manuscript. If the same essay goes to three publications at different times, record three submissions. This preserves a clear history and prevents a later acceptance or withdrawal from obscuring earlier activity. Writers managing blog pitches can use the same approach; the writing submission tracker template provides a useful companion for pitches, deadlines, rights, and responses.

What to track

Core identification fields

Begin with fields that identify the work and publication without relying on memory. Recommended columns include:

• Record ID: A simple number or code for sorting and discussing entries.
• Work title: Use the title submitted, including a version label when relevant.
• Work type: For example, short story, essay, poem, article, research manuscript, or query.
• Publication: Record the magazine, journal, department, or named editor.
• Publication URL: Link to the relevant submissions page or guidelines.
• Category or section: Note the section to which the work was sent, if applicable.
• Submission method: Website form, email, postal mail, or a submission-management platform.

Keeping the guidelines link in the row is especially helpful because requirements can change. Before submitting, compare your file, word count, formatting, and cover note with the publication's current instructions. See the article submission format guide for a checklist covering common file, biography, citation, and formatting considerations.

Dates and workflow fields

Dates make the tracker actionable rather than archival. Include:

• Draft completed: The date the version became ready for submission.
• Date submitted: The date shown in your confirmation or sent email.
• Expected response window: Copy the publication's stated estimate or mark it as unknown.
• Follow-up date: The date you will check in if no decision arrives.
• Last contact: The most recent message, request, or status change.
• Next action: A short instruction such as “wait,” “send follow-up,” “revise,” or “withdraw.”

Do not convert an uncertain response time into a false deadline. If guidelines say responses vary, record “varies” in the notes and choose a reasonable review date for yourself. A follow-up date is a planning tool, not a claim about the publication's obligations.

Status and correspondence fields

Use a controlled status list so that similar situations are recorded consistently. A practical taxonomy is:

• Researching: You are checking fit and requirements but have not submitted.
• Ready: The work is prepared and awaiting a final compliance check.
• Submitted: The submission was sent and confirmation is pending or received.
• Under consideration: The publication has acknowledged or retained the work.
• Editorial request: The editor has requested clarification, changes, or a new version.
• Accepted: The publication has offered acceptance; record the terms separately.
• Rejected: The publication declined the work.
• Withdrawn: You removed the work before a decision.
• Published: The work appeared, with the publication date and URL recorded.

Add a correspondence log field or a linked second sheet for messages. Record the date, sender, subject, and a short summary. Keep copies of confirmations, editorial requests, and acceptance letters in a folder whose filename matches the tracker record. This creates an audit trail without filling the main sheet with long emails.

Rights and exclusivity checks

Rights fields deserve their own attention because an attractive acceptance can create a problem if the terms are unclear. Add columns for:

• Rights requested: For example, first publication, nonexclusive publication, reprint, translation, audio, or electronic rights.
• Exclusivity: Record whether the submission itself, a period after publication, or a specific territory is exclusive.
• Exclusivity end date: Use this only when the terms provide a definite date or period.
• Previously published: Mark whether the work has appeared elsewhere, including on your own site.
• Rights notes: Capture unusual language and link to the relevant agreement.
• Permission needed: Note any third-party images, quotations, data, or excerpts requiring clearance.

Do not assume that “accepted” means all rights are settled. Read the offer, contract, or publication terms and ask for clarification before agreeing to language you do not understand. If guidelines require an exclusive submission, mark the work as unavailable to other publications until the exclusivity period ends or you formally withdraw it. The guide to submission guidelines red flags can help you identify unclear requirements and risky terms during research.

Cadence and checkpoints

A tracker works best when it is reviewed at predictable intervals. Use a short weekly check for active work and a deeper monthly or quarterly review for the whole portfolio.

Weekly check

Once a week, filter the sheet for entries with a due action in the next seven days. Check confirmations, respond to editorial requests, update statuses, and move completed records out of the active queue without deleting them. Then review any submission approaching its follow-up date.

Monthly review

At the end of each month, inspect all entries marked submitted, under consideration, or editorial request. Verify that follow-up dates are still sensible, links open, and rights notes are complete. Compare your records with email and submission-platform accounts so that a decision is not missed. Update publication guidelines for opportunities you plan to use again.

Quarterly review

Every quarter, review the tracker as a portfolio rather than a collection of individual tasks. Identify publications that no longer fit your work, recurring delays in your own process, and pieces that have been inactive for too long. Archive duplicate or obsolete research rows, but retain the submission history. Export a backup before making major structural changes.

For spreadsheet imports, keep dates in a consistent format, use one value per cell, avoid merged cells, and reserve the first row for column headings. If you move the tracker to another tool, test the import with a copy first. Confirm that dates, links, dropdown statuses, and notes have transferred correctly.

How to interpret changes

A status change should usually lead to a specific action. When a submission moves from “submitted” to “under consideration,” update the date and wait according to the publication's stated process. When an editor requests a revision, create a new version number, save the request, and record the response deadline. Do not overwrite the original submission details; they may be needed to understand which rights and terms apply.

If a submission is rejected, record the decision date and any useful feedback. Then check the rights field before sending the work elsewhere. A rejection may release the manuscript, but the terms of the original submission or a separate agreement determine what you can do next. If the work is accepted, pause other submissions of the same piece and complete a rights review before confirming.

Use notes to distinguish facts from assumptions. “Editor confirmed receipt by email” is stronger than “probably received.” “Guidelines state responses within eight weeks” is different from “follow up after eight weeks.” This distinction makes the tracker dependable when several months have passed.

When to revisit

Revisit this workflow whenever your submission volume, publication type, or rights situation changes. A writer sending occasional essays may need only one sheet and a monthly review. Someone managing simultaneous magazine, journal, and blog submissions may need separate tabs for active submissions, publication research, correspondence, and rights.

Update the tracker immediately when you receive an acceptance, rejection, withdrawal confirmation, revision request, or rights-related message. Review it monthly for active deadlines and quarterly for structure. Also revisit the publication's guidelines before every new submission, even when the publication is familiar. Requirements, editors, sections, and submission windows can change.

To put the system into practice, create the columns first, add your current submissions, and assign one clear status to each row. Then set the next action and date for every active record. For new research, the journal submission guide and research framework for finding relevant publishers can help you evaluate fit before adding an opportunity. Finally, schedule a recurring monthly review. The goal is not a complicated database; it is a current, rights-aware record that lets you submit confidently and know what needs attention next.