Line a Day Journal Spreadsheet

I have occasionally shared ideas I've had to try to keep some sort of daily journal. For different reasons nothing has really stuck. Although I think I may have finally found a system that works for me.

I've been searching for a perfect solution for a while. I like the idea of pen and paper, but in reality this doesn't work for me. If I'm actually going to do it every day, I need it be accessible on my phone, which I can be guaranteed to have nearby. I also like the idea of doing it digitally because then the journal should be automatically backed up and I don't have to consider where to store my journal once it's full. Since I want to have easy access to my journal entries in the years to come, I've been hesitant about committing to any journal apps, which I’m not confident will save my entries in a way I can access without the app.

These desires left me in a tight spot for a while. Also, whenever I would come across one of those "line a day" journals, which often have space for five years on a page (example here) I would really want it. The limited space appeals to my disinclination for journaling, and I love the idea of quickly being able to glance at a day and see it fill up over the years. For a while I wished someone would make an app that would do the same thing, although that would violate one of my own principles I just laid out.


But then I realized I could just do it using a Google spreadsheet (cue angels singing). I have now completed an entry every day since the middle of August. It's easy enough to do since I can save the spreadsheet on my phone for easy access. I also have a nightly reminder set so I don't have to remember to do it. The time investment is minimal, I just make little notes about what we did in a day. And I'm pretty excited to see the entries add up, so I think I may be in for the long haul. Only time will tell.


I've created a sample spreadsheet here if you want to use it. Since this document has public access, save a copy for yourself if you want to use it.


Recent Comments

Louyse Toupin
Louyse Toupin Thu, 02/18/2021 - 08:47

It is very good idea in fact.Thank you.

Karlene Pothier
Karlene Pothier Tue, 06/04/2019 - 08:25

That looks like a wonderful idea!

Tiffany Bodily
Tiffany Bodily Tue, 10/09/2018 - 17:58

What a wonderful idea! Love it.

Robin Inge
Robin Inge Tue, 10/09/2018 - 12:18


Shannon Maguire
Shannon Maguire Tue, 10/09/2018 - 06:33

What a great idea!

Beatrice Loren
Beatrice Loren Tue, 10/09/2018 - 05:10

Great solution. At this point in my life things would not make for very interesting reading lol.

Kate McDougall
Kate McDougall Tue, 10/09/2018 - 04:00

I've saved a copy and going to try this. I feel exactly the same about apps, and struggle with a paper journal.

Cassie Reed
Cassie Reed Tue, 10/09/2018 - 02:53

Cool idea