Skip Navigation

Spreadsheet

Concert & Live-Show Log — Track Every Concert, Setlist, Wishlist & Spending (Excel + Google Sheets)

A concert tracker for Excel & Google Sheets — log every show's date, venue, setlist, and cost, rate the night, and see your whole live-music year.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • Works in Excel AND Google Sheets (and LibreOffice) — one workbook, your choice of app
  • A live Dashboard that counts your live-music year — shows attended, artists & venues seen, top shows, and spending vs. budget
  • A five-part rating per show (Performance, Setlist, Sound & Venue, Atmosphere, Value) that averages into your own My Score
  • A Setlists tab for the songs and moments worth keeping, and a Wishlist for the shows you're still chasing
  • A Spending Log that totals tickets, travel, merch, and more against the annual budget you set
  • Built to total up and screenshot as a "shows I saw this year" wrap-up
  • Three PDF guides — a Start Here, a Playbook, and a printable concert log — plus a one-click Google Sheets copy
  • You own the file — no account, no subscription, no internet needed

The Concert & Live-Show Log is a concert tracker for Excel and Google Sheets that logs every show’s date, venue, setlist, companions, and cost — then counts your whole live-music year for you. You leave a venue at midnight, ears ringing, certain you’ll remember every song, and a season later all that’s left is that it was a good night. This workbook holds onto every one of them: the setlist, the seat, who you stood next to, and the night itself. It’s a spreadsheet you own, not an app you rent.

It opens in Excel, Google Sheets, and LibreOffice — one .xlsx plus a one-click “Make a copy” link for a ready-made native Google Sheet. No account, no subscription, no internet required.

Your live-music year, counted for you

Open the Dashboard and read your year: shows attended, the artists and venues you’ve seen, what you’ve spent against your budget, your top shows by your own rating, and a breakdown by year and by type. Every number reads live from the other tabs — log a show or an expense, and it updates itself. It’s built to total up and screenshot as your own “shows I saw this year” wrap-up.

One row per show — with a rating more honest than a single star

The Shows tab is the heart of it: a row per concert with the date, artist, tour, venue, city, who you went with, your seat, and the ticket price. When you’ve been to a show, rate it across five lanes — Performance, Setlist, Sound & Venue, Atmosphere, and Value — and the workbook averages them into your My Score. Five smaller questions are the difference between “it was great” and actually remembering why one night beat another.

The songs you’ll want again, and the shows you’re still chasing

Some songs land harder live than they ever could on a recording. The Setlists tab keeps them — the show, the song, where it fell in the set, and why it stayed with you. And the Wishlist tab is for the shows you’re hoping to catch: the artist, where and when, the on-sale date to watch, how badly you want it, and a budget — so the next great night doesn’t sell out before you notice.

An honest count of what live music costs

The Spending Log keeps a real total — tickets, travel, lodging, merch, parking — and the Dashboard tracks this year against the budget you set, with a friendly flag when you cross it. Not to spend less; just so a great year doesn’t surprise you on the statement.

Three guides, not just a spreadsheet

It comes with a Start Here guide (how the tabs fit together), a Concert Log Playbook (building a wishlist, rating with intention, and a year-end ritual), and a Printable Concert Log for the days you’d rather hold a pen. The workbook is pre-loaded with a fictional example year so it makes sense the moment you open it — read it once, then overwrite it with your own shows.

Own it, don’t rent it

This isn’t an app that wants your history or your email — it’s a file you keep, on your own computer or in your own Drive, that will still open in ten years. It’s an instant download: the workbook, the Google Sheets link, all three guides, and a Read-Me land the moment you buy. Buy once, and it’s yours.

Want to try it first? The free Concert Log starter is a one-tab taste of the full workbook.

The example data in the workbook is fictional and illustrative — every artist, venue, and rating is invented to show the workbook in use. This is a personal record-keeping template, not professional or purchasing advice, and it is not affiliated with or endorsed by any artist, venue, or promoter.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • A 6-tab workbook (.xlsx): Read Me, Dashboard, Shows, Setlists, Wishlist, and Spending Log — opens in Excel, Google Sheets, or LibreOffice Calc, pre-loaded with a fictional example year of shows
  • One-click Google Sheets copy — a one-page PDF in the bundle with the native-Sheet link; click Make a copy, no import needed
  • Start Here Guide (PDF) — how the six tabs fit together
  • Concert Log Playbook (PDF) — building a wishlist, rating with intention, and a year-end wrap-up
  • Printable Concert Log (PDF) — a shows log, a wishlist, and a setlist-moments page
  • READ-ME-FIRST.txt

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Ready to start

Instant download · Free lifetime updates · Personal use license

$5.95 USD
Buy now

Pairs well with

From the Guides

Hand-picked reading on how to actually use a tool like this.