Select Page

Music Toolbox

A spreadsheet with usefull visualisation tools for music Learning. 

Homepage

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_logo_(2014-2020).svg

Google Sheets

Online Spreadsheet software by Google

 

Google_Sheets_logo_(2014-2020).svg

Google Forms

I used Google Forms to create exercices with notation

 

Google_Sheets_logo_(2014-2020).svg

Looker Studio

I used Looker studio to display Scores for the exercices

 

Screenshots

Stats

Script

Scales / Chord / Intervals visualisation

Different Tunings