Free music collection spreadsheet template
List every album you own in one place: artist, title, year, genre, format, condition and the shelf or box it lives in. Add what you paid and what it's worth now, and the sheet works out the gain or loss on each one, the value of the whole collection, and a breakdown by format, genre and decade.
Pro Want value, loans and your wishlist worked out for you? See Music Collection Pro →| Collectionrowsandcells.com | |||||||||||||
| Every record, CD and download, with value and shelf.Free template | |||||||||||||
| Artist | Title | Year | Decade | Genre | Format | Condition | Location | Paid | Value | Gain or loss | Rating (1-5) | Notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fleetwood Mac | Rumours | 1,977 | 1970s | Rock | Vinyl LP | VG+ | Shelf A1 | $4.00 | $28.00 | $24.00 | 5 | Thrift store find | |
| Miles Davis | Kind of Blue | 1,959 | 1950s | Jazz | Vinyl LP | NM | Shelf A1 | $32.00 | $35.00 | $3.00 | 5 | 2015 reissue | |
| Pink Floyd | The Dark Side of the Moon | 1,973 | 1970s | Rock | Vinyl LP | VG | Shelf A1 | $18.00 | $40.00 | $22.00 | 5 | Posters missing | |
| Marvin Gaye | What's Going On | 1,971 | 1970s | Soul | Vinyl LP | VG+ | Shelf A2 | $22.00 | $30.00 | $8.00 | 5 | ||
| Joni Mitchell | Blue | 1,971 | 1970s | Folk | Vinyl LP | VG | Shelf A2 | $12.00 | $25.00 | $13.00 | 5 | ||
| Stevie Wonder | Songs in the Key of Life | 1,976 | 1970s | Soul | Vinyl LP | VG+ | Shelf A2 | $25.00 | $35.00 | $10.00 | 4 | Booklet included | |
| The Beatles | Abbey Road | 1,969 | 1960s | Rock | Vinyl LP | VG | Shelf A1 | $20.00 | $45.00 | $25.00 | 5 | Dad's copy | |
| Carole King | Tapestry | 1,971 | 1970s | Pop | Vinyl LP | VG+ | Shelf A2 | $6.00 | $18.00 | $12.00 | 4 | ||
| Prince | Purple Rain | 1,984 | 1980s | Pop | Vinyl LP | NM | Shelf A3 | $28.00 | $32.00 | $4.00 | 5 | ||
| Talking Heads | Remain in Light | 1,980 | 1980s | Rock | Vinyl LP | VG+ | Shelf A3 | $24.00 | $30.00 | $6.00 | 4 | ||
| Nirvana | Nevermind | 1,991 | 1990s | Rock | CD | NM | CD tower | $3.00 | $6.00 | $3.00 | 5 | ||
| Radiohead | OK Computer | 1,997 | 1990s | Rock | Vinyl LP | NM | Shelf A3 | $30.00 | $38.00 | $8.00 | 5 | OKNOTOK edition | |
| Lauryn Hill | The Miseducation of Lauryn Hill | 1,998 | 1990s | Hip-hop | Vinyl LP | NM | Shelf A3 | $34.00 | $40.00 | $6.00 | 5 | ||
| Daft Punk | Discovery | 2,001 | 2000s | Electronic | CD | VG+ | CD tower | $4.00 | $8.00 | $4.00 | 4 | ||
| Amy Winehouse | Back to Black | 2,006 | 2000s | Soul | Vinyl LP | NM | Shelf A4 | $26.00 | $30.00 | $4.00 | 5 | ||
| Adele | 21 | 2,011 | 2010s | Pop | CD | NM | CD tower | $5.00 | $5.00 | $0.00 | 4 | ||
| Kendrick Lamar | To Pimp a Butterfly | 2,015 | 2010s | Hip-hop | Vinyl LP | NM | Shelf A4 | $32.00 | $36.00 | $4.00 | 5 | ||
| Taylor Swift | Folklore | 2,020 | 2020s | Pop | Digital | Music app | $10.00 | 4 | Bought on iTunes | ||||
| Phoebe Bridgers | Punisher | 2,020 | 2020s | Indie | Vinyl LP | M | Shelf A4 | $25.00 | $28.00 | $3.00 | 4 | Still sealed | |
| Bob Dylan | Blood on the Tracks | 1,975 | 1970s | Folk | Vinyl LP | G+ | Shelf A2 | $5.00 | $12.00 | $7.00 | 5 | Ring wear on cover | |
| John Coltrane | A Love Supreme | 1,965 | 1960s | Jazz | Vinyl LP | VG+ | Shelf A1 | $28.00 | $32.00 | $4.00 | 5 | ||
| Michael Jackson | Thriller | 1,982 | 1980s | Pop | Cassette | VG | Box 1 | $2.00 | $6.00 | $4.00 | 4 | ||
| The Cure | Disintegration | 1,989 | 1980s | Rock | CD | VG | CD tower | $3.00 | $7.00 | $4.00 | 4 | ||
| Bruce Springsteen | Born to Run | 1,975 | 1970s | Rock | Vinyl LP | VG | Shelf A1 | $10.00 | $20.00 | $10.00 | 4 | ||
| Beyonce | Renaissance | 2,022 | 2020s | Pop | Digital | Music app | $12.00 | 4 | |||||
| Johnny Cash | At Folsom Prison | 1,968 | 1960s | Country | Vinyl LP | VG | Shelf A2 | $14.00 | $22.00 | $8.00 | 4 | ||
| Dolly Parton | Jolene | 1,974 | 1970s | Country | Vinyl LP | VG+ | Shelf A2 | $16.00 | $24.00 | $8.00 | 4 | ||
| Aphex Twin | Selected Ambient Works 85-92 | 1,992 | 1990s | Electronic | CD | NM | CD tower | $8.00 | $12.00 | $4.00 | 4 | ||
| The Smiths | The Queen Is Dead | 1,986 | 1980s | Indie | Vinyl LP | VG+ | Shelf A3 | $22.00 | $30.00 | $8.00 | 4 | ||
| Arctic Monkeys | AM | 2,013 | 2010s | Indie | Vinyl 7in | NM | Box 1 | $9.00 | $10.00 | $1.00 | 3 | Do I Wanna Know? single | |
| Summaryrowsandcells.com | |||||
| Worked out from your other tabs. Shaded cells are formulas: nothing to type here.Free template | |||||
| Item | Value | ||||
|---|---|---|---|---|---|
| Items in the collection | 30 | ||||
| Total paid | $489.00 | ||||
| Total value | $684.00 | ||||
| Gain or loss (items with both prices) | $217.00 | ||||
| Average paid per item | $16.30 | ||||
| Most valuable item | Abbey Road by The Beatles | ||||
| Its value | $45.00 | ||||
| Items with no value yet | 2 | ||||
| Oldest release year | 1959 | ||||
| Newest release year | 2022 | ||||
| Average rating | 4.4 | ||||
| Rated 5 out of 5 | 14 | ||||
| By Formatrowsandcells.com | |||||
| Worked out from your other tabs. Shaded cells are formulas: nothing to type here.Free template | |||||
| Format | Items | Paid | Value | Share | |
|---|---|---|---|---|---|
| Vinyl LP | 21 | $433.00 | $630.00 | 70% | |
| Vinyl 7in | 1 | $9.00 | $10.00 | 3.3% | |
| CD | 5 | $23.00 | $38.00 | 16.7% | |
| Cassette | 1 | $2.00 | $6.00 | 3.3% | |
| Digital | 2 | $22.00 | $0.00 | 6.7% | |
| Other | 0 | $0.00 | $0.00 | 0% | |
| Total | 30 | $489.00 | $684.00 | 100% | |
| By Genrerowsandcells.com | |||||
| Worked out from your other tabs. Shaded cells are formulas: nothing to type here.Free template | |||||
| Genre | Items | Paid | Value | Share | |
|---|---|---|---|---|---|
| Rock | 8 | $112.00 | $214.00 | 26.7% | |
| Pop | 6 | $63.00 | $61.00 | 20% | |
| Soul | 3 | $73.00 | $95.00 | 10% | |
| Jazz | 2 | $60.00 | $67.00 | 6.7% | |
| Hip-hop | 2 | $66.00 | $76.00 | 6.7% | |
| Folk | 2 | $17.00 | $37.00 | 6.7% | |
| Country | 2 | $30.00 | $46.00 | 6.7% | |
| Electronic | 2 | $12.00 | $20.00 | 6.7% | |
| Indie | 3 | $56.00 | $68.00 | 10% | |
| Classical | 0 | $0.00 | $0.00 | 0% | |
| Other | 0 | $0.00 | $0.00 | 0% | |
| Total | 30 | $489.00 | $684.00 | 100% | |
| By Decaderowsandcells.com | |||||
| Worked out from your other tabs. Shaded cells are formulas: nothing to type here.Free template | |||||
| Decade | Items | Value | Avg rating | Chart | |
|---|---|---|---|---|---|
| 1950s | 1 | $35.00 | 5 | ■ | |
| 1960s | 3 | $99.00 | 4.7 | ■■■ | |
| 1970s | 9 | $232.00 | 4.6 | ■■■■■■■■■ | |
| 1980s | 5 | $105.00 | 4.2 | ■■■■■ | |
| 1990s | 4 | $96.00 | 4.8 | ■■■■ | |
| 2000s | 2 | $38.00 | 4.5 | ■■ | |
| 2010s | 3 | $51.00 | 4 | ■■■ | |
| 2020s | 3 | $28.00 | 4 | ■■■ | |
What's inside
- One row per album with artist, title, year, genre, format, condition, shelf, price paid, value, rating and notes
- Gain or loss on each item, worked out from what you paid and what it's worth now
- A summary with total paid, total value, your most valuable item and how many items still need a value
- Items, money paid and value by format (vinyl, CD, cassette, digital) and by genre
- A decade breakdown with a simple bar so you can see which era your shelves lean to
- Room for 80 albums, and it works in Google Sheets and Excel
How to use it
Download your copy
Click "Free download" to save the .xlsx file. It opens in Excel, or in Google Sheets: open a blank sheet (sheets.new) and choose File, then Import, then Upload.
Clear the samples
On the Collection tab, select the sample rows from Artist to Notes and press Delete. Decade and Gain or loss are formulas: deleting the typed cells leaves them in place, and they go blank.
Add your albums
Type one album per row. Start with artist, title and format, then fill in year, genre and condition when you have the record in your hands.
Note where it lives
Use Location for the shelf, crate, box or app, like Shelf A1 or CD tower. When you lend something out or rearrange, change it here and you'll always know where to look.
Add prices and values
Type what you paid in Paid and today's going price in Value. Leave Value blank until you've looked it up; the Summary counts how many still need one.
Check the summary tabs
Summary, By Format, By Genre and By Decade update as you type. Make sure the genre and format names on those tabs match the ones you use in the list.
Tips
Use standard grades for records
Collectors grade vinyl as M (mint), NM, VG+, VG, G+, G and P (poor). Grade the record and sleeve the same way each time so the values you look up compare fairly.
Look up values in batches
Prices change slowly, so you don't need to update every week. Once or twice a year, check recent sold prices for your top items on a marketplace like Discogs or eBay and update Value.
Sort to find things fast
Use Data, then Sort range on Artist for an A to Z list, or on Location to see what's on each shelf. Sort on Value, Z to A, to see your most valuable items first.
Keep a photo for insurance
For valuable items, take a photo of the cover and the label and note the catalogue number in Notes. Ask your insurer what they need if you want a collection covered.
Questions
What should a music collection spreadsheet include?
At least the artist, title and format. Most collectors add the year, genre, condition, where it's stored, what they paid and what it's worth. This template has all of those, plus a rating and notes.
Can I use it for vinyl records only?
Yes. Use it as a vinyl record spreadsheet and set Format to Vinyl LP or Vinyl 7in for each row. You can rename the formats on the By Format tab, for example to 12in single or Box set.
How do I find out what my records are worth?
Look at recent sold prices for the same pressing, not asking prices. Discogs and eBay sold listings are common places to check. The exact pressing and condition make a big difference.
Can I track songs instead of albums?
Yes. Put the song in Title and the album in Notes. For a large digital library, a music app's own export may be quicker; this sheet suits a collection you buy and keep.
How do I add more than 80 albums?
Insert rows above the last row of the list and copy the Decade and Gain or loss formulas down. Then stretch the ranges on the summary tabs to the new last row.
Does it work in Excel?
Yes. Download the .xlsx file and open it in Excel. All the formulas work the same way in Excel and Google Sheets.
Is this music spreadsheet template free?
Yes. Download the .xlsx file and open it in Excel or Google Sheets. No sign-up, no email.
Pro version
Music Collection Pro
Catalogue every record, CD, tape and download once, and see what it's worth, who has what on loan, what to buy next and what you actually play.
Your whole collection in one list
Vinyl, CDs, cassettes, box sets and digital on one Collection tab, with dropdowns for genre, format, shelf and grade so it stays tidy as it grows.
Know what it's worth
Total value, what you paid and the gain or loss on every album. A value check flags albums with no value yet, or a value older than you'd like.
Condition at a glance
Grade the record and the sleeve with the usual M, NM, VG+ scale. Colour chips show the worn ones, and Stats counts your collection by grade.
Never lose a record to a friend
Loans keeps who borrowed what and when it's due back. Overdue and Due soon show on the Loans tab, on the album's row and on the Dashboard.
A wishlist that tells you when to buy
Note the most you'd pay and the best price you've seen. Buy now lights up when a price hits your target, and it warns you if you already own it.
See what you really play
Log a play in two clicks. Plays and Last played fill in on each album, and the Dashboard shows your most played, spending by month and value by format.
| Free | Pro |
|---|---|
| Album list with year, genre, format, condition and shelf | Collection with dropdowns, label, catalogue number and separate media and sleeve grades |
| Paid, value and gain or loss | Plus a value check that flags missing or out-of-date values |
| Totals by format, genre and decade | Stats by format, genre, decade, condition and location, plus month by month |
| · | Dashboard with value, spending, most valuable and most played |
| · | Wishlist with your price, best price seen and Buy now flags |
| · | Loans: who has what, due dates and overdue flags |
| · | Listening log with plays and last played on every album |
| · | Setup tab for your own genres, formats, shelves and borrowers |
$12 one-time
8 tabs: Start Here, Dashboard, Collection, Wishlist, Loans, Listening Log, Stats and Setup. You get two copies: one filled in with a sample collection of 50 albums so you can see it working, and a blank one ready for your own.
Buy now- Instant download after checkout
- Works in Google Sheets and Excel
- Yours to keep and reuse every year