Music Toolbox
A spreadsheet with usefull visualisation tools for music Learning.
Description
I built this spreadsheet during my music learning journey to have a easier access to some informations and i added tools along the way.
Finding visualisations of scales, chords and stuff on piano and guitar involve a lot of searching and this sheets allow to find them very easily. It’s not very visually appealing because after all it’s a spreadsheet but you find the informations you need fast.
You want to visualise how to play Locrian M2 mode in the key of C on the piano and on a Guitar tuned in open G ? That’s litterraly 3 clicks ! And as a bonus you’ll have the notes of the scale for each key ! You can’t beat that with Google Search !
There’s also a Randomizer if you’re not sure what to practice, a sheet to draw on Diatonic Harps, templates to print a guitar neck with or without content.
There are even some exercices to learn modes ! ( The exercices and the results are not covered by the licence you can train but won’t have Edit access to those.)
Last but not least there’s a list of songs for eartraining with links to videos.
This file is Licenced under WTFPL, i do not offer support for it, once you have your copy you do what you want.
As this spreadsheet have been widely shared, i removed all the scripts and it now works only with conditionnal formatting and formulas to avoid any security concerns.
Tip me a cofee if you like this tool 🙂
Software involved
Google Sheets
Online Spreadsheet software by Google
Google Forms
I used Google Forms to create exercices with notation
Looker Studio
I used Looker studio to display Scores for the exercices