Welcome to the msf-googlesheet-tools wiki!

Contained within this wiki are useful snippets of googlesheet formulas for working with the msf.gg roster.csv file

Known Problems

Member names with non-ascii values

Use of MSF colors or unicode causes the roster export to return weird values.

You'll probably need to create a translation lookup sheet to map the exported names to human readable ones.

Query in googlesheet doesn't support header names

Even though the examples at https://developers.google.com/chart/interactive/docs/querylanguage indicate that header names should be usable in queries this does not appear to work.

You must instead use the Column's A-Z notation.