Art Journal Tracker

Setting up an Art Journal Tracker properly

Most people treat journaling like it should just happen by itself, and then they quit within three weeks because they lose track of what they were working on. I set one up for myself about four years ago, mostly because I kept forgetting which sketchbook I was using, what medium I had started with, and whether I had actually finished a piece or just abandoned it on the kitchen table. The system I landed on is simple enough that anyone could build it in an afternoon, but it requires actual discipline to maintain.

Art Journal Tracker isn't really a single product you can buy off the shelf. It's a workflow you build, though there are a few apps that try to do it for you. I've tried about six different ones across that time period. What I ended up using is a combination of a cheap A5 notebook for handwritten notes and a Google Sheet that tracks dates, media, paper types, dimensions, and completion status. The spreadsheet is where the actual tracking happens. The notebook is where I paste swatches and rough thumbnails. The core problem nobody talks about is that most trackers focus on counting completed projects, which is the wrong metric. You want to track time spent per piece, materials used, and what failed. A piece that took twelve hours and went nowhere is still valuable data. My spreadsheet has columns for start date, end date, hours elapsed, paper type, media, outcome (finished, abandoned, study), and a notes field where I dump whatever seemed relevant at the time. I use a color-coding system in the spreadsheet conditional formatting. Green for finished pieces, yellow for works in progress longer than two weeks, red for abandoned projects. This takes about thirty seconds per entry and saves me maybe ten minutes when I'm trying to remember what I was doing before I got distracted by a new technique. The math on that doesn't seem worth it until you've missed three months and have no idea why your output dropped off a cliff.

One edge case I ran into around month fourteen was that I started mixing media across two or three different sketchbooks simultaneously. The tracker showed six active projects but my actual throughput was zero. The workaround was adding a column for "active book count" and flagging any month where I had more than two books open at once. It felt silly, but it worked. I cut my concurrent projects down to one and my completion rate doubled the next quarter.

Building the spreadsheet from scratch

You don't need any special software. A free Google Sheet is all you need. Here is the structure I use and have refined over hundreds of entries. Column A: Project ID. I use a simple format like AJ-2024-001. The date prefix makes sorting by year trivial and the running number prevents duplicates. Column B: Date Started. Column C: Date Completed, left blank until the piece is done. Column D: Hours Elapsed. This is where most people skip it. Track the time or you are just guessing at your productivity. Column E: Paper Type. Specific brand and weight matters more than you think. Arches 140lb cold press behaves completely differently from Strathmore 400 Series toned bristol. You will learn this without writing it down, then you will forget which one the glaze worked on. Column F: Media. Be specific. "Acrylic" tells you nothing. "Daniel Smith fluid acrylics on gessoed linen" tells you something. Column G: Outcome. Finished, Abandoned, Study, Repurposed. Column H: Notes. Free text for whatever happened. Sometimes the note is "ran out of ultramarine blue." Sometimes it is "learned that wet-on-wet does not work over gesso unless you wait twenty minutes."

Column I: Active Book. Which physical notebook this belongs to. This solved my multi-book confusion problem I mentioned above. Column J: Tags. Medium-based tags like "watercolor," "ink wash," "mixed media." These make filtering later almost instant.

Pitfalls I wish someone had told me

The biggest mistake is making the tracking process take longer than the actual art. If entering a project takes more than ninety seconds, you will stop doing it. I learned this the hard way in the first three months when I was trying to track everything down to the milliliter of medium used. That level of granularity is useless after six weeks because you cannot remember which tube you opened on Tuesday. Broad strokes in the data, detailed notes in the free text column. That is the balance. Another thing nobody mentions is seasonal variation. Your tracking data will show patterns that have nothing to do with skill. I noticed in my own data that Q1 always had higher abandonment rates, and Q3 had the longest average session times. The reason was not artistic. It was daylight. Winter sessions in my studio were shorter and more rushed. Summer sessions dragged on because the light stayed good longer. A tracker that just measures output without context will make you think you are getting worse in January. You are not. Your environment changed.

Alternatives if spreadsheets feel like too much

There are dedicated journaling apps. I tried them. Most are built for text diary users, not visual art tracking. The ones that get close include Artful, Journaly, and a few Notion templates floating around the internet. They work if your practice is mostly small daily sketches. They fall apart if you work in large formats or mixed media across multiple sessions. The spreadsheet approach scales better because you control every column. An app imposes its categories on you. If you absolutely want an app, use one that lets you export your data. I cannot stress that enough. I once spent three months logging into a proprietary journal app and then discovered it deleted all my entries during a migration. Three months of data gone because the company decided to change databases. A CSV file on Google Drive would have survived that. Data portability is not a feature. It is insurance.

Maintenance routine that does not require motivation

Set a recurring reminder. Every Sunday evening, spend twelve minutes updating the tracker. Twelve minutes. If you miss a week, do not try to backfill. Backfilling is where the whole thing dies. Just start fresh from the current week. You will lose about three entries per skipped week, and your data will still be accurate enough to be useful. Review the sheet once per quarter. That is where the signal lives. Look at the abandonment column. Look at the hours-per-piece trends. Look at whether you are actually exploring different paper types or just buying the same pad every three months. The tracker does not change your habits by itself. It just makes your habits visible. That visibility is what actually changes things.