Home › Compare › Spreadsheet

Spreadsheet vs app

Tracking concerts in a spreadsheet vs a concert diary app

If you have been keeping your gigs in Excel, Google Sheets or the Notes app, you are in good company. Here is what a spreadsheet does better, what it makes hard, and a free template if you want to keep using one.

What a spreadsheet does better

Where a spreadsheet runs out

Side by side

SpreadsheetKonzertCheck
CostFreeFree, no paid tier
Adding a showType every fieldSearch artist and venue, set the date
RatingWhatever scale you invent0 to 10 in half points
Photos and videos—✓ Three per show
SetlistPaste a link✓ From setlist.fm
FestivalsOne row per act✓ One entry, scored act by act
StatsFormulas you write✓ Automatic
FriendsShare the file✓ Tags, follows and a feed
Upcoming shows—✓ Concerts near you
Custom fields✓ UnlimitedFixed fields plus free text
On a computer✓Phone only

Free concert log template

Sticking with a spreadsheet? Start from ours. It has the columns we found worth keeping after designing KonzertCheck's review form, with one example row to delete. It opens in Excel, Google Sheets (File › Import) and Numbers.

Download the template (CSV)

Columns: Date · Artist · Support acts · Venue · City · Country · Tour or festival · Rating (0-10) · Top song · Top moment · Would see again · Went with · Ticket price · Setlist link · Notes

Three tips if you go the spreadsheet route: write dates as 2026-06-14 so they sort correctly, keep one row per artist rather than per night so festivals and support acts count, and pick one spelling per artist and stick to it.

Questions

What columns should a concert spreadsheet have?
At minimum: date, artist, venue and city. Worth adding: support acts, tour or festival name, a rating, your top song, who you went with, ticket price and a link to the setlist. Keep the date in one ISO format (2026-06-14) so you can sort and count by year.
Can I import my concert spreadsheet into KonzertCheck?
Not automatically yet. You can add past shows with any date, and each one takes under a minute because the artist and venue are searched for you. If you have a long spreadsheet you would like imported, email info@konzertcheck.com; it helps us decide whether to build an importer.
Excel or Google Sheets for a concert log?
Google Sheets, if you want to add a show from your phone on the way home or share the list with the friend you go with. Excel is fine if the file only lives on one computer. The template on this page opens in both.

Or let the app do the typing

Free on iPhone and Android. Your first show takes under a minute.