The (fake) student directory listed below is populated from a local Student Information System (SIS) database CSV extract — scheduled using Navicat Premium (though there are also free options for this) — that is then synced to Google Sheets using Amplified Labs’ Local Hero, and embedded in this WordPress page using the Awesome Table gadget by Romain Vailard.  This same approach can be used with a Google Sites page.

Normally, the underlying Google Sheet would be shared privately with the faculty group in a school.  It is public here for demonstration purposes.