Banjo Hangout Logo
Banjo Hangout Logo

Premier Sponsors

Banjo Lovers Online

Free Excel App to find best key for your voice and any song

Posted by optionzz on Friday, February 12, 2010


Recently, in a local slow jams, we discussed the topic: "Given my singing range, and the range of notes of a specific song, how do I find out which keys would work for me to sing in?" Lots of folks seem to think there is one, natural key, for them to sing any song in: not so!  The question then goes on: "So, if I can only play in (1 to 5 favorite keys) what capoing would I do to achieve the proper voice range match and still finger chords in my favorite keys?"

I spent awhile researching this topic, and while I'm not a strong musician, I'm reasonably good at algorithms :) so I worked out a spreadsheet for my jam group that makes it easy to find YOUR best key to sing in for a specific song. It goes a step farther and offers suggestions of how to capo up to play in any of your five favorite keys. Thus, if it tells you need to sing a song in Bb (yuk, who wants to play in that key?!) it will suggest that you capo up 3 and play in G. No magic here, but good to help beginners learn.

If you want a copy of the current version of the spreasheet, please email me off list and I'll send it as an attachment. The only cost, is I'd like feedback as to problems, bugs, or suggestions for improvement. I've included 7 songs as examples. Just type in a few items, and it will tell you singing keys and capoing. The first tab in the excel file has full instructions. 
This first version handles only songs in major keys; I'm working on minors for the next round, and will notify all holders of the first version when the next release is available (still for free).

Thanks to all of you who have provided your knowledge, encouragement and jokes!


2 comments on “Free Excel App to find best key for your voice and any song”

bmoseley Says:
Thursday, January 13, 2011 @9:53:58 PM

I'd sure like that Spreadsheet..

prchr111 Says:
Wednesday, October 8, 2014 @12:34:16 PM

May I please have a copy of the excell or PDF file? You can send it to prchr111@ yahoo. Com Thank you.

You must sign into your myHangout account before you can post comments.

More posts from optionzz

Newest Posts

More >  

Hide these ads: join the Players Union!

Hangout Network Help

View All Topics  |  View Categories