Counterspell was not in the OP list because it was taken in the 1st Magical Secrets; same thing for cantrips (not in the OP list).
"sword bard spell list" I don't have XGE, is there such a thing? If you have access to an electronic version of it, could you paste it (the sword bard spell list)...