Literature Review Tracker for PhD Students, Dissertation Research Organizer, Excel + Google Sheets, Thesis Synthesis Planner, Gap Analysis

A literature review tracker built for PhD students and grad students who have the research but can't figure out how to turn it into a synthesis. Works in Excel and Google Sheets. Instant digital download.

If you have 20, 40, or 60 papers and no clear picture of what the literature is actually saying, this system gives you the structure to get there.

Built from my own PhD workflow—I used an earlier version of this system during my own dissertation.

PERFECT FOR:
• PhD students trying to make sense of dozens of sources before their committee meeting
• Dissertation writers who keep re-reading the same papers because nothing is sticking
• Thesis writers who have the sources but can't figure out where the gaps are
• Graduate students who want to stop managing their literature review in Google Docs
• Researchers who need to move from collected sources to a structured argument, not just a list of summaries

WHAT'S INCLUDED:
• Excel Literature Review System
• Google Sheets version access instructions
• Quick Start Guide PDF
• ZIP folder containing all files
• File formats: .xlsx (Excel), Google Sheets link

INSIDE THE SYSTEM:
• Instructions — simple setup so you know where to start
• Settings — customize dropdowns to fit your research project
• Master Tracker — organize sources, findings, methods, data type, relevance, citation status, and notes in one place
• Gap Analysis — identify missing evidence, underdeveloped areas, limitations, and research opportunities
• Synthesis and Writing — move beyond article-by-article notes and start connecting themes, patterns, agreements, conflicts, and gaps
• Research Dashboard — see your literature at a glance: progress, findings, methodology, paper role, data type, relevance, and publication timeline

WHY IT WORKS:
• The dashboard gives you a high-level view of your entire review so you can see what you have covered, what still needs attention, and where your sources connect
• The Gap Analysis tab does the work most researchers skip, turning vague "I think something is missing" instincts into a structured list of research opportunities
• It's built around how PhD research actually works, not how it's supposed to work in theory

HOW IT WORKS:
1. Download the ZIP file and unzip it.
2. Open the Excel file or follow the Google Sheets access instructions.
3. Add your sources to the Master Tracker and customize your dropdowns in Settings.
4. Use the Dashboard to see patterns, progress, and coverage.
5. Use Gap Analysis and Synthesis to move from notes toward writing.

Need something simpler? The Literature Review Tracker Lite is also available.

View the Lite Tracker here:
https://www.etsy.com/listing/4505652865/literature-review-tracker-lite-excel

Want the full workflow from research to draft? The Literature Review + Writing System includes this tracker plus the Literature Review Writing Template.

View the bundle here:
https://www.etsy.com/listing/4510646255/literature-review-planner-bundle

FAQ:
What's the best way to organize a literature review for a dissertation?
Start by tracking each source systematically — not just title and author, but findings, methodology, data type, and how each source relates to your argument. Once your sources are organized, use a synthesis tool to identify patterns, agreements, and conflicts across studies. This system is built around that exact workflow.

Does this work with Google Sheets?
Yes. The system is designed in Excel and includes Google Sheets access instructions. Some minor formatting differences may appear depending on your version.

I already track my sources in Zotero or Notion. Why would I need this?
Zotero and Notion are storage tools. They don't help you synthesize. This system is built to move you from collected sources to a structured picture of what the literature says, where it agrees, where it conflicts, and what is missing. That is a different job.

Is this just a basic paper tracker?
No. It includes a Research Dashboard that visualizes your literature across methodology, findings, paper role, data type, and publication timeline. The Gap Analysis and Synthesis tabs are designed to move you toward writing, not just cataloguing.

Is this a physical product?
No. This is an instant digital download. You'll receive a ZIP file immediately after purchase.

Can I use this for a master's thesis, journal article, or policy report?
Yes. The system works for any research-based writing project at any level.

DELIVERY: Instant download. Your files are available immediately after purchase confirmation.