Writing query to extract specific data and export to excel sheets

I have some data in the following format,

1.There are n columns with various locations.
2.Each location row is associated with a unique tooken.
3.Just so you know, this data has been loaded already and n columns are associated(related) with their respective tokens.

TASK

Export & create 3 excel sheets
Sheet 1: List of Tokens that have more than 5 location matches in any form of direct relation.
Sheet 2: List of Tokens that have more than 1 & up to 5 location matches in any form of direct relation.
Sheet 3: List of Tokens that have 1 location match in any form of direct relation.