Excel Bullet Journal Template: Setup & Free Options

How-to basics · Updated November 22, 2026

Yes, you can use an Excel bullet journal template to plan your days, track habits, and log tasks digitally, and the simplest way to start is to build a basic monthly log with columns for Date, Task, and Status, or download a free pre-made template from Microsoft’s official template gallery. Unlike a paper bullet journal, an Excel version lets you sort tasks, auto-calculate progress, and access your planner from any device with Excel installed. Below I’ll walk you through the core components, how to build your own, where to find free templates, and how to adapt the classic bullet journal method to a spreadsheet.

What Is a Bullet Journal and How Does It Fit in Excel?

The bullet journal method, created by Ryder Carroll, is a flexible analog system that uses rapid logging—short bullet points for tasks, events, and notes—organized into an index, future log, monthly log, and daily log. In Excel, you can replicate these modules as separate sheets or as sections within one workbook. The key advantage is automation: you can use formulas to count completed tasks, conditional formatting to highlight overdue items, and data validation to create dropdown menus for statuses like “Done” or “In Progress.”

Excel is not a note-taking app, so it works best for structured tracking rather than freeform journaling. For example, you can keep a “Daily Log” sheet with rows for each day and columns for tasks, but you won’t have the same ease of writing long reflections as you would in a paper notebook. However, if you mainly need to track habits, appointments, and to-dos, an Excel bullet journal is a powerful, low-cost alternative.

Core Components of an Excel Bullet Journal

A typical Excel bullet journal template contains several sheets, each mimicking a paper journal section. Here are the most common ones:

  • Monthly Log: A calendar grid or a list of days with space for tasks and events. In Excel, you can create a 7-column grid (Sun–Sat) and use formulas to auto-fill dates.
  • Daily Log: A running list of tasks for each day, often with columns for Date, Task, Category, and Status.
  • Habit Tracker: A grid with habits as rows and days of the month as columns; you can use checkboxes or a simple “X” to mark completion.
  • Future Log: A place to jot down events or tasks for months ahead, often a table with Month, Date, and Event columns.
  • Collections: Any specialized tracker, such as a reading list, workout log, or meal planner. You can add sheets as needed.

Most free templates combine these into one workbook with tabs at the bottom. Some include a “Dashboard” sheet that summarizes your progress using formulas like COUNTIF.

How to Build Your Own Basic Template in Excel

If you prefer a custom template, you can build one in about 15 minutes. Here’s a simple monthly log setup:

  1. Open Excel and create a new workbook. Rename the first sheet “Monthly Log”.
  2. In row 1, enter headers: Date, Task, Category, Status.
  3. In column A, list the days of the month (e.g., 1, 2, 3…). You can use the formula =DATE(2025,1,1) in A2 and drag down, then format as “d”.
  4. Add a dropdown for Status: select the cells in D2:D32, go to Data > Data Validation, choose “List”, and enter Done,In Progress,Not Started.
  5. Add a “Habit Tracker” sheet. In row 1, put days 1–31 (or just weekdays). In column A, list habits like “Exercise”, “Read”, “No Sugar”. Use checkboxes: Insert > Checkbox (available in Excel 365) or simply type “X”.
  6. To count completed tasks, use a formula like =COUNTIF(D2:D32,"Done") in a summary cell.

For a daily log, create a sheet with columns Date, Task, Category, and Status, and add new rows each day. You can sort by date using Data > Sort.

Where to Find Free Excel Bullet Journal Templates

Microsoft offers a variety of free planner templates directly in Excel. To access them, open Excel and go to File > New, then search for “planner” or “bullet journal”. You’ll see options like “Monthly Budget Planner” or “Habit Tracker”. Many are simple and editable. Third-party sites like Vertex42 and Smartsheet also offer free downloadable Excel planners, but be cautious: some may require enabling macros or contain ads. Always download from reputable sources to avoid malware.

If you have Microsoft 365, you can also use the “Excel for the web” templates, which are similar. For a truly custom option, you can search for “bullet journal Excel template” on sites like Etsy, but many free versions are available.

Key Formulas and Features to Automate Your Journal

The real power of an Excel bullet journal comes from formulas and conditional formatting. Here are a few essential ones:

  • Count completed tasks: With statuses in D2:D20, use =COUNTIF(D2:D20,"Done") to see how many tasks you’ve finished.
  • Calculate completion percentage: Use =COUNTIF(D2:D20,"Done")/COUNTA(D2:D20) and format as a percentage.
  • Highlight overdue tasks: Select your task range, go to Home > Conditional Formatting > New Rule, choose “Use a formula”, and enter =$C2 (assuming C is the due date column). Set a red fill.
  • Auto-fill dates: In a monthly grid, use the SEQUENCE function (Excel 365) to generate dates: =SEQUENCE(6,7,DATE(2025,1,1)) – this creates a 6-row by 7-column array starting from Jan 1, 2025.
  • Track habit streaks: If you mark habits with “X”, you can count consecutive days using a more complex formula, but a simple weekly count is easier: =COUNTIF(B2:H2,"X").

Remember that formulas update automatically when you change data, so your dashboard always reflects your current progress.

Common Problems and How to Solve Them

Users often encounter a few issues when using Excel for bullet journaling:

  • Dates not updating: If you use static dates, they won’t change each month. Use the =TODAY() function for dynamic dates, but note that it recalculates every day, which may not be desired for a monthly log. Instead, use a formula like =DATE(YEAR(TODAY()),MONTH(TODAY()),1) to get the first of the current month.
  • Checkboxes not working: In Excel 365, checkboxes are available via Insert > Checkbox. In older versions, you can use data validation with “List” and enter “TRUE,FALSE” to create a dropdown, or use a simple “X” manually.
  • Printing issues: If you want to print your journal, set the print area and adjust page breaks. Go to Page Layout > Set Print Area, and use View > Page Break Preview to adjust.
  • Losing data: Always save your workbook to OneDrive or a backup drive. Excel autosaves if you’re using Microsoft 365, but it’s wise to make a manual copy each week.

Comparing Excel to Paper Bullet Journals and Other Apps

Excel bullet journals are not for everyone. Paper bullet journals offer a tactile, creative experience and no screen time, but they lack search and automation. Apps like Notion, Trello, or dedicated bullet journal apps like “Bullet Journal” for iOS provide more flexible note-taking and cross-device sync, but they may have a steeper learning curve or subscription costs. Excel sits in between: it’s widely available, customizable, and free if you already have Office, but it requires a bit of spreadsheet know-how. If you prefer handwriting, a paper journal is better; if you want automatic reminders and data analysis, Excel wins.

Cost, Safety, and Privacy Considerations

Excel is not free unless you have a Microsoft 365 subscription (about $6.99/month) or use the free Excel for the web. Paper notebooks are cheaper upfront but add up over time. When downloading templates, be cautious of files that ask for macros or personal information—stick to trusted sources. Also, if you store sensitive data like health or finance information in your journal, protect the workbook with a password: File > Info > Protect Workbook > Encrypt with Password. Remember that Excel files are not encrypted by default, so password protection is essential for privacy.

Frequently Asked Questions

Can I use Excel bullet journal on my phone?

Yes, the Excel mobile app (iOS and Android) can open and edit your template, but the interface is limited. You can check boxes and add text, but complex formulas and conditional formatting are harder to manage on a small screen. For daily quick logging, the mobile app works fine, but for setup, use a desktop.

How do I make a habit tracker in Excel?

Create a new sheet, put habits in column A (e.g., “Exercise”, “Read”), and days 1–31 in row 1. In each cell, insert a checkbox (Excel 365) or type “X”. Use conditional formatting to color cells green when they contain “X”. To count weekly habits, use a formula like =COUNTIF(B2:H2,"X").

Is there a way to sync my Excel bullet journal with my calendar?

Excel doesn’t natively sync with Outlook or Google Calendar, but you can export your data as a CSV and import it into a calendar app, or use Power Automate (Microsoft’s automation tool) to create flows. For a simpler solution, copy your deadlines into your calendar manually.

Can I use Excel bullet journal for budgeting?

Absolutely. Many people combine a budget tracker with their bullet journal. Use a separate sheet with income and expense columns, and use formulas like =SUM(B2:B20) to total. However, Excel is not a dedicated budgeting app, so it lacks automatic bank feeds. Always verify your numbers manually.

What if I don’t have Excel? Can I use Google Sheets?

Yes, Google Sheets is a free alternative that works similarly. You can use the same formulas (with minor differences, like =COUNTIF works the same), and you can access your journal from any browser. Google Sheets also has built-in templates for planners. The main difference is that Google Sheets is cloud-based, so you don’t need to save files locally.

How do I print my Excel bullet journal without cutting off columns?

Go to Page Layout > Scale to Fit, and set the width to “1 page” and height to “Automatic”. Also, adjust column widths to fit content. Use Print Preview to check. If you want a two-sided print, set the print area for each sheet.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.