Here is what I want. I have an old copy of Excel, but it seems to be an overkill.
Columns: Song name | artist | Date | Tempo | Genre
I'd like to list my 600+ songs (and growing) and be able to click on the heading of any column, click A-Z (or whatever) and have it alphabetize by that column.
If someone asks for some 1980s songs, or something by Adele, or something reggae, I could click the column, scroll and get answers.
When I'm gigging, and in the zone, it's hard to remember all the songs we do.
Excel has a million columns, I can't see needing more than 6, 10 to be greedy.
I'm good at music, but have very limited experience with spreadsheets. I don't want a steep learning curve
Here is what I want. I have an old copy of Excel, but it seems to be an overkill.
Columns: Song name | artist | Date | Tempo | Genre
Notes, an Excel spreadsheet is an ideal solution for what you need. I put this demo together in 4 minutes. The left spreadsheet is sorted on Index Number (a simple count of your songs) and on the right is sorted on Tempo. 600 songs is no problem. If you need help setting up your spreadsheet, send PM --Steve
Last edited by Bass Thumper; 10/06/2307:29 PM.
https://soundcloud.com/user-646279677 BiaB 2026 Windows For me there’s no better place in the band than to have one leg in the harmony world and the other in the percussive. Thank you Paul Tutmarc and Leo Fender.
I don't know what version my Microsoft Office is. It's from 2002. I bought it with an XP ThinkPad computer, and came on CDs.
I was thinking about just loading a spreadsheet, and not the entire office app. My gigging computers (Win 11) have a minimum amount of software on them, and once setup, never go on the Internet. I have a USB external CD/DVD drive, so I can install it.
I won't use Word, PowerPoint or any of the other apps, so it seems to be akin to bloatware to install them all, but since they were written for XP, I suppose their footprint won't be that big.
Notes, my Office 97 was written for XP and came on a CD. You don't have to load the entire software and in fact you can't install all of it. You would just install Access, the database program. I know that works in Win 10 but I don't know about Win 11.
I have all of my CDs and Vinyl on a database that was started around 1997 as well as all of my sheet music and music books. Both are still going strong today.
It used to be that if you sorted a spreadsheet but didn't highlight the entire sheet your data would get scrambled. I don't know if that is the case today as I converted the spreadsheet to a database program years ago. Maybe Steve can answer that question.
Personally I would use a database.
Dad, how will I know when I've become an adult.
When your day is ruined because they rearranged the grocery store.
64 bit Win 10 Pro, the latest BiaB/RB, Roland Octa-Capture audio interface, a ton of software/hardware
A database would be ideal if you want to create a script or query or program to solicit results. Something like: "select songs where artist is 'boz Scaggs', order by date." or "select songs where ( (date > 1-1-1980) and (date < 1-1-1990) ), order by date, ascending".
A spreadsheet would be good also to just sort everything by the selected column, e.g. choose the date column and select 'sort highest to lowest', then scroll down until you find values in the date range you are looking for.
Separately, Microsoft Office 2002? Wow, 20+ years is an eternity in this industry. Did it run on vacuum tubes? (ha ha , just joking).
Explore the different options and decide on a solution that works best for you. Also consider that eventually older software will ultimately become obsolete and incompatible with current systems. Just a fact.
BIAB & RB2026 Win.(Audiophile), Windows 10 Pro & Windows 11, Cakewalk Bandlab, Izotope Prod.Bundle, Roland RD-1000, Synthogy Ivory, Session Keys Grand S & Electric R, Kontakt, Focusrite 18i20, KetronSD2, NS40M, Pioneer Active Monitors.
Mario, I put the CD in, and indeed, I can just install Excel.
So it's solved. Database might be better, but this is quick, easy, and will do what I want.
2002 still runs, so for the minimal uses I have for it, I don't need to subscribe to anything. And, no, it doesn't run on vacuum tubes, but it has these big magnetic tape reels that are constantly going back and forth
Great, Just make sure that in your sort settings, the other columns follow the selected column and are not independent.
BIAB & RB2026 Win.(Audiophile), Windows 10 Pro & Windows 11, Cakewalk Bandlab, Izotope Prod.Bundle, Roland RD-1000, Synthogy Ivory, Session Keys Grand S & Electric R, Kontakt, Focusrite 18i20, KetronSD2, NS40M, Pioneer Active Monitors.
The advantage of a database is that you can query by more than one column if you want.
Example: Do I have any songs where Adele is singing reggae at a tempo less than 100?
No doubt, relational databases have advantages over spreadsheets (and vice versa).
This screen shot shows how I would do this if I were gigging on stage. The spreadsheet would have 6 individual tabs, one for each sort parameter; Index, Song Name . . . Genre and the sorting would be done at home. I wouldn't want to fiddle with sorting or programming inbetween songs on stage; too many things can go wrong.
Then I'd have a backup of the spreadsheet on a thumbdrive in my pocket.
Finally, for belts and suspenders, I'd print each of the spreadsheet tabs, punch them and place them in a 3-ring binder with the 6 [physical] tabs labeled from above. If required additional hard copies could be made for the venue manager and band mates so everyone has the same info. And no worries if a B&W printer is used because the sort parameters are all bold.
Icing on the cake is Excel is relatively easy to use and because of it's popularity, there are tons of people available to help if problems happen. Plus it's a snap to communicate online what your spreadsheet looks like as I have done here . . . just my 2 cents plus a nickel.
https://soundcloud.com/user-646279677 BiaB 2026 Windows For me there’s no better place in the band than to have one leg in the harmony world and the other in the percussive. Thank you Paul Tutmarc and Leo Fender.
I wouldn't want to fiddle with sorting or programming in between songs on stage; too many things can go wrong.
What can go wrong? It's 5 mouse clicks.
File > Data > Sort > select the tab you want to sort by > ascending or descending
I think what he wants to do is while on his 15 to 20 gigs per month select from his 600 songs on the fly as people request a song. He isn't programming anything. If somebody wants Elvis, it's
File - Data - Sort - Artist - Descending, and Elvis will be near the top. That would take about 5 seconds and Leilani can talk to the crowd while he does it.
So just to toss in a wrench, as I am normally a huge wrench tosser, you say you carry a thumb drive as backup. Okay. What if you need your backup and you pop it in to find that the thumb drive is corrupted? You have a backup to the backup? (To the backup, to the backup...)
The much shorter answer is "Just remember them." If you can't remember all of them, your list it too long. I mean, you need to have a file showing what key a song is in? It's in the same key you have been playing it in for 50 years.
It's just for when someone comes up and says something like, “Do you do any _______?” (Insert artist name here).
For gigging., I have a loose-leaf notebook with paper pages. It has song titles sorted by genre; like hard rock, medium rock, shuffle rock, reggae, calypso/soca, country, disco/dance, up-tempo standards, slow rock, ballroom dance, and a dozen more, so while playing a song, if it looks like they need another hard rock song, I can flip to that page to jog my memory.
I can do that without getting completely out of the zone.
A few weeks ago, someone came up and asked if we do anything by a certain artist. We apologized and said we didn't. But actually we did.
So my idea is to say, “Let me see”, open the spreadsheet, click A->Z on top of the relevant column, and scroll. There are probably more efficient ways to do it, but it doesn't happen that often, so this will suffice.
I've got it started, and I realize for a few songs, I'll have to double the entry, if it was made popular by two artists. But that's OK.
We have 686 songs in our repertoire now, so it'll take some time to get it done, but I'm in no hurry.
The main thing I'm investigating now is how to get the top line, where I put the headings, not to move when I alphabetize a column. I'm sure it's something simple, but the help screens in Excel 2002 leaves a lot to be desired, and most on-line help is geared towards much newer models.
My temporary solution is to start the headings with a ! Symbol. So it's "! Title" or "! Artist" I'm sure there is a better way, and when I found out, I can make the change.
And yes, Eddie, I am aware the thumb drive can be corrupted, but it's the backup of the backup. We can get by with 2 computers, and we have 3 up and running at all times. I use ThinkPad computers, which are extremely dependable. Since 2002 when I went to computer, I've had to go to two computers only twice. I carry a fourth computer, it's one of the old ThinkPad XPs. I turn it on once a month or so to update, charge the battery and make sure it's working, but between those events, we usually learn new songs, that's where the thumb drive which is constantly updated comes into play.
Furthermore, I also back up all our backing tracks and charts to the cloud, just in case. I can quickly replace instruments, but the data is not quickly replaceable. The show MUST go on.
I know, it's the Department of Redundancy Department tactics.
Here is an idea, just create a text file in any application, including notepad which is free with any OS. Enter the list you have. Then use the Ctrl-F keystoke to "Find" the words you are looking for in the file. It will tell you immediately if the words are present , how many time they appear and then you can arrow down through each item.
Just setup a Google account and use Google sheets. That way it is highly mobile you can find it on any device from phone to laptop to whatever. Oh and it’s free
HP Win 11 12 gig ram, Mac mini Sonoma with 16 gig of ram, BiaB/RB 2026, Reaper 7, Harrison Mixbus 11 , Presonus Audiobox USB96
Have you looked at MobileSheets? It's on several platforms. I use it on Android ... it keeps all my .pdf music, categorised by group, allows selection from alpha index tabs, keys, genres. It'll batch import many files at a time.
I believe iGigBook does similar, but I've not used it
Jazz relative beginner, starting at a much older age than was helpful. AVL:MXE Linux; Windows 11 BIAB2026 Audiophile, a bunch of other software. Kawai MP6, Ui24R, Focusrite Saffire Pro40 and Scarletts .
Re: BTW: I just looked at a thread I started and in my first post I see the expected option Mark as Resolved. Do you see that in your starting post here?
BIAB 2026 Win Audiophile. Software: Fender Studio One 8, Swam horns, Acoustica-7, Notion 6, Song Master Pro, Win 11 Home. Hardware: Intel i9, 32 Gb; Fender Quantom HD8 & Faderport 8, Royer 121, Adam Sub8 & Neumann 120 monitors.
Band-in-a-Box® 2026 for Mac - Special Offers End at 11:59pm PDT on Friday, May 15th, 2026!
Order before 11:59pm PDT on Friday, May 15th and SAVE up to 50% on most Band-in-a-Box® version 2026 for Mac Upgrade packages... and that's not all! With your version 2026 for Mac purchase, we'll include a Bonus PAK full of great new Add-ons FREE! Upgrade to the 2026 49-PAK to receive even more NEW Add-ons including 20 additional RealTracks... that's 222 NEW RealTracks available with version Band-in-a-Box® 2026 for Mac!
Upgrade to Band-in-a-Box® 2026 for Mac® today for as little as $49! Check out the Band-in-a-Box® packages page for all available purchase options.
Learn more about the Free Bonus PAK and 49-PAK here.
If you have any questions about which package is the best option for you, just let us know. We're here to help!
202 New RealTracks Released with Band-in-a-Box 2026!
With Band-in-a-Box® 2026, we've released 202 incredible new RealTracks (in sets 468-488) in a variety of genres—featuring your most requested styles!
Jazz, Funk & World (Sets 468-475):
Our new jazz, funk & blues RealTracks include a groovin’ collection of RealTracks and RealDrums! These include more requested “soul jazz” RealTracks featuring artists Neil Swainson (bass), Charles Treadway (organ), Brent Mason (guitar), and Wes Little (drums). There are new “smooth jazz” styles (4), which include a RealTracks first: muted trumpet, as well as slick new smooth jazz brushes options for drums. Blues lovers will be thrilled—there are more “classic acoustic blues” styles, including guitar (5), bass (4), and drums (10) with blues master Colin Linden, featuring understated and tasty background acoustic soloing, plus brushes drums and acoustic bass. There are also new electric blues RealTracks, including electric blues with PG favorite Johnny Hiland (3) and soulful electric slide guitar from Colin Linden (4). If you love funk & gospel, there are great new options this year, including gospel organ (3) from Charles Treadway, as well as new funk, tango, and rock ’n’ roll drums (3) and bass (1). And for big, bold arrangements, we have uptempo soul horns (4) featuring a three-part hip horn section with options for a full mix or stems of each individual horn — plus an accompanying rhythm section (4) of drums, bass, guitar, and electric piano!
Rock & Pop (Sets 476–482):
Our new rock & pop RealTracks bring a powerful mix of requested favorites, fresh genres, and modern chart-inspired styles! We have more of our popular “Producer Layered Acoustic Guitars (15)” featuring Band-in-a-Box favorite Brent Mason. We’ve continued our much-requested disco styles (10), and added new Celtic guitar (5) with a more basic, accessible approach than our previous Drop-D or DADGAD offerings. There are also highly requested yacht rock styles (17), inspired by the smooth, polished soft-rock sound of the late ’70s and early ’80s — laid-back grooves, silky electric pianos, warm textures, elegant harmonic movement, and pristine production aesthetics. Fans of heavier styles will love our new glam metal (13), capturing the flashy, high-energy sound of ’80s arena-ready guitar rock. We also have a set of rootsy modern-folk rock (18), with a warm, organic sound combining contemporary folk textures and driving acoustic strumming. And we’ve added lots of new modern pop styles (16) — the kinds of sounds you’re hearing on the radio today, featuring exciting new drums, synths, and cutting-edge RealTracks arrangements.
Country, & Americana (Sets 483–488):
Our new country & Americana RealTracks deliver a rich collection of acoustic, electric, and roots-inspired styles! We have new country pop (9) with legendary guitarist Brent Mason. There is also a potpourri (14) of bouzouki, guitars, banjo, and more, perfect for adding texture and character to contemporary acoustic arrangements. We’ve added funky country guitar (5) with PG favorite Brent Mason, along with classic pedal steel styles (5) featuring steel great Doug Jernigan. There are more country songwriter styles (8) that provide intimate, rootsy foundations for storytelling and modern Americana writing. Finally, we have “background soloing” acoustic guitar (12) with Brent Mason — simpler, but still very tasty acoustic lines designed to sit beautifully behind vocals or act as a subtle standalone solo part.
And, if you are looking for more, the 2026 49-PAK (for $49) includes an impressive collection of 20 bonus RealTracks, featuring exciting and inspiring additions to add to your RealTracks library. You'll get new country-rhythm guitar styles from PG Music favorites Johnny Hiland and Brent Mason, along with modern-pop grooves that capture today’s radio-ready sound! There are also new indie-folk styles with guitar, bass, 6-string bass used as a high-chording instrument, acoustic guitar, and banjo. Plus, dedicated "cymbal fills" RealDrums provide an added layer that work very well with low-key folky styles with other percussion.
The 2026 49-PAK is loaded with other great new add-ons as well. Learn more about the 2026 49-PAK!
2026 Free Bonus PAK & 49-PAK for Band-in-a-Box® 2026 for Mac®!
With your version 2026 for Mac Pro, MegaPAK, UltraPAK, UltraPAK+, Audiophile Edition or PlusPAK purchase, we'll include a Bonus PAK full of great new Add-ons for FREE! Or upgrade to the 2026 49-PAK for only $49 to receive even more NEW Add-ons including 20 additional RealTracks!
These PAKs are loaded with additional add-ons to supercharge your Band-in-a-Box®!
This Free Bonus PAK includes:
The 2026 RealCombos Booster PAK:
-For Pro customers, this includes 27 new RealTracks and 23 new RealStyles.
-For MegaPAK customers, this includes 25 new RealTracks and 23 new RealStyles.
-For UltraPAK customers, this includes 12 new RealStyles.
MIDI Styles Set 92: Look Ma! More MIDI 15: Latin Jazz
MIDI SuperTracks Set 46: Piano & Organ
Instrumental Studies Set 24: Groovin' Blues Soloing
Artist Performance Set 19: Songs with Vocals 9
Playable RealTracks Set 5
RealDrums Stems Set 9: Cool Brushes
SynthMaster Sounds Set 1 (with audio demos)
iOS Android Band-in-a-Box® App
Looking for more great add-ons, then upgrade to the 2026 49-PAK for just $49 and you'll get:
20 Bonus Unreleased RealTracks and RealDrums with 20 RealStyle.
FLAC Files (lossless audio files) for the 20 Bonus Unreleased RealTracks and RealDrums
MIDI Styles Set 93: Look Ma! More MIDI 16: SynthMaster
MIDI SuperTracks Set 47: More SynthMaster
Instrumental Studies 25 - Soul Jazz Guitar Soloing
Artist Performance Set 20: Songs with Vocals 10
RealDrums Stems Set 10: Groovin' Sticks
SynthMaster Sounds & Styles Set 2 (sounds & styles with audio demos)
XPro & Xtra Styles PAK Sets On Sale Now - Until May 15, 2026!
All of our XPro Styles PAKs and Xtra Styles PAKs are on sale until May 15th, 2026!
It's the perfect time to expand your Band-in-a-Box® style library with XPro and Xtra Styles PAKs. These additional styles for Band-in-a-Box® offer a wide range of genres designed to fit seamlessly into your projects. Each style is professionally arranged and mixed, helping enhance your songs while saving you time.
What are XPro Styles and Xtra Styles PAKs?
XPro Styles PAKs are styles that work with any version (Pro, MegaPAK, UltraPAK, UltraPAK+, or Audiophile Edition) of Band-in-a-Box® 2025 (or higher). XPro Styles PAKS 1-10 includes 1,000 styles!
Xtra Styles PAKs are styles that work with the UltraPAK, UltraPAK+, or Audiophile Edition of Band-in-a-Box® 2025 (or higher). Xtra Styles PAKs 1-21 includes 3,700 styles (and 35 MIDI styles)!
The XPro & Xtra Styles PAKs are not included in any Band-in-a-Box® package.
The XPro Styles PAKs 1-10 are available for only $29 ea (reg. $49 ea), or get them all in the XPro Styles PAK Bundle for only $149 (reg. $299)! Listen to demos and order now! For Mac or for Windows.
The Xtra Styles PAKs 1-21 are available for only $29 ea (reg. $49 ea), or get them all in the Xtra Styles PAK Bundle for only $199 (reg. $349)! Listen to demos and order now! For Mac or for Windows.
Note: XPro Styles PAKs require Band-in-a-Box® 2025 or higher and are compatible with ANY package, including the Pro, MegaPAK, UltraPAK, UltraPAK+, and Audiophile Edition.
The Xtra Styles require the UltraPAK, UltraPAK+, or Audiophile Edition of Band-in-a-Box®. (Xtra Styles PAK 19 requires the 2025 or higher UltraPAK, UltraPAK+, or Audiophile Edition. They will not work with the Pro or MegaPAK version as they require the RealTracks included in the UltraPAK, UltraPAK+, or Audiophile Edition.
Supercharge your Band-in-a-Box today with XPro Styles PAKs and Xtra Styles PAK Sets!
With the release of Band-in-a-Box® 2026 for Mac, we’re rolling out a collection of brand-new videos on our YouTube channel. We’ll keep this forum post updated so you can easily find all the latest videos in one convenient spot.
Whether you're exploring new features, checking out the latest RealTracks or Style PAKs, this is your go-to guide for Band-in-a-Box® 2026.
Band-in-a-Box® 2026 for Mac is here and it is packed with major new features! There’s a new modern look, a GUI redesign to all areas of the program including toolbars, windows, workflow and more. There’s a Multi-view layout for organizing multiple windows. A standout addition is the powerful AI-Notes feature, which uses AI neural-net technology to transcribe polyphonic audio into MIDI—entire mixes or individual instruments—making it easy to study, view, and play parts from any song. And that’s just the beginning—there are over 100 new features in this exciting release.
Along with version 2026, we've released an incredible lineup of new content! There's 202 new RealTracks, brand-new RealStyles, MIDI SuperTracks, Instrumental Studies, “Songs with Vocals” Artist Performance Sets, Playable RealTracks Set 5, two new RealDrums Stems sets, XPro Styles PAK 10, Xtra Styles PAK 21, and much more!
Special Offers
Upgrade to Band-in-a-Box® 2026 for Mac and save up to 50% on most upgrade packages during our special offer—available until May 15, 2026. Visit our Band-in-a-Box® packages page to explore all available upgrade options.
2026 Free Bonus PAK & 49-PAK Add-ons
Our Free Bonus PAK and 49-PAK are loaded with amazing add-ons! The Free Bonus PAK is included with most Band-in-a-Box® 2026 for Mac packages, but you can unlock even more—including 20 unreleased RealTracks—by upgrading to the 2026 49-PAK for just $49.
One of our representatives will be happy to help you over the phone. Our hours of operation are from
6:00AM to 6:00PM PST (GMT -8) Monday thru Friday, and 8:00AM to 4:00PM PST Saturday. We are closed Sunday. You can also send us your questions via email.
One of our representatives will be happy to help you on our Live Chat or by email. Our hours of operation are from
6:00AM to 6:00PM PST (GMT -8) Monday thru Friday; 8:00AM to 4:00PM PST (GMT -8) Saturday; Closed Sunday.
Norton Music
Dansk
Deutsch - Windows
Español
Français - Windows
Italiano - Windows
Nederlands
Polski
Português
Svenskt
русский
Japanese
Simplified Chinese
Traditional Chinese
Korean