Search Member details

Searching through any file is going to be very time consuming and isn’t appropriate for web site searching. For reasonable performance, the data should be imported into a mySQL table which can be searched much more efficiently. If you imported a Word document straight into mySQL, every line would be in a single field. While it’s feasible to search within each field, again it’ll be more performative if each discrete data element were in its own field. That means it’d be better to convert first to a spreadsheet before importing into mySQL.

For optimal maintainability, it’d be better to no longer maintain the list in Word and instead directly manage members on the mySQL table. There are various membership plugins that provide such functionality. You’d have to import the data into a table that’s compatible with how the chosen plugin manages its data.