Skip to content


Clear all

Transpose a Bunch of Chords At Once

Eminent Member
Joined: 16 years ago
Posts: 48
Topic starter  

I wrote a little utility to transpose a bunch of chords all at once that I thought I'd share. The idea was that you key in all of the chords for a song, then pick the number of half steps (capo placement) and see where all of the chords land. That way, you don't start transposing and half way through, you find out that there is a real stinker of a chord that could have been eliminated if you chose another key.

I also wanted it to be simple and MS Excel based. To use it, you just open the Excel sheet, key in chords under the "Original" column and pick a number of half steps (positive or negative). All of the chords are transposed in the "New" column. The whole thing is built as a macro, so you have to enable macros in Excel to get it to work.

I put the Excel sheet here:

Let me know how it works for you and if you find any bugs.

Praise the LORD with the harp; make music to him on the ten-stringed lyre. Sing to him a new song; play skillfully, and shout for joy. For the word of the LORD is right and true; he is faithful in all he does. Psalm 33:2-4

Estimable Member
Joined: 15 years ago
Posts: 122

I have this tool stored in my favourites.